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.