Forum Discussion

Copper Contributor

Jun 01, 2020

IF Formula Add a Date if complete

I have a sharepoint this and I need to add the date and time when the status is changed to complete. At the moment the person who is editing the status is manually adding the date and i want this to ...

Lists

SharePoint Online

RobElliott

Silver Contributor

Jun 01, 2020

LornaB your formula won't work because you haven't told it what to do if it doesn't equal Completed. Try this: =IF([Completion Date - Jul]="Completed",NOW(),"") which will leave the column empty if the Completion Date - Jul column is anything other than "Completed"

In my case I have to add 8 hours because the Now() function always returns the date/time in UTC whatever the regional settings are set to. So my formula is =IF([Completion Date - Jul]="Completed",NOW()+(8/24),"")

Rob
Los Gallardos
Microsoft Power Automate Community Super User

store

Copper Contributor

Dec 11, 2024

re RobElliott

I found this thread and am attempting to do something similar. However, wouldn't the NOW() function return the current date meaning it will change depending on the date you run it? I'm hoping to return a static date of when the item was marked "Complete"

Can you share how I might do that?

In the below example I have used your above method but expecting this date to update tomorrow.