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

Frank Wang
edited 12/09/19 in Archived 2017 Posts

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!

 

2017-01-22_20-10-47.png

Comments

This discussion has been closed.