-
It's Only Blocked Until I Kick It
I have a formula that leverages some sheet summary formulas and returns a true/false to support a report filter. When I change data in the sheet the sheet summary formulas sometimes return a #BLOCKED, but it is not consistent. When it does, if I go into the formula and edit it (without actually changing anything), then the…
-
Creating a master metric sheet
I have been hunting through the threads for a few days, and have not been able to find a clear resource explaining how to set up a metric sheet and then combine into a master metric sheet. I had created a "metric sheet" with my metrics as columns (approx 50 of them), it appears from what little I can find I should have…
-
@ row used to determine month and year but summary formula is now invalid
Hi All, I have successfully created an @row formula to automatically populate in a cell in my sheet which is super awesome. For this example I am showing the Month Reported but I also used a similar formula for Year Reported. But now that I have that completed, my summary formula that previously worked no longer does. How…
-
Sheet summary formulas automatically extending when new rows are added
Hi community, I have a lot of formulas in the sheet summary of my sheet. They all start like this "=COUNTIFS(Project1:Project149, NOT(@cell = "Epic Line"), [Row ID]1:[Row ID]149, ISNUMBER(@cell), ....." Now the sheet gets new rows added every day but my number 149 in the formula does not update automatically to capture the…
-
Count how many "On Hold" projects for the Sheet Summary
I have a sheet set up with a (Multi Select) dropdown, and a complete check box, & would like to get a count of how many projects that are NOT complete & are On Hold. COLUMN: Info Still Needed - is a multi select dropdown COLUMN: Complete - is a check box I have tried several formulas with no luck.…
-
How to summarize and visualize sheet summary data of multiple sheets?
Hi! I've been using SmartSheet to track progress of different business units on a particular project. Each unit has its own sheet containing grid data that they fill out, as well as sheet summary data where I calculate different KPIs (e.g. number of records with specific status). For each unit, the sheet summary data is…
-
How do I count how many projects are "In Progress" or "Completed" ?
HI There, I feel this should be easy to figure out but i cant seem to! PLEASE HELP?! I have a column called "STATUS" , I have a drop down menu with the following under Status STAUS On Hold In Progress Cancelled Completed How do I show / count how many projects are "on Hold" or "Completed" or "Cancelled" Ideally this will…
-
Need help with creating report(s) with data from a Survey
Hello, I am still fairly new to Smartsheet and need some help turning around data from a survey I sent out. I have 600+ responses that I used the Request an Update function in Smartsheet to obtain, that I now need to summarize and I have no idea how to start the summary process. The survey is regarding Security Services at…
-
Sum Formula with other data is cells
Hello - Hopefully this is a simple question. I have a column that I am trying to sum the data in but the cells quantities and data inside each cell. Is it possible to sum the total quantity for the column? I am trying to avoid using a helper column to move the number out and sum off that if possible. The quantity's can…
-
Alert Someone Automation - Reference Contact In Summary Field
When configuring an Alert Someone workflow and selecting "send to contacts in a cell", is it possible to reference a contact in a Sheet Summary field for the sheet? The drop down selection only shows contacts columns within the body of the sheet.
