If function custom value

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