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

Kristen Hayward

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)

Paul McGuinness

Hi @Kristen Hayward

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

Kaveri Vipat

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.

Paul McGuinness

Hi @Kristen Hayward

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

Kaveri Vipat

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.

Kristen Hayward

@Paul McGuinness @Kaveri Vipat

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.