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,
Help Article Resources
Check out the Formula Handbook template!