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.
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
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.