-
Cell Linking User Distro List from one Sheet to another Sheet Summary for Copy and Pasting
Hello, I have a user column contact list with user emails in one sheet (1) and two additional columns for different distro lists that each user is a part of. I am linking these columns/cells to a project roadmap sheet (2). As part of Sheet 2, I am utilizing the sheet summary and I have added fields within the sheet summary…
-
Column functionality breaks when copying sheet
I have a template that I created to use for several projects within my org. When I create a new sheet from this template my Duration and % complete columns completely break and do not work anymore. I have removed and recreated the columns to see if this will rectify the issue and it does not. No matter what I do I cannot…
-
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…
