-
Return latest value, by date, if criteria match
My brain is absolutely melting over this one. I'm not sure if what I'm looking for is too involved, or if I am just truly not understanding how to piece these formulas together (the latter is 100% likely the case). I'm looking to do the following in a Summary field: Step 1: Return the latest value from Supplier based on…
-
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…
-
How to track Sheet Summary daily updates
In the below snapshot we have sheet summary data and would like to track progress. What is the best way to track the data daily/weekly to trend the information? The goal is to trend the data for progress on a dashboard. Any suggestions are much appreciated. Thank you, David
-
How to pull the top row only to sheet summary
What is the best formula to pull the top row only from the sheet I am in to the sheet summary fields?
-
SUMIFS excluding criteria
I am trying to sum the amount awarded to programs that have been won by all clients except Client X, Client Y or Client Z but my formula below is coming up #UNPARSEABLE. What am I doing wrong? =SUMIFS([Amount Awarded]:[Amount Awarded], [Customer Name]:[Customer Name], <> ”Client X", <> ”Client Y”, <> “Client Z”,…
-
Is there a way to add a new summary field from a master project template?
Wanting to create a project template that allows me to add new summary fields and have those summary fields populate all of the sheets created with the template, is this possible?
-
Stumped: COUNTIF Formula for 4 criteria and 2 ranges.
Hello! This is my first time utilizing the Smartsheet Community 😊 I am trying to develop a report that highlights the number of requests across four different categories (RFPs, New Programs, Funding Rounds, and Rolling Applications) within four fiscal quarters. So ideally, I want a formula on my sheet summary to tell me:…
-
How to reference Sheet Summary cell in the text of an automation?
I've been usign columns references in the text of my automations messages a while now. It looks like that. The text is in french but you can see the symbols used. Bonjour {{Fournisseur}} Voici la confirmation de commande pour le projet {{Projet}}. La date de début est le {{Date de début}} La date de fin est le {{Date de…
-
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.
