#Date Expected Error

Hi,

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!