How to define a default value for a field with a formula

Frank Wang

Hello Guys,

I am using the webform feature to create the new record for my sheet. In each record, I have cells called Created Date, Closed Date and Duration. And the Duration is equal to a formula which count the gap between Created Date and Closed Date.

 

f(x)=NETDAYS([Created Date]1,[Closed Date]1)

 

The formular is working perfectly if I manually put it in a row in the Duration cell. But the formula would be transformed into text if I compy and past it into the webform as a defualt value of cell Duration.

 

So my question is how to keep the formula as a formula in the webform field?

 

Thanks!

 

Shaine Greenwood

Hi Frank,

 

Formulas will be converted into text when entering them via a web form, and there isn't a way to use formulas with a web form in this manner.

 

You can, however, enter the formula in your sheet directly, and our auto-fill formatting and formulas feature will populate a new formula in the row after an entrant makes a submission. Certain restrictions apply to the auto-fill feature, check out our Help Center article for more details on this: https://help.smartsheet.com/articles/1641473-auto-filling-formulas-and-formatting

 

I also want to bring up that if you have the dependencies functionality enabled (see: https://help.smartsheet.com/articles/765727-enabling-dependencies-using-predecessors), formulas won't work in your Duration column. 

Frank Wang

Hello Shaine,

Thanks for the information! At least I know that the thing is not working like what I thought.

And sure, I will keep using auto-fill formulas feature.

Thanks a lot!

 

Frank.