Hi all,
Relatively new to using formulas with Monday, and I’m really struggling to get a set of variables to result in an output.
I’m trying nested if(and statements, but not getting the expected results.
If I use this:
IF(AND({Training Type}=“Standard”,{Delivery}=“Online”),“5 Days”,
IF(AND({Training Type}=“Standard”,{Delivery}=“In Person”),“3 Days”,“”))
I only get the top result showing, and even when the other conditions match, it leaves the cell blank.
If I try this:
IF(OR(AND({Training Type}=“Standard”,{Delivery}=“Online”),“5 Days”,
IF(AND({Training Type}=“Standard”,{Delivery}=“In Person”),“3 Days”,“”)))
I just get ‘true’ as the output regardless of the configuration.
What am I missing here? Any help so much appreciated!
GCavin
(Gilles Cavin - Reinventing Formulas in monday.com)
2
Not sure what you’re trying to do with the 2nd formula, but the closing parenthesis of your OR function is the one before last, so your formula reads like this:
IF(OR(...))
Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.
Create formulas without using the Formula column (and avoid its limitations)
Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
In one formula, update multiple columns from multiple items.
