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?


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!