Auto Populate Dates and email to Form

Hi All,

i have smart sheet form with dates, and i want to populate the date as per status dropdown. once the status changes the date should auto populate to the form date field.

also, is there any way i can auto populate email id's in form field whenever new user is going to submit responce. i have set automation to send email with form link to everyone.

Find more posts tagged with

Accepted answers

All comments

Dakota Haeffner

Hi Nilesh,

Assuming I understand your ask here, you can use Record a Date automation that records anytime the Status column changes.

I usually just have whoever is using the form to enter there email. You can't really automate this because anyone can use the form and it is not looking at the user. If they enter directly into a row instead of the form it will grab he user email in the modified by field.

Hope this helps.😁

Nilesh

Hi Dakota,

Thank you for your prompt reply.

actually, we have level dropdown(Level1, level 2 etc) and for each level we have assigned date and whenever someone select level i want to show specific date assigned to that level.

Thanks!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.