What I’m really trying to do is conditional format the text output of a canvas formula. So when everyones reading the doc it says Reading in red and when everyones done reading it says Finished in green.
There doesn’t appear to be conditional formatting so went with this posts suggestion of having 2 separate formulas. Each formula is formatted seperatly and shows empty text when it should be hidden.
The issue is empty text displays as brackets instead of nothing
Even if I can get it to show nothing it looks like there be an white space colored red or green. Anyway to do this using canvas formula? While I could use a button and disable the button, there’s several other uses for conditional canvas formula formatting where a button isn’t a great solution.
Ideas?