May 10 2023 11:29 AM
Hi. I have a SharePoint site where I have a column named Ready. I have managed to create another conditional column which stamps the time and date when you click Ready as yes. The problem I have is that when you edit the record later the timestamp updates to the current time. Does anyone know how to fix this so only the first date/time is kept?
The formula I'm using for the timestamp is:-
=IF(Ready="Yes",TEXT(NOW()+0.3336,"dd-mm-yyyy hh:mm"),"")
May 10 2023 11:32 AM
May 11 2023 12:50 PM
@Deleted
Hi
Thanks for your reply. Apologies, I’m not great on Sharepoint could you advise me a little further? I’m a bit confused as to how many new columns I need and where my formula needs to be.
So I’m guessing the Ready Timestamp column you suggest is just the same as my ‘Time flight ready’? And the formula you gave me goes in here?
And thus my updated formula would be =IF(Ready="Yes",IF([Ready]=[Previous Ready],"[Time flight ready]",TEXT(NOW()+0.3336,"dd-mm-yyyy hh:mm")),"")
Thanks in advance
Russell
May 11 2023 09:11 PM
Your formula is right, now only need to create a SharePoint Designer workflow to update the new Ready timestamp field,
You need to
1. install the SharePoint Designer
2. Connect to your SharePoint Site using designer,
3. Open the list
4. Create new Workflow
5. Add steps to update field
6. Publish Workflow
If you are on SharePoint Online, you can do the same using PowerAutomate.
Jun 01 2023 10:20 AM