Date Columns formula



I'm new to Smartsheet so I'm hoping you all could help me.

I have three date columns and a duration (how many days between the dates) column.

ColumnA - Initial baseline date

ColumnB - Current EST Date

ColumnC - Actual Date.

Column D - Duration

What I'm wondering is if there's a formula that will enable me to be able have the Duration column calculate the date between ColumnA and ColumnB, UNLESS there is a date in ColumnC. Additionally, if ColumnC has a date entered, then for the duration column to have the number of days between ColumnA and ColumnC and ignore ColumnB.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!