-
Need help adding a 3rd argument to a COUNTIFS formula
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 roster type list I don't want to have to edit the formula each time. The third argument I wanted to use was to use their teams…
-
Reference Sheet Summary Field or specific Cell
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 either the sheet summary fields or a specific cell in my sheet.
-
Sheet Summary Sumifs with dynamic date range and customer look up
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 of all of the quoted jobs for that customer with in the specified date range. My customers are in a multi check box drop down…
-
Equivalent to Asana Collaborator Notifications?
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 as the person its assigned to, or @'d in a comment. Is there any way we can replicate that in Smartsheet? I would love to be…
-
How do I prevent a category from showing up multiple times in a Pie/Donut Chart?
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 example. Why is eLearning showing up as two separate parts instead of combined? Its the same category.
-
Formula previously working (along with others) and not now
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 seem to have stopped working. They now say #INCORRECT ARGUMENT SET. None of the references have changed and I'm so confused…
-
Access a Sheet Summary field from a different sheet?
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 a grid cell of Sheet A into Sheet B but not summary field. I guess I could set up a helper column in Sheet A to pull in the…
-
Gant Chart - How can we track the planned versus actual LAG days?
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" LAG days between certain trade partners. (LAG days are inside of our defined working days, and do not include non-working…
-
Sheet Summary Report - Exports in Completely Random Order
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 order that would exist. Not sure why the export can't match the sort input, or why grouping doesn't even matter when…
-
Resource Management and Contact 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 the task level Assigned To values are then selected from the contact list from-down. This works fine until I turn on…
