Question - I want to set the value of a colum...

(Tammi Canelli) #1

Question - I want to set the value of a column but only if a specific value in another column is selected.

The pic below can show what I mean.

I don’t want to attempt a

workflow data change because those have messed up before.

I thought if I put a valid if expression in the column it would apply the initial value to only items meeting that criteria but not the case.

Yes, Need Transport - set transport status to “awaiting transport” Yes, driving self - no status update

Can you do this without the workflow?

(Syed Faheemuddin) #2

Try using IF statement, just give " " in the false in initial value. Like IF([Evacuating]=“Yes, Need Transport”,“Awaiting transport”," ");

(Aleksi Alkio) #3

Or just IFS([Evacuating]=“Yes, Need Transport”,“Awaiting transport”)