#Date Expected Error



I have 2 sheets - 1 is for active projects and the other is for completed. They both have the same columns. One the active sheet my month helper formula =IFERROR(MONTH([Date Update Request]@row), 0) works perfectly. On the completed sheet, it returns a #DATE EXPECTED error. The columns are all date columns.

Any ideas?

Darla Brown

What you meditate on, you empower!

Overachiever - Core Product Certified - Mobilizer - EAP


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!