If a task has a number of sun-tasks, and their status is updated (Not started, In Progress, Complete), how can the overall task (parent) status be automatically updated. Craig
I am interesting in knowing how to share a report to certain users, so they can edit some columns and attach files without having to share the source sheet of that report, or if is there's a way in which the user can edit only the rows assigned to them without being able to view the source sheet.
I want to automatically export a .CSV file (when a form is submitted) from a smartsheet. Then I want an automated upload of that .CSV into my goggle map. I am trying to map out the city and state of a location from a form. Is there a way to complete this?
I would like to add a link back to the dashboard in the spreadsheets. However, when adding this link to the first row (screenshot attached), it makes it more complicated to use the filter and sort options. Does anyone have a suggestion how best to insert links to dashboards in the spreadsheets?
Hello, I have consolidated 17 files into one and have created a workflow which ensures that every time a new row is added on these sheets, it will be copied on to the consolidated sheet as well. But the downside is that every time a row data is updated on these 17 sheets, it creates a duplicate row in the consolidated…
Does anyone have a reason to why my Smartsheet report has sums and counts BUT my email attachment does not have any Sums or counts included.
is there a easy way to set up your print area for dashboard. i am trying to print out graphs and I am having to go back and fourth to check if I am fitting within the print area. I am trying to do 1 graph per page.
For my graphs, I would to see them graph from largest bucket to smallest bucket. So this chart here would start with ITAdmin and then roll down to the smallest: Since this is cumulative data, I don't want to manipulate the master report to be largest to smallest since the data can change on a daily basis. Any way to do…
Hi all, I have a two contact columns that I want to run in an automation, but I'm trying to see if there is a way to just populate the same name throughout the whole column (without having someone update those cells when adding a line). I'd like it to just carry down the whole sheet like I can set a column formula- does…
Hi, I want to move rows to an archive sheet if the user clicks a box saying "Yes Move this Row" but I only want it to happen after a date in a separate column has passed. I have automation set up for Triggers: "When Rows are changed" and "When 'Yes Move This Row' is checked" and "Run when triggered " With the condition…
Hi there, I am hoping to find a way for our staff who submit information through form to receive an email confirmation without having to get a copy of the information they fill in the form. At the moment the only email option is to have them get a copy of their response to the form, but I don't want them to have a copy of…
How would one go about getting access to a sheet/form if the person that created it is no longer employed?
Help shape the future of Smartsheet. Share your ideas and feature requests.