Share via

Microsoft Lists app and using formulas

Anonymous
2023-05-18T10:43:59+00:00

Hi

I'm using Microsoft Lists via the desktop app and I'm trying to create what I though would be a simple formula, similar to what I would do in excel but I'm facing the following error "the validation formula can refer to this column and not others"

I've only just starting Lists so I'm sure it's user error.

I have a column (Task Complete) that I mark via choices "Yes", "No" and "In progress"

I want my other column (Date Completed) to auto fill todays date when I choose "Yes"

Is this possible or am I asking too much of this app?

Thanks

***moved from Microsoft 365 and Office/Other/For home/Other***

Microsoft 365 and Office | Install, redeem, activate | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-05-19T03:09:22+00:00

    Dear Sly Dawg Mackay,

    Thank you for posting your query in our community.

    Your question is "Return Today date when "complete status" is "Yes"".

    From our test, you may try if this formula is working.

    =IF([Task Complete]="Yes",TODAY())

    Let me know if there is any further problems.

    Have a nice day!

    Best regards,

    Sophia

    Was this answer helpful?

    0 comments