Populating a field when two checkboxes are checked

Hi all,

I'm just starting to learn more about formulas and am a little stumped on this one.

I have two columns that are checkboxes: "Dates Received" and "Prices Received". When both checkboxes are checked, I would like it to populate a field in another column with "1". When neither are checked, or only one is checked, I would like it to return "0".

I have been using a formula like this (=IF([Column Name]1 = "true", 1, 0) when I need to do the above with only one column. It is the combing the results of the two columns where I get stuck. Any help would be appreciated!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!