Auto Populate Dates and email to Form

Options

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

  • Dakota Haeffner
    Dakota Haeffner ✭✭✭✭✭
    Options

    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
    Nilesh ✭✭✭✭
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!