Override Column Formula

wispsofsmoke

Hi,

I have a column that uses a column formula to automatically calculate a date based on other columns' criteria. However, we sometimes need to manually adjust the date and override the column formula.

Is there a way to do this?

Thanks!

Melissa Yamada

Hello @wispsofsmoke

A work around is to create a helper column (Date Override column) then on your main column with the column formula you can add an IF statement that if there is date in the "Date Override column" then return that value.

Paul Newcome

You would start it off with

=IF([Helper Column]@row <> "", [Helper Column]@row, IF(Tier@row = ……………………………………………

Melissa Yamada

Hello @wispsofsmoke

A work around is to create a helper column (Date Override column) then on your main column with the column formula you can add an IF statement that if there is date in the "Date Override column" then return that value.

wispsofsmoke

Thanks Melissa!

So, how would I add that to this formula?

=IF(Tier@row = "Tier 1 (1-3 Weeks)", [Start Date]@row + 21, IF(Tier@row = "Tier 2 (1-2 Months)", [Start Date]@row + 60, IF(Tier@row = "Tier 3 (2-3 Months)", [Start Date]@row + 90, IF(Tier@row = "Tier 4 (4-12 Months)", [Start Date]@row + 365, IF(Tier@row = "Coaching (6 Months)", [Start Date]@row + 180, "")))))

Thanks!

Paul Newcome

You would start it off with

=IF([Helper Column]@row <> "", [Helper Column]@row, IF(Tier@row = ……………………………………………

Melissa Yamada

Hello @wispsofsmoke

You can follow @Paul Newcome's formula.

You just need to add the additional IF statement at the first part of your formula to check whether the Date Override column is blank or not.

wispsofsmoke

Thanks Melissa and Paul!

Paul Newcome

Happy to help. 👍️