-
Automate message to a contact on a separate sheet
I have a complex sheet of information about people who finish a certification. This sheet includes their department. On a separate sheet, I"ve created a contact list of their managers including a Contact column and the department. Sometimes units have up to 3 managers for the same department. When the person in the first…
-
Submission checklist to reference production schedule
Good morning, I have 2 Sheets Master Production Schedule - consists of multiple columns, Job #, Job Name, Line 2 Count, Forms Submitted?, and Status Check List Submission - consists of multiple columns, Job #, Job Name, Line 2 Count, Submitted, Outstanding Entries, Missing Form Override(Checkbox), and Status The idea is…
-
Which implements first: a column actions or "Move" automations?
I have a sheet that collects content from a Form and includes some auto-filled columns and column formulas, but also automations to Move rows depending on the contents of other columns. I'm wondering if Smartsheet will complete the column actions and formulas before completing the Move automation, or if the Move automation…
-
Form URLs should automatically update on newly saved dashboards when copying a workspace template
As a user, I would like form URLs to automatically update on newly saved dashboards when copying a workspace, So that I do not have to manually update the Form URLs and prevent the risk of forms accidentally pointing to the original sheet or workspace. Please refer to case # 05972330, as this had been previously assumed to…
-
how to automatically send email with photo attachment
Hello, I want to automate an email that includes a photo attachment when a job is completed. The photo is proof to the customer that the task has been completed. Is this possible in smartsheet and if so, how do I do that? thank you!
-
Creating Conditions that affect other rows
Hello, I am super new to smart sheets, but have done very well with 99% of what I have needed to accomplish, however… When trying to create a condition labeled "Yes | No," and if Yes is selected in that row, then I want it to highlight another row also in the primary column to red to highlight it being the next step to…
-
Drop PDF to populate rows
As a sourcing analyst I have to take multiple pricing summaries from our consultants and enter the information into our Smartsheet. Currently that means a lot of copy and pasting and painful data entry. My question: Is there a way I can take the PDF they send me and drop it in Smartsheet and it auto populate my sheet based…
-
How can I create a Task/ To-Do List for each team member?
Hello, Looking to develop a task list for team members from our Project Tracker. Our sheet runs left to right and uses Column Headers to organize information rather than using Parent/Child row hierarchy. Currently, each step of the project has an expected completed date (automated by formula), an actual date column…
-
Automation DocuSign Save As Draft
It would be helpful if we could use the automation - workflow to trigger a Generate Documents - DocuSign but use the 'Save as Draft' option. Currently, we use the 'save as draft' feature as we need to add additional documents to the DocuSign envelop. However, it would save us time if the creating the draft in DocuSign…
-
Large Sheet Notifications
We have a handful of very intricate, detailed, and logic-filled intake forms that are tracked in 3 separate master sheets separated by the type of intake. Each sheet is over 150 columns wide. We need to send a copy of the entire submission to the person who submitted it, along with several others selected in contact fields…