Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Can a submitted Form have the date (today()) in the Tittle of the e-mail?

✭✭✭✭✭

Hello Brilliant people!

Here is my Query....

Scenario: I have a form in which users populate their tasks for the week. The form is call "my tasks for the week".

When they enter/complete the form, they can request an e-mail copy of their entry. Should they do so, they will receive an e-mail with the tittle " Confirmation - My tasks for the week". For better management, they would like it to read: "  Confirmation - My tasks for the week <date submitted>".This way they can quickly scan e-mails for a specific entry, etc. I know the formula of Today() would suffice, but it would need to be in the tittle of the form.

Is there a way to add a timestamp to the subject line of an e-mail using native functions/formulas in forms?

Granted, they do have a time stamp on their e-mail when they do this process, I do have a form field for date that they use. However, if they do any entries in arrears, they note the e-mail timestamp is wrong, and they would need to do extra clicking to open an e-mail to see the field date that they populated.

I guess I could just do all this as workflow and disable the e-mail option that is native in forms, but wanted to see what y'all think and if there is a solution?

(I went back to 2018 and didn't see this ask in the prior postings 😵)

Answers

  • ✭✭✭✭✭

    Hi,

    I am afraid this isn't possible with smartsheet forms and invite you to report a for a feature request.

    Still, there are some alternatives, such as using the current form but sending the confirmation email with a different service, such as ITFF or Zapier.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions