Is it possible to have nested or multiple possible outputs in formulas in some way?
I want to create an indicator if a task was created over 30 days ago and does not have a “Final” checked state, by setting a text field to an emote.
Additionally, I want to have a different symbol, or both if possible, if it has due date and it is in less than 7 days.
Right now they’re only one and the same through an
or in the condition. It will display icon if either is true, and nothing if it doesn’t have due date or conditions are not met.
If( ( (ToDays(Today() - [Creation Date]) > 30) and (State.Final = false) ) or ( (ToDays([Due date] - Today()) > 0) and (ToDays([Due date] - Today()) < 7) and (State.Final = false) ), "⚠", "" )