need for caching a formula before sending

Joerg Schmidt

Hi, we created a more extensive formula and our employees asked for the possibility to cache the formula in order to input further data to a later point in time. Would that be possible ?

Joerg Schmidt

Hi, sorry. I changed the word "formula" with "form"

I meant "form"

and I found solution by setting an automated process after sending form, the sender will receive an email in order to complete form.

Thanks for your help.

P.S. But anyway it would be nice to have a "cache" function. ;-)

Bassam Khalil

Hi @Jörg Schmidt Novum Hospitality

Hope you are fine, did you mean Postponing the activation of the formula until a later time, if so yes you can do that by removing the "=" from the start of the formula and it will be stored as as a text in the same cell.

Joerg Schmidt

Hi, sorry. I changed the word "formula" with "form"

I meant "form"

and I found solution by setting an automated process after sending form, the sender will receive an email in order to complete form.

Thanks for your help.

P.S. But anyway it would be nice to have a "cache" function. ;-)

Bassam Khalil

@Jörg Schmidt Novum Hospitality 

Excellent, i will be happy to help you any time. Have a nice day.Please help the Community by marking it as an ( Accepted Answer)