IF THEN statement in a symbol column


Fairly new to smartsheet, so not sure if I'm doing something wrong.

I have a priority column in my To Do sheet which is a symbol column (High, Medium, Low).  I would like to create an IF statement that will automatically change the priority to "Low" once the task is completed (doing this for the purposes of a report I am running).

I created the forumula below:


This formula works fine and I can paste it in all the cells of the column.  The problem is when I manually enter a priority for a task, e.g. "High"  The formula is then removed and when the Done box is checked the priority remains "High." So it is essentially useless.


Any help?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!