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

LornaB

Copper Contributor

Jun 02, 2020

RobElliott

Thank you very much for this, I have managed to get it to work as I was also meant to point it at the Status column I realised as that is where it states complete

=IF([Status - Jul]="Complete",NOW()+(8/24))

thank you for the tip regarding the time that was super helpful as I would never have got that