Timestamp issues in SharePoint

The issue you're experiencing is because the formula you're using is based on the `NOW()` function, which returns the current date and time. This means that every time the item is edited, the formula will recalculate and update the timestamp to the current date and time.

To fix this, you can modify your formula to use a SharePoint column that stores the original value of the Ready column. Here's an example of how you can modify your formula:

1. Create a new column called "Ready Timestamp" (or any name you prefer) with the data type "Date and Time".

2. Modify your formula to check if the value of the "Ready" column has changed. If it has not changed, then return the existing value of the "Ready Timestamp" column. If it has changed, then update the "Ready Timestamp" column with the current date and time. Here's an example of how the modified formula could look:


=IF(Ready="Yes",IF([Ready]=[Previous Ready],"[Ready Timestamp]",TEXT(NOW()+0.3336,"dd-mm-yyyy hh:mm")),"")


In this formula, "[Previous Ready]" refers to a column that stores the previous value of the "Ready" column. You can create this column by following these steps:

1. Create a new column called "Previous Ready" (or any name you prefer) with the data type "Single line of text".

2. Modify your list view to include this column.

3. Use a SharePoint workflow to copy the value of the "Ready" column to the "Previous Ready" column every time the item is edited.

With this modified formula, the "Ready Timestamp" column will only be updated when the value of the "Ready" column changes, and the original timestamp will be preserved.