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

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?

0 2 338
2 REPLIES 2

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

Or just IFS([Evacuating]=โ€œYes, Need Transportโ€,โ€œAwaiting transportโ€)

Top Labels in this Space