Looking for a way to copy specific cell to another sheet. I know how to do a full Row, but in the other sheet we are not looking for ALL of the columns and only certain columns are needed in the other…
Hi all, I am trying to make a chart that references a report, and I have been successful in capturing the avg, and count values of groups I made inside the report. Where I am having trouble, is that I…
Good Morning, I have a form that has a few check boxes. Depending on what checkbox is selected, different people are assigned to a task, but it's for a single entry/row. Is there a way on a form to ma…
Both of these extremely basic automations fail to populate the requested fields. A form is used to add rows to the sheet, so I realize the status (1) default could be set on the form, but why doesn't …
We would like to automate the following: "When a row is added, generate a specific document, and print to a specific printer". The idea is that the visitor to the office fills in a form with their det…
We have a project intake sheet and a status sheet. When a project estimated completion date is changed on the status sheet, we want to update the intake sheet to reflect the new date. However, Smartsh…
I am trying to conduct a survey at 100+ locations and use the survey results to generate a "custom" action plan for each site based on the responses. Once the action plan/ task list has been created I…
Hello team, I am looking to set up an automated alert based on the last modified date column within my sheet. The purpose being an alert sent out to my team on entries that have not been updated withi…
Hi All! I'm back with another project for work. This time I am trying to auto assign values to a column. Essentially we have tasks as rows, and one of the columns in the row is percent completed. I wo…
Hello, I am new to smartsheets and I am having difficulties setting up basic Health Formula with RYG+Gray bullets based on Status (Cancelled, Delivered) and Due date column. GRAY when Status is Cancel…