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 possi…

I imagine it will be fairly easy to achieve if/when string concatenation becomes available in the formula field, but for the time being it’s certainly possible to nest ‘if’ functions: If(Cond1,“A”,If(Cond2,“B”,“C”)) Using that method, you could write conditional logic to achieve what you’re descri…

Concatenation is a great type of formula. Things like a Contact, where you could have one field for “Full Name,” and that would generate based on two other fields: “First Name” and “Last Name” Great Suggestion!

Hi, Martin! Here is how your formula will look like :slight_smile: If( (((ToDays(Today() - [Creation Date]) > 30) and (State.Final = false)) and (ToDays([Due date] - Today()) > 0)) and (ToDays([Due date] - Today()) < 7), "💩🚨", If((ToDays(Today() - [Creation Date]) > 30) and (State.Fina…

It’s now a whole lot easier thanks to concatenation in formulas :slight_smile: [image] CHANGELOG: August 24 / Text formulas, Undo in Table View Changelog The last two weeks were challenging in Belarus . We slowly got back to work and released a new build with so…

Definitely! Also glad it is here :face_with_monocle::sparkles:

Nested conditional on formula

Get Help

Chr1sG August 24, 2020, 11:55am 5

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

If( (ToDays(Today() - [Creation Date]) > 30) and (State.Final = false) ),“”,“”) + if ( (ToDays([Due date] - Today()) > 0) and (ToDays([Due date] - Today()) < 7) ),“”,“”)

2 Likes

Topic		Replies	Views
CHANGELOG: May 4 / Logic in formulas, no Type restriction in Team plan Changelog	1	856	May 20, 2020
Use collection in if formula Get Help	4	301	July 10, 2023
To be able to use Formula in Automation filters Automations	7	656	August 19, 2025
Cannot mix aggregate and non-aggregate arguments in reports Get Help	8	92	October 8, 2025
Is it possible to use boolean logic in formulas? Get Help	3	645	April 12, 2022

Nested conditional on formula

Related topics