Sign in to join the conversation:
I am trying to make a sheet and a form that will allow me to notify different people from different departments to make sure they get the correct information. Can this be done and if so how.
Please let me know
Hi Justin,
Can you provide some more information on your our specific use case?
Best,
Andrée Starå - Workflow Consultant / Get Done
You can create multiple forms for each sheet. But the forms themselves don't send data, they just allow users to input data. To deliver data you could send notifications to people, or you could share reports that show only their data.
https://www.smartsheet.com/videos/reporting-in-smartsheet
https://help.smartsheet.com/articles/522221-collect-information-form
https://www.smartsheet.com/blog/support-tip-using-multiple-forms
I would like to be able to have the form information that is created and when a person hits send from the form that we created go to a different department such as the following:
We have a form for drafting and it goes directly to a person in drafting.
Also we have another form that is requesting us to place an order will it go to that person.
This would all be from a Master sheet.
Is there a way to set up the notifications to the certain departments based on which form is used?
In essence, yes. You could have a contact column that they populate with an email address. Or you could have the form auto-populate the contact field and make that field hidden in the form. Then when they submit the form the notification could be set on that email address, when a new row is added or based on any number of criteria. You would designate the contact address from the form itself.
Hi, I'm using smartsheet to track updates on each task in a tracker. These updates may span over a year, so they get lengthy. I was excited about smartsheets because viewing these notes is a lot cleaner. However, I've just realized that there is a content limit to a cell, which is a huge issue. While excel was annoying to…
Hello, i've a question about 2 tasks. Task 1 has for example 4 hours and should be on day 1 for example 6 january. Task 2 has 30 hours and should be on start on 4 january and futher. How can i manage that on 6 january task 2 has only 4 hours? Now i got the message user is over-allocated because task 2 is planned on a full…
Hi All, We have several update automations on various solutions - and have worked very well for getting info from people that dont have smartsheet access - how ever in Sept we switched over to SSO and MFA and activated the Safe Share - We have now run into an issue that when our update automations trigger and people within…
