Formula if empty allow to make entry

1

HI. Is it possible to have a formula that finds some data from a related column but if it does not find anything it allows you to still entry some data?

I have a Client type property that it’s automatically pulling data from my Clients DB but when this is empty I would like to still be able to update it…is this possible?

Thanks in advance!

Eva

2

hi @Eva_Folch ,
indeed, in a column with a formula, you cannot write something manually for obvious reasons, that is what you noticed. You can however let a button execute the task using the formula and print the outcome in the column. The outcome will be text and empty cells will remain empty and so you can add / correct as much as you want. The button can be pushed by an automation for example when you generate a new row.
Cheers, Christiaan

3

Hi Christiann, thanks! interesting workaround. I’ll play around see fi I can manage :wink:

Thanks, Eva

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.