Change cell value not working

Hi Everyone,

I have tried several times on a particular sheet the change cell value to automate % percentage, but the cell remains blank even after trigger. I do not know what I am not doing correctly.

The status has drop down list of Not started, Cancelled, In progress and Completed. I want 'Not started' = 0% 'Cancelled' = 0%, In progress = 50% , Completed = 100%

Perhaps if anyone could help with a formula instead.

Thanks in anticipation!!


Best Answer

  • Abiola
    Abiola ✭✭
    Answer ✓

    Hi Everyone,

    The auto change cell value works. Apparently, the status were already filled before I set the workflow. All I did was to cut the filled status, saved the sheet and then re-paste the status. The auto populate appeared after saving the sheet again.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!