I’m trying to make a simple status select list that updates a timestamp for “Started On” and “Completed On” columns.
So when the “Status” select list is changed to “In Progress” the timestamp updates “Started On” and when “Done” is selected it updates “Completed On”.
I’ve been able to get it to update with: if(thisRow.Status=“In Progress”,thisRow.Status.Modified(),“”)
But it removes the date when the status is changed to done. Any way to ignore if the field already has a date? I’ve tried using IsBlank() but for some reason I keep getting syntax errors on this:
If(thisRowthisRow.Status=“In Progress”,If(IsBlank(),thisRowthisRow.Status.Modified() ,“” ) ,“” )
Thanks so much for the answer. Definitely helps me understand how to apply actions. Unfortunately in this scenario, I think it’s just as easy to click on the date field and set the current date than it is to have a separate button to set it.