Hello, I am trying to count number of late documents within a specific section of the sheet. I have been able to do it successfully using row numbers but we change rows frequently because it is a rost…
Is it possible to reference either a Specific Cell in the body of an email notification/automation or to reference a sheet summary field? In my "Alert Someone" notification, I am wanting to reference …
Hi, I am having difficulty with my formulas referencing summary sheet cells. My goal is to indicate a date range in the summary sheet cells, input a customer, and have it a summary cell show the sum o…
Hi all - we're in the process of trying to move from Asana to Smartsheet. In Asana, you can set "collaborators" on tasks and they will get notified of changes, even if they are not directly tagged in …
I made a pie chart from one of my sheets. I wanted to show how much was spent based on each category. However, in the widget it shows two of the same category in different slices. I'll include an exam…
Hi all I have this formula in one of the summary sections for tracking the SLA of job completions as part of a number of others, mainly for the creation of graphs and percentages etc and a lot of them…
I have 2 sheets and want to be able to pull the value from a sheet summary field on Sheet A into a cell in the grid of Sheet B. Is there a way to directly reference this? I know how to cell link from …
Hello Everyone, I appreciate any help on this topic. I am starting a study of our construction efficiency looking at our last 30 projects. One of the data points we are digging into is our "planned" L…
Hi - I have created a sheet summary report, in which the projects are sorted by a completion date. When exporting to PDF, the order is completely random and has 0 logical sense, not matching any other…
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…