IF AND FORMULA CROSS REFERENCING ANOTHER SHEET

Options

Sorry folks, me again

I am trying to get and if and formula to work that references values in another sheet but keep getting 'INCORRECT ARGUMENT SET'

I can get both parts to work separately but cannot get them to combine to give a single result

part one works ok =COUNTIF({0-5 IMMSUNISATIONS Range 2}, =0)

part two works ok =COUNTIF({0-5 IMMSUNISATIONS Range 3}, ="DATES MISSING")

But this doesn't work at all. I could cheat and use the 2 helper columns in the destination cheat that do work and just take one away from the other but i'd rather have it all in one formula and it be cleaner

=COUNTIF(AND({0-5 IMMSUNISATIONS Range 2}, =0, {0-5 IMMSUNISATIONS Range 3}, ="DATES MISSING"))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!