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


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!