Checkboxes and Nested Formulas

Platform discussions Special workflows & use cases
,
1

Hello, I’m trying to created a nested formula with checkboxes where the following should happen:

If {checkbox1} is checked AND {checkbox2} is checked, then {formula_column} = to 0.10 of {total_contract}, IF {checkbox1} is checked AND {checkbox2} is NOT checked, then {formula_column} = “NOT YET”, IF {checkbox1} is NOT checked, then {formula_column} =“DOESN’T APPLY”

See below what I have so far, but I got an error:

IF((AND({checkbox1},{checkbox2}),0.10*{Total Contract}),IF(AND({checkbox1},{checkbox2}=FALSE),"NOT YET))

Thank you for your help! :slight_smile:

2

@laura1

This should do it:

IF({checkbox1}, IF({checkbox2}, 0.10*{Total Contract}, "NOT YET"), "DOESN'T APPLY")

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Column Total in monday.com Formulas? YES!!!
Check out our monday apps, now in beta: The Monday Man Apps

1 Like
3

@JCorrell, It worked!! Thank you so much! You ARE the Monday Man :slight_smile:

1 Like
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.