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?


  • L_123
    L_123 ✭✭✭✭✭✭

    Which symbols exactly did you select? If you hit the dropdown arrow in the column, it will tell you the text you use to reference each symbol. If you used the arrows, it is "Up", "Sideways" and "Down". 

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    The problem is that you cannot have automation AND manual entry within the same cell. Once something is manually entered, the automation is overwritten.


    You will need to either automate all of the options with a nested IF statement or manually enter all of the options.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!