How can I tick a box based on two criteria?
I'd like to tick a checkbox based on another checkbox being ticked and for a specific task name. I have the following formulas that work individually. How can I combine them?
=IF([Checkbox]@row = 1, 1,0)
=IF([Task name]@row = "XYZ", 1,0)
Best Answers

I think I found my own answer  FYI for anyone who has the same query:
=IF(Checkbox@row = 1, IF([Task Name]@row = "XYZ", 1, 0))

Hi @Stephen Everiss,
Your formula would look like this:
=IF(AND(Checkbox@row = 1, [Task Name]@row = "XYZ"), 1, 0)
Sample:
Hope this helps, but if you've any problems/questions then let us know!
Answers

I think I found my own answer  FYI for anyone who has the same query:
=IF(Checkbox@row = 1, IF([Task Name]@row = "XYZ", 1, 0))

Hi @Stephen Everiss,
Your formula would look like this:
=IF(AND(Checkbox@row = 1, [Task Name]@row = "XYZ"), 1, 0)
Sample:
Hope this helps, but if you've any problems/questions then let us know!
Help Article Resources
Categories
Check out the Formula Handbook template!