Generate Calculated Fields on Forms


We're new to the Smartsheet platform and are wondering if the following is possible:

  • Using a form that is presented to the public, can we have a user enter information into a couple of fields on that form and generate/calculate a date for that same user on that same form?

For example, if i ask you to enter how many hours your academic program requires as well as how many hours you have attended, we would like to calculate the number of days to add to today's date to provide an estimated completion date.

Best Answer