Setting Formula to Remain it's Current Value Unless Told to Change

Usman101

So I am trying to set up custom baseline formulas for our PMs and am attempting to have the baseline date change to the actual when a checkbox is ticked and then it is to remain that value when the checkbox is unticked and not automatically update with the actual dates any further if changes are made to it.

Here's the formula I have for the baseline at the moment:
=IF([Update Baseline?]@row, [Actual Date]@row, 0)

Ideally I would want the 0 to be replaced with the current baseline date but I get a Circular Reference error.
Thanks for the help

Kerry St. Thomas

I wonder if you could accomplish this with an automation:

Trigger: When Row is Added or Changed, when checkbox is Checked, run when triggered
Condition: When Actual Date is BLANK
Action: Record a date in Actual Date

This will only trigger once - after the first time, it won't matter if the box is checked or unchecked or anything else, because of the condition. You can lock that column to edits.

Good luck!

Kerry St. Thomas

I wonder if you could accomplish this with an automation:

Trigger: When Row is Added or Changed, when checkbox is Checked, run when triggered
Condition: When Actual Date is BLANK
Action: Record a date in Actual Date

This will only trigger once - after the first time, it won't matter if the box is checked or unchecked or anything else, because of the condition. You can lock that column to edits.

Good luck!