using Harvey ball status to drive a formula
Is there a way to use the harvey ball status to drive a formula?
Here's an example of what I was able to achieve in excel but cannot replicate in Smart Sheet. =If(HarveyBall = "Full",date-today(),"")
Result in excel, I get blank if result is true
Result in SmartSheet, I get #Unparseable
Observation is that the HarveyBall status doesn't seem to convert to a value properly whether text or percentage. Help!
Help Article Resources
Check out the Formula Handbook template!