-
How to edit who receives automated emails.
Hello! I have a sheet that sends out emails on the first Monday of each month that contains a pdf copy of the sheet. I would like to edit who receives these emails but cannot find where to do this. The sheet does not have any automation workflows so I am stumped. Thanks in advance for your help!
-
Symbol column - Empty, Quarter, Half, 3/4 and Whole - Update Color
Hello, When doing a project plan, I'd like the ability to update how this symbol color shows up based on what they choose for their milestone completion progress in this column. Right now it shows up as light gray however that is usually the color of the header rows and it is hard to see. It would be nice to have the…
-
Create Automation to update Harvey Ball color based on other columns of data
Hello, please create an automation that can update a symbol column based on other columns of data. For example, if the At Risk Flag is checked, change the Harvey Ball to Red for that row in a project plan. I know how to use a formula however we do not want to do this as I want the balls to be editable by the project owners.
-
Sync all Projects with a Template
Would be great to have any changes made to a template to also be changed in all sheets that were made with that template. Would make updating projects much easier as currently you have to go through each individual project if you need to make a change like adding a new column.
-
Employee Schedule
I have a list of 4 employees who visit various sites in the course of a week. My requirements: Each week I want the system to automatically send each employee a form that they populate for each day of the week with fields - date, time start, time finish, site. Example: Employee Name: Abby 6 June 2022 , 09h00, 10h00, Site…
-
Is there a way to set up automations based on what "was" in a cell?
As the title states, I'm trying to set up a couple specific automations. I feel like this used to work, but I am running into roadblocks. Is there a way to set up automations that accounts for what "was" in a cell? This option does not seem to be available in conditions. Two examples: How would you set up an automation to…
-
Increase Automation Workflow Limit
To increase the number of automations (currently 5) that can be run at one given time/sheet would be awesome. I've been receiving errors from the automations created that are erroring because it reaches the limit of only 5 automations running at one time. Looking forward to hearing back on this idea/request.
-
Automatically Add New Sheets to an Existing Report
Can new sheets be added to an existing report automatically? I am using Smartsheet as a project tracking tool. As I add new project schedules, I want those new schedules to feed an existing tasks assignment report. Can I do this?
-
Form timer
Suggestion to have the option to limit the time a form is accessed, from the time the user begins/enters the form. If the form was not submitted prior to the time limit, the form would close and capture answers up to that point. We want to use this feature for interview assessments sent out to candidates. It allows us to…
-
Merged: Copying automation from one sheet to various sheets
This discussion has been merged.
