-
Help with Global Update for rows added across 2 columns already updated on master sheet
I added 5 rows of data (across 2 columns) on one sheet of our current control center template and want to do a global update to edit all our workspaces. I was able to do GU for the new columns i added but don't know how to do same for new rows. One of the new row cells includes a formula as well. When i select the modify a…
-
Help with a complex Mutli Select Drop down formula!
Hello! I have a sheet which is connected to a form where the user can enter what services will be required (as a multi select dropdown option). What I want to be able to do is reference another sheet that has a 'practice' (line of business) that the service is related to and return all those values inside a second drop…
-
Copy Rows to another worksheet automation not working
hello, I'm trying to create a workflow that copy rows into another worksheet using automation however, I do not see my selected destination worksheet I have admin roles in both worksheets and i'm not sure why i couldn't see my reference worksheet in the search box as my destination file. can someone help how to fix?
-
Formula previously working (along with others) and not now
Hi all I have this formula in one of the summary sections for tracking the SLA of job completions as part of a number of others, mainly for the creation of graphs and percentages etc and a lot of them seem to have stopped working. They now say #INCORRECT ARGUMENT SET. None of the references have changed and I'm so confused…
-
I Need Help with IF Formula for Progress Bar Symbol Column to Function Accordingly
I'm trying to set up our Carpentry Shop's Progress Bar by how many hours they've used from the total hours they were assigned to use for the project. The following screenshot shows an example. The carpentry shop was assigned a total of 80 hours to use. So far they've used 40 hours. The progress bar's formula then updates…
-
How to Add Categories in Personal Budget Management Template
Hello. I am new-ish to SmartSheet. I am wondering if anyone can help me understand how to add more budget categories to the existing Personal Budget Management project template (specifically trying to add categories to the "Budget Setup" sheet in a way that keeps the formulas in tact... currently only a certain number of…
-
Sheet summary to populate date in sheet
Hi all, I'm currently creating a template to monitor store closures and need some support in setting up a way to populate a date from the sheet summary. The end goal is to when in use, to be able to populate the date for the activity to start and able to flag any outstanding points after 30 days. We are able to populate…
-
COUNTIFS formula question
I'm trying to count items on a sheet if they meet a certain criteria and contain a name and put that value on a different sheet. I'm using this formula =COUNTIFS({MT Rollup Sheet IT Lead}, CONTAINS($Label@row), AND {MT Rollup Sheet Project Status}, "Active") and receive an UNPARSED error. I want to count how many active…
-
Why is my Excel exported from a report empty?
Hello, I am trying to solve an issue I am having with exporting data from a report to an Excel sheet. We have a financial report that is exported to Excel on a weekly basis. This week when our employee went to create an Excel export of this report, the excel had no data and only showed header names. I tried exporting this…
-
Help Article updates
Hello Community, We’ve added a Video Tutorials page to help you dig deeper into some areas of Smartsheet. Read on to learn more about some of the content that is now available to you. Learning tracks recently launched or updated: Data Shuttle Learning Track Resource Management Learning Track To view the full catalog of…
