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:
=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
-
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".
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!