IF THEN statement in a symbol column

04/18/19 Edited 12/09/19

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:

=IF([Done]1=1,"Low")

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?

Comments

  • L_123L_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 NewcomePaul 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.

    thinkspi.com

Sign In or Register to comment.