Share via

Calculated column in microsoft lists

Anonymous
2023-05-01T09:20:50+00:00

Microsoft lists:

I want to create a calculated column "Stage", value of which will be based on "process last date" column(date column)

If today's date is less than "process last date column", "Stage" column should have "In progress" text, otherwise "Completed" text

Tried using calculated column using IF function but it shows syntax error. plz help

Microsoft 365 and Office | SharePoint | For business | Windows

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

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-05-01T11:14:44+00:00

    Hi Atish_nameunavailable,

    your question Calculated column in Microsoft lists

    Your requirement may not be able to be achieved as calculated. columns doesn’t support "TODAY" function. TODAY function - Microsoft Support 

    I found a workaround for you. We suggest you crating tow views named “in progress” and “Completed "displaying the different stages. 

    For the view “in progress” you can edit it and filter it as bellow.

    For the view “completed “ you can filter it like this calculated columns cannot be archive it.

    Thank you best regards

    0 comments
  2. Anonymous
    2023-05-02T21:49:11+00:00

    I have used the Today function in SharePoint Calculated columns and it works just fine.

    This formula works for me on my SharePoint:

    =IF([Meeting Date]>TODAY(),"In Progress","Completed")
    0 comments
  3. Anonymous
    2023-05-03T03:37:18+00:00

    Hi Atish_nameunavailable,

    Good day!

    I have tested the formula“ =IF([Meeting Date]>TODAY(),"In Progress","Completed")” provided by Mike_V.. and it is working fine. In calculated column, it doesn’t support to use [TODAY], but it seems Today() format can be used. Please try the same formula and let us know if the issue can be resolved.

    Have a good day !

    Best regards,

    0 comments