# Formula Help: Return Month from "Date Created" if "Date Added" is Blank

Options

I need help figuring out the formula that populates the <MONTH> from 1 of 2 date columns.

In the "Month" field, populate using "Date Created", but if that date field is blank use "Date Added" field.

@Sean Corcoran I see you helped with a similar formula, but I still could not quite figure this one out. (https://community.smartsheet.com/discussion/81505/error-when-using-month-formula-if-no-date-in-a-column)

## Best Answers

• ✭✭✭✭✭✭
Answer ✓
Options

The formula you require is -

=IF(ISBLANK([Date Created]@row), MONTH([Date Added]@row), MONTH([Date Created]@row))

Tested as below and working

Hope that helps

Thanks

Paul

• ✭✭✭✭✭✭
Answer ✓
Options

Hi @Kristen Hayward

I hope you are doing well,

According to the condition, I have created a formula

=IF(NOT(ISBLANK([Date created]@row)), MONTH([Date created]@row), MONTH([Date Added]@row))

when the Date created is blank then the Date Added month will show in the Month column and if both are not blank then it will show the Date created a month.

I hope this is useful to you, Have a Good Day.

Thanks,

Kaveri Vipat

Senior Associate - Smartsheet Development, Ignatiuz Software

2023 Core Product Certified

Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"

## Answers

• ✭✭✭✭✭✭
Answer ✓
Options

The formula you require is -

=IF(ISBLANK([Date Created]@row), MONTH([Date Added]@row), MONTH([Date Created]@row))

Tested as below and working

Hope that helps

Thanks

Paul

• ✭✭✭✭✭✭
Answer ✓
Options

Hi @Kristen Hayward

I hope you are doing well,

According to the condition, I have created a formula

=IF(NOT(ISBLANK([Date created]@row)), MONTH([Date created]@row), MONTH([Date Added]@row))

when the Date created is blank then the Date Added month will show in the Month column and if both are not blank then it will show the Date created a month.

I hope this is useful to you, Have a Good Day.

Thanks,

Kaveri Vipat

Senior Associate - Smartsheet Development, Ignatiuz Software

2023 Core Product Certified

Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"

• Options

Thank you both so very much for the assistance!!

This was my first request using the Community board and am so grateful for everyone who takes time out of their day to provide assistance to all of us out here.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!