Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Conditional date formula

Hi,

I'm having a little trouble creating a formula for a date column. I have a 'Project type' column and a 'Project start date' column which need to determine what the 'Handover to support date' column is.

Basically - for all projects the 'Handover to support date' has to be 1 month after the 'Project start date' apart from 1 specific type of project, where it needs to be 3 months after.

Is it possible to do this? Thanks in advance.

Comments

  • steven.reed14881
    steven.reed14881 ✭✭✭✭✭✭

    Sambaxter,

    The following formula seems to achieve what you are looking for:

    =IF([Project Type]1 = "Complex", [Start Date]1 + 90, [Start Date]1 + 30)

    I am not sure what your project type names are, but in this case, I have named those that require the longer time to handover as Complex. This formula will then give all other project types (if you have more than one) with the shorter, 30 day duration.

    I hope this helps!

     

    Steve

  • Thank you so much Steve! smiley

    You're a life saver!

This discussion has been closed.