IF AND Formula



I am trying to get this formula to work. I need to calculate how many rows are "available" AND have a "1". I think I need this formula:

=IF(AND([Availability]15:[Availability]23="Available", [Tech Level]15:[Tech Level]23 = 1), 1)

but it keeps removing the brackets around Availability:

=IF(AND(Availability15:Availability23 = "Available", [Tech Level]15:[Tech Level]23 = 1), 1, 0)

and saying Invalid Operation.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!