I am receiving an #INVALID DATA TYPE Error when I have blanks in the dates I am referencing. The formula is summing the equipment pieces based on the delivery month, but the delivery date can be added later in the project, so there will often be blanks. My formula is below:

Adding an IFERROR avoids the error message, but I would like for the formula to work for the data that is present in the other months. It is feeding a chart that is a lot less meaningful without the not accepted showing up.

Any ideas on this? Appreciate your help in advance!

Best Answer


  • Angela Cisneros

    Thanks for those suggestions. The ISDATE did not work, but the IFERROR on the month did.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!