Work Around for Auto-Number in Web Form

I have my smartsheet set up so that x1 day after approval an email will be sent to the Manager requesting completed documents be uploaded into smartsheet.

In my head I was going to create:

  1. Form submission: to include: (1) The auto-number "Notification Number" that was assigned the day before. (2) ability to upload document(s).
  2. Alert email: set to send to manager the day after notification number was assigned: to include: (3) a link to the Form submission.

I know you can't access the Auto-Number column in Forms so I created a rule that duplicates the auto-number to a new field that is set as single option drop down. However, even my new pseudo Notification Number is not available as a field option in the Form submission.


Best Answer