Error when using =Month formula if no date in a column

I am using the following formula:

=MONTH([Due Date]@row)

If my "Due Date" cell is empty I get the following error

#INVALID DATA TYP

I may not always know the Due Date until the project moves on for some task.

I am looking for away to modify the formula to ignore a blank Due Date and give me nothing or return a "0"

Any help would be greatly apricated

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!