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.

谢谢!

Frank.