Rows equal but selectable

I have a table with a the following “Start Date Planned” and “Start Date Actual”. The default formula is that “Start Date Actual” = “Start Date Planned”. What is the formula needed if I want to make “Start Date Actual” editable or the ability to change.

Screen Shot 2024-04-10 at 9.44.06 PM

Hello @Life_on_Wheels ,

What you want to do is not possible - a calculated field can not be changed/edited.

What you probably should do is leave out the calculation and fill the empty field either with a button or with an automation (modifyrows()). Fill it with the start date and you are all set. In order to prevent mistakes you can prevent both actions if the “Start Date Actual” is not empty.

Please let me know if you need further help.

Greetings, Joost