Sharepoint List Timestamps

JKO 11 Reputation points
2021-07-12T22:51:39.017+00:00

I am utilizing sharepoint lists in a workflow process. There are 2 calculated field columns that have have an IF statement that should record the timestamp for when a selection is made.

=IF([Task A Complete]="Yes",TEXT(NOW()+0.125,"mm/dd/yyyy hh:mm"))
=IF([Task B Complete]="Yes",TEXT(NOW()+0.125,"mm/dd/yyyy hh:mm"))

The formula works but both timestamps update whenever the latest selection is made.

For example, if task A complete is marked as YES at 9:30 AM, and Task B is completed at 10:45 AM, both timestamps will go to 10:45.

Is there a workaround for this?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,560 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yi Lu_MSFT 17,456 Reputation points
    2021-07-13T09:45:46.757+00:00

    Hi @JKO

    As per my knowledge, if you use NOW() function to get current date and time in the formula of the calculated column, you will meet the re-calculated issue. Generally, Once you edit an item, the calculated column will be re-calculated and updated at the same time. As a result, you will always get current date and time in those calculated columns after editing the item. This phenomenon is by design and I’m afraid there is no way to change it currently.

    I would suggest using a date time column or single line of text column as an alternative. Microsoft Power Automate Flow can be integrated with the list to set the current date to the fields based on the value in another field.

    If an Answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.