#Date expected error

Options
Morena
Morena ✭✭✭
edited 09/19/23 in Formulas and Functions

Hi

I have to two - "Target Going TAT Time (Day)" which is a text column and "Departure Date from Loading Point" which is a date column.

Now I want to add them together in a column called ETA (G) = Target Going TAT Time (Day) + Departure Date from Loading Point

The Problem i get an error when 1 of the column are blank, if Target Going TAT Time (Day) is blank and Departure Date from Loading Point has a date, I get #INVALID OPERATION


if Target Going TAT Time (Day) has a number and Departure Date from Loading Point is blank,Ii get an error of #DATE EXPECTED.

When I use the IFERROR it helps resolve the #INVALID OPERATION Error but I still get the #DATE EXPECTED error.

Please advise

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!