If function custom value

#1

I have a column with project stages and another with date. I was using
IF(thisRow.STAGE=“FINISHED”, ******* ,today())
When I change the project stage to finished I want to be able to to edit the sell to input my custom date and when its on any other stage to be set to today’s date “today()”. What should I write in true to be able to customize the sell. Or if there is a better way please advice.

0 Likes

#2

Hey @Nazarii_Vovk,
I think currently, a date cell can’t be open for user input AND a formula.

In some cases, you can workaround this, by filling the data with a button. That way, data in a cell can be filled by a user AND automatically by an action. (Example of a scale field that can be open/deactivated for user input)

But I think in your case, it might be challenging if you have more than 2 project states. I think you might need two fields:

  • Date -> Text/Date field with formula: if(stage = ‘finished’, [Date picker], today())
  • Date picker -> No formula, just a date field

Hope that helps!

2 Likes

#3

I often use two Columns. One freeform and one formulaic. The formulaic basically looks at freeform and if it is empty it fills the values based on the formula.

1 Like