Formula Issue: Non-'Complete' Statuses Turning Blank in Column Formula

System

This discussion was created from comments split from: IF statement to update a column when box is checked!.

MPath

https://community.smartsheet.com/discussion/comment/232741#Comment_232741

Hi,

Whilst it does work for done=1 →status=complete. It does nullify all other selected other than complete (they turn blank).

So If I try to change formula to column formula, any cell that is Not blank but Ïn progress", "Not started" and "On hold" and also not "Complete" will turn blank.

So I tried automating but that didnt work, somehow it just turns all status into complete!

Thoughts?

AKnight

Hi @MPath! When you ran the automation, did you run it by run going to "run automation" and "Trigger workflow on the entire sheet"?

MPath

https://community.smartsheet.com/discussion/comment/462107#Comment_462107

yes. I now tried it on a row and everythings is fine. Also tested it in actual scenario and works fine, though it looked like it didn't there was a huge amount of lag on automations yesterday(GMT +1 here). Thanks :)