Impossible to countifs on an empty column

Hello,


i have this formula that works fine :

=IF(ISBLANK([Name of LE]@row), "", COUNTIFS({Fn}, "HR", {LEC - Action list conso pivot Range 1}, CONTAINS([Region / IE_ID]@row, @cell), {Stage}, "Stage0"))

However when I add this last condition :

=IF(ISBLANK([Name of LE]@row), "", COUNTIFS({Fn}, "HR", {LEC - Action list conso pivot Range 1}, CONTAINS([Region / IE_ID]@row, @cell), {Stage}, "Stage0"), {TgtDate}, "")

I get « INCORRECT ARGUMENT SET » error.

The TgtDate column is mostly empty so it should work I think. But it doesn’t.

thanks for your ideas to troubleshoot this !

best,

Pierre-Eric

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!