Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How to define a default value for a field with a formula
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?