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.
Answers
-
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.😁
-
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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!