-
Gathering data from 1000 sheets
Hello, i have this question: We have more then 1000 sheets with some project progress calculated in certain cell. Then we have one master tracking sheet with 1 line = 1 project. What i need is: Link this progress number from each sheet to every corresponding line Use that number for further calculations (which is not a…
-
Creating separate charts on a dashboard using the same report
Hello, Our team created a large sheet that collects data from Smartsheet forms that vendors complete. We then score those answers and send them to a Vendor Vetting report that only shows the scores and some basic additional info (fake data below). Is there a way I can create charts in a dashboard that only shows data based…
-
Question on SumIFS
We're hosting a "Bike to the Moon" where our supporters are uploading their daily trips, miles and emails in a worksheet. We want to display a riders' individual trips (showing date and miles traveled) and a total miles field that sums across all their trips (rows.) I'm using this formula at the moment but I'd rather not…
-
#INVALID DATA TYPE Error
I am receiving an #INVALID DATA TYPE Error when I have blanks in the dates I am referencing. The formula is summing the equipment pieces based on the delivery month, but the delivery date can be added later in the project, so there will often be blanks. My formula is below: Adding an IFERROR avoids the error message, but I…
-
How do I pull risks and issues from multiple projects into another sheet?
I am trying to create a programme view over a number of projects. I want to be able to gather all the risks and issues from the various project raid logs into another sheet so, it can be displayed on a dashboard. How is the best way to do this?
-
Multiple Sheet Common Report
I am looking to set up a report or another function that can pull any names that are on two different sheets. I have two different groups and I want to see if the name from someone on list A is also on list B. Is there a way to do this? One list has about 2500 individuals and the other list has about 13,000.
-
OnCriticalPath in a formula?
Hi - Anyone know of a way to build a formula that determines if a row is on the critical path? It looks like, although we can filter rows by critical path we can't access that tag within a formula. My goal is to add a column called "on critical path?" that is checked if the row is on the Critical Path, and unchecked if it…
-
Autocomplete date range
Hi All, This is likely something quite straight forward that I'm over looking, but hoping someone may be able to advise - Still relativly new to smartsheets. I have a smartsheet, in which each row reports based on week numbers, such as the below formula. =COUNTIFS({Enquiry Tracker (V1) Range 4}, <=DATE(2020, 9, 6),…
-
How can I improve the efficiency of my sheet?
We are using a sheet to track a number of different measures which will provide a baseline for Q4 2020. These measures are tracked for a month, with detail and a RAG status being provided by a number of different people once a week from October 9th - 30th. At the moment, we have a separate column for each detail and RAG…
-
Totaling across summary sheets
I have created summary sheets in several of my departmental sheets to take the place of the metric section at the top. How can I summarize across all of the summary sheets? I see I can pull them into a report, but I cannot add a Totals or Average field summarize across the summary sheets. I thought I would simply add a…