Subtracting Dates to determine what is less than 90 Days

Maybe I need to use a different formula, but this was successful in returning "Short" for everything, rather than anything under 90 days. We are trying to call out short start projects or those that require less than the average 90 days, so a difference of 90 or over should return nothing.

=IF([Anticipated Activation Date]@row - [Go Live/Close Date]@row < 90, "Short", "")

Tags:

Answers

  • Tina Rustvold
    Tina Rustvold ✭✭✭✭✭

    I may have figured it out, but now need this information only for a particular service line. I tried below and recieve INVALID DATA TYPE error. Is this because I am mixing math and letters? I am unclear what data type is incorrect.

    =IF([Go Live/Close Date]@row - [Anticipated Activation Date]@row < 60, AND([Service Line]@row = "Value-based Hospitalists", "VShort", ""))

  • Paul McGuinness
    Paul McGuinness ✭✭✭✭✭✭

    Hi @Tina Rustvold

    Looks like the AND placement is wrong, try the below, AND needs to go in front of all the arguments.

    =IF(AND([Go Live/Close Date]@row - [Anticipated Activation Date]@row < 60, [Service Line]@row = "Value-based Hospitalists"), "VShort", ""))

    Hope that helps

    Thanks

    Paul

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!