What is wrong with this formula?
The following formula appears in one of our Smartsheets as a column formula:
=IF(Holidays@row <> "", IF(TODAY() >= Holidays@row, COUNTIFS({Course Complete Date}, Holidays@row, ""), ""))
This formula had been functioning as intended for quite some time, but it started yielding an #INCORRECT ARGUMENT SET error a few days ago. I checked the column mentioned in the formula (Holidays) as well as the reference ({Course Complete Date}, which points to an entire column in another Smartsheet), and they appear to be functioning correctly.
Does anyone know why this formula has started yielding an error?
Best Answer
-
If I'm reading this correctly, I think the comma at the end needs to be moved, because it looks like you're not closing off your COUNTIFS statement.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
If I'm reading this correctly, I think the comma at the end needs to be moved, because it looks like you're not closing off your COUNTIFS statement.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
@Jeff Reisman That did it! Thank you!
Help Article Resources
Categories
Check out the Formula Handbook template!