IF Function not working for me


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?


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!