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.
You’ll want to set up an automation:-
When: Row Changed
Then: ModifyRows([Step 1 Result], [Date Finished], Today())
Thank you @Rahul_Jaisheel !!
It’s almost there…
ModifyRows([Step 1 Result], [Date Finished], Today())
only if [Date Finished] = “Done”. Is this possible?