Forum Discussion
Timestamp issues in SharePoint
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.
- My list is as below – My current formula is in the Time flight ready column.
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")),"")
- Use a SharePoint workflow to copy the value of the "Ready" column to the "Previous Ready" column every time the item is edited. – How do I do this? I can create a new column easy enough.
Thanks in advance
Russell
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 https://www.microsoft.com/en-us/download/details.aspx?id=35491
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.
- Would you please elaborate on steps 4 and 5?
