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

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

  • Paul McGuinness
    Paul McGuinness ✭✭✭✭✭✭
    Answer ✓

    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
    Kaveri Vipat ✭✭✭✭✭✭
    Answer ✓

    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

  • Paul McGuinness
    Paul McGuinness ✭✭✭✭✭✭
    Answer ✓

    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
    Kaveri Vipat ✭✭✭✭✭✭
    Answer ✓

    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⬆️"

  • @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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!