Paste the date based on an event

#1

Think of a To-Do table…I want to paste today’s date in the field “Date Finished” via a formula when another field, “Status” is set to “Done”. Does anyone know how to do this? Or does this functionality even exist? Any help would be appreciated.

#2

Hi @Kurt_Kessler,

You’ll want to set up an automation:-
When: Row Changed
Table: To-Do
Then: ModifyRows([Step 1 Result], [Date Finished], Today())

#3

Thank you @Rahul_Jaisheel !!

It’s almost there…

I want

ModifyRows([Step 1 Result], [Date Finished], Today())

only if [Date Finished] = “Done”. Is this possible?

#4

Hi @Kurt_Kessler,

Sorry I missed that part. In your automation, you can add an If condition (between the When and Then):
If: [Step 1 Result].[Date Finished] = “Done”