It would be great to have the ability to freeze the current value of a cell which has an underlying cell or column formula. Ideally this could be done manually or through an automation. Also having the reverse ability to unfreeze, which would allow the underlying cell or column formula to be reapplied. Where this would come in handy is if you have one or more column formulas that include references to other sheets, and once a certain condition is met, you no longer want the values in those columns to change if updates are made in the reference sheet. I have found a workaround for this using a copy row automation paired with a helper sheet that uses the freeze condition as its trigger. I set up the column formula to use an IF function that uses the freeze condition as the logical statement, INDEX MATCH referencing the helper sheet using the row ID as the match value if true, and the default formula I want applied until the freeze condition is met if false. However, this only works if all the columns I want to freeze have the same freeze condition, otherwise the row ID won't have a one-to-one match with the helper sheet.