Nested conditional on formula

It’s now a whole lot easier thanks to concatenation in formulas :slight_smile:

If( (ToDays(Today() - [Creation Date]) > 30) and (State.Final = false) ),β€œ:balloon:”,β€œβ€) + if ( (ToDays([Due date] - Today()) > 0) and (ToDays([Due date] - Today()) < 7) ),β€œ:soccer:”,β€œβ€)

2 Likes