Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

IF / ISBLANK - Question

Hello,

I'm looking for a formula that would allow me to create a sum of two dates when the "Anticipated Delivery Date" column is blank. However when there is a date populated in the "Anticipated Delivery Date" column i want that date to supersede the sum of the previous ones. For example, see what I've come up with.

=IF(ISBLANK([Anticipated Delivery Date]@row), [Projected Pre-Fab Start Date]@row - [Estimated Receiving Stocking QC Time (Days)]@row)

Am I able to add a second part to that formula and just put "OR =anticipated delivery date" to supersede the "[Projected Pre-Fab Start Date]@row - [Estimated Receiving Stocking QC Time (Days)]@row)" section? (which would look something like this)

=IF(ISBLANK([Anticipated Delivery Date]@row), [Projected Pre-Fab Start Date]@row - [Estimated Receiving Stocking QC Time (Days)]@row), OR=(Anticipated Delivery Date)


image.png


Answers

  • Community Champion

    Almost!

    After the value if true just enter a comma and then the value if false, which is simply your cell reference. You do not need OR or =.

    Try this:

    =IF(ISBLANK([Anticipated Delivery Date]@row), [Projected Pre-Fab Start Date]@row - [Estimated Receiving Stocking QC Time (Days)]@row), [Anticipated Delivery Date]@row)

  • ✭✭

    This worked! Thanks!

  • Community Champion

    See, you were almost there! Glad I could help.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions