-
Is there a Way to Emulate SUMPRODUCT In Smartsheet With a Cross Sheet Reference?
Hi all! I am trying to create a SUMPRODUCT in Smartsheet, however when I do I receive the "INVALID OPERATION" error. This is how I was trying to go about it; I created a helper column where I would multiply both A x B, then I was simply going to sum up all the products. The issue I'm encountering is with the first part. I…
-
Max Collect in Sheet Summary
I'm trying to have the Sheet Summary list the employee name from the Repeat Category Winner column with the highest Repeat Count per Category, and I have 3 categories that I will use this for (Timesheet Not Submitted, Timesheet Not Approved and Time Off Not Approved). Formulas for those columns in the screenshots.
-
Formula to get sheet summary to update percentage complete based on category value
Hello! I am trying to manipulate a formula in my sheet summary to return a percentage complete based on the value selected in the dropdown menu I created. The formula I've tried (and a few variations of it) is: =100 * COUNTIFS([Review Complete]:[Review Complete], 1) / COUNTM([Primary Practice Area]:[Primary Practice Area],…
-
COUNTIFS, within a month AND not blank
I'm really struggling with countifs in my Sheet Summary. I added a helper column to sparse the month. I want to count if the created date is February, and if two columns containing IDs are not blank. =COUNTIFS([Month]:[Month], = 2,[Contact ID]:[Contact ID 2],""<>) I'm getting an #UNPARSEABLE error. I tried the formulas as…
-
Sheet Summary Formula Not Pulling All Data
Hello, I have a formula set to count how many projects are flagged within a specific function if they are listed as in progress, but the count is off and I can't figure out why it's not counting all instances. Is it because the column is allowing multiple selections in that column?
-
Control Center - Project Summary Data
I'm working with Control Center for the first time and setting up a blueprint. My project templates are pretty straightforward - project plan, RAID log, reports, dashboard, etc. I have a portfolio list which will serve as both the intake list and the portfolio list (using a status to identify what's new, approved, etc.).…
-
Maintaining Summary Sheet History
I use the summary sheet extensively for allowing project managers to provide high level summary reports on their projects. My c-suit would like to be able to see status report history. In absence of printing out PDFs each reporting cycle it would be great if Smartsheet could maintain an audit trail around changes to…
-
Sheet Summary Formula Error due to Formula in Sheet
I'm using Sheet Summaries to total up information in a large sheet. This sheet also uses formulas to pull information from other sheets. I receive a #NO MATCH error when attempting to use a COUNTIF formula in the Sheet Summary on fields that are being pulled from other sheets via formulas. Is there any way around this…
-
COUNTIFS formula not functioning how I expect
Hello, I am expecting this formula to count the number of cells in the "FND Prepare" column that have a certain name in them, where the cell on the same row in "Prepare Status" is not green. =COUNTIFS([FND Prepare]:[FND Prepare], HAS(@cell, "NAME"), [Prepared Status]:[Prepared Status], (@cell <> "Green")) Does someone have…
-
Returning A Symbol Value From Another Sheet
Hi all! I am trying to return a symbol value from a cross sheet reference, and I am having a little bit of difficulty at the moment. I have 2 sheets, we'll call the first sheet (that I am trying to reference) "Trends", and the second sheet "This Week". In "Trends", every row represents a week, and ta the end of every row…
