IF Function not working for me

Options

I'm referencing a Birth Date in a sheet and want to use the IF Function along with the Month Function to isolate the month of a person's birthday date.

The DOB column is in DATE Format (i.e. 12/05/75). Some of the rows do not have any data populated in them, and I'm trying to return a blank (i.e. "") for those conditions.

The formula I'm trying to use in another column its Text/Number.

Here's my formula

=IF(TODAY() > DOB@row, MONTH(DOB@row), "")


If will properly calculate if the DOB column has a date, but returns #INVALID DATA TYPE, if that DOB Column is not populated.

Any ideas on how to work around this?

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!