Date Formula

Hello,

I have a "Renovation Start Date" and a "Estimated Renovation Completion Date" column.

If the "Renovation Start Date" is blank and does not have a date, I want to the "Estimated Renovation Completion Date" column to also remain blank.

However, if the "Renovation Start Date" is does have a date I want the "Estimated Renovation Completion Date" to be 30 calendar days from the "Renovation Start Date".

I am having difficult time with this formula

This is what I have so far:

=IF([Renovation Start Date]1 = "", "", 30)


Any help would be greatly appreciated.

Thanks,

JC

Best Answer

Answers

  • JC Mejia
    JC Mejia
    edited 04/07/20

    Hi Andree,

    It worked 👏

    Thank you so much! I really appreciate your help.

    Regards,

    JC

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Excellent!

    You're more than welcome!

    Remember! Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!