IF / ISBLANK - Question

ktier

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)

KPH

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)

ktier

https://community.smartsheet.com/discussion/comment/420436#Comment_420436

This worked! Thanks!

KPH

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