Sheet Summary
Discussion List
- I have a project tracking sheet where the "Assigned To" field is a contact list. For the first row of the sheet, the Assigned To cell is calculated based on a Summary Sheet value (=[IT Contact]#). All…
- 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% lik…
- 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 p…
- 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 progr…
- What is the best formula to pull the top row only from the sheet I am in to the sheet summary fields?
- 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…
- 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?
- 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 …
- 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 conf…
- 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 mu…