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
Check out the Formula Handbook template!