Hey! Does anyone know if it’s possible to use a allow ‘freeform’ in a cell when a formula is applied? Basically I’d like to use an IF statement, where the true case always returns a certain value, but the false case leaves the cell as a free canvas. I’d like to be able to pick any date, except fo…

Hi @Stan_Schalij , If I correctly understood your question, unfortunately a formula cell remains a formula cell no matter what, therefore you can’t edit its value. I’m afraid you have to play with your workarounds (as I’m doing, as well :grimacing:) Cheers

Another workaround is to have The formula column that calculates the date The manual override column that’s an input The third, “final” column that calculates to =DateOverride.IfBlank(DateCalculated) You can actually implement it with just two columns (one input and one formula that would use yo…

I came from the world of Filemaker Pro and find this to be one of the must frustrating Coda limitations. I love so many things about Coda but it lacks a few (very) key features, and this is one of them. My workaround for this is to use a button to push the formulated value into the field that is vi…

Allow freeform within a formula?

Nick_HE October 17, 2021, 9:02pm 5

Some more thoughts on this here - feel free to add your implementation ideas as they may inform how Coda goes about adding something like this.

Topic		Replies	Views
Override column formula for specific cell Product Feedback	4	1615	February 20, 2022
Disable formula if dates are blank in duration calculation	1	412	March 4, 2023
Apply column formula only for certain rows	1	314	February 8, 2023
A column with different formulas	5	1404	September 29, 2022
Is it possible to add a formula to a text field in a table that's editable individually?	1	1036	March 18, 2022

Allow freeform within a formula?

Related topics