IF formula issue (again)
I though this would be an easy one but it has me stumped again...
So i now want a column to populate with a symbol based on an other columns status to give a pictorial representation of that status, is this possible?
i.e.
The symbol option used was from the 'Status' section and was the empty circle running through to the full circle. I have 5 separate status options so the formula would repeat 5 times, each using a phase of the circle.
=IF(Document Status@row = "example here", rest of the formula to get an empty circle,
Best Answer
-
If you click on the dropdown arrow in a cell in the symbol column, you will see what text outputs you need to have for each different symbol (case sensitive).
From there it is a basic nested IF statement.
Example:
=IF(Status@row = "Not Starterd", "Empty", IF(Status@row = "In Progress", "Half", IF(Status@row = "Complete", "Full")))
Answers
-
If you click on the dropdown arrow in a cell in the symbol column, you will see what text outputs you need to have for each different symbol (case sensitive).
From there it is a basic nested IF statement.
Example:
=IF(Status@row = "Not Starterd", "Empty", IF(Status@row = "In Progress", "Half", IF(Status@row = "Complete", "Full")))
-
Great thank you, i'm learning a lot guys :-)
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!