Populating a field when two checkboxes are checked

Lindsay F

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!

Nic Larsen

Try this:

=IF(AND([Date Received]@row = 1, [Prices Received]@row = 1), 1, 0)

Nic Larsen

Try this:

=IF(AND([Date Received]@row = 1, [Prices Received]@row = 1), 1, 0)

Lindsay F

Thank you, Nic! That worked great. Appreciate your help!