-
Update assignments in template based on sheet
How can I assign ownership to tasks based on contacts in a sheet? For example - I have a list of contacts that define the owner of each area for every project. As I am creating a new project from a template, I would like to lookup the owners for the tasks based on the information in the sheet. Example - project below would…
-
Automating Cell Link
I've created a workflow to handle project requests that come in to our department. We have a master sheet where all new requests are entered (either manually or from a webform) then each of our 3 team members have an individual sheet. When the new project is assigned, the row is copied to the individual's sheet (to whom it…
-
want to create a tally sheet
Hi all thanks for any assistance you can offer I'm trying to create a tally sheet that reads from a couple column in another sheet and counts each individual answer. So the first column is "contact person 1" and i want to be able to have the sheet count the numbers for each person in the contact person 1 column and then…
-
Multi-Step Workflow: Creating and Linking Forms with Unique Identifiers
Good morning! I'm trying the following in Smartsheet: 1. Create a form that has a field to input multiple emails, each submission has a Unique ID. 2. When the form gets submitted, it will send an email to the emails in the submition with a new form of a different sheet. 3. Once the second form is filled by the email…
-
Is there a way to include a row link in an email automation?
When email automations are received, the user has a link just to that sheet and then has to navigate to find the right row, comment, attachment, etc. Is there a way to set up the email automation so that a link to the row is provided? It would save time if the user can click and be directly sent to that exact row to…
-
How do I run an automation after the row has been created?
Trigger won't work if the row has been created, and no change. Automation is an after thought... If the row has been created and saved and I need to Automate actions, such as moving a row to another sheet if it contains a certain status, how do I run it? It won't let me run this Hourly or Daily... If I manually run it, it…
-
Automated Response on License Requests
Since we, as Admins, cannot turn off the Updated User Requests, can there be a way to create an automated response with information on the policy our company has developed for obtaining a Smartsheet license? This could include any links to a request form with built-in approval automation. Thanks
-
Searching for Smartsheet job FT or Contract
Hi everyone, I am a Smartsheet certified Administrator and have been using the product for over six years. Recently was laid off and looking for a role that is is more Smartsheet centered. My background is in project management and most recently scrum master/senior deliver lead. I am skilled at creating and maintaining…
-
File upload to google docs
Hey all, New and generally overwhelmed user and Admin. We are a small consulting business with 2 staff/owners. We are tracking all financials (invoices, expenses) on the platform. We use forms to take pictures of receipts and it works beautifully. Our bookkeeper wants all of our receipts uploaded to google drive as PDF…
-
How do I add comments in automated email alerts?
Hi all, I've been working with my sheet on sending automated emails to contacts within the sheet and can add specific parameters for what is in a cell. However, I can't figure out how I can display the comments in the email without having a link to the form. The reason I don't want a link to the form is because these…