-
Finding unique values from Column, then listing them in another sheet
Here is my problem: I have a column that has multiple different dates listed. I want a formula that will allow me to find the unique dates and then list just the unique dates in a different column. I have done a lot of research and I know I need a helper column but I'm struggling with the examples I have found. Any…
-
Generate List of Unique Values - INDEX? DISTINCT? VLOOKUP?
I'm trying to have Smartsheet create a list of unique data *without* using Reports. Help (-: In the Names table in the screenshot, you can see that there are names manually entered a number of times in random order. That is fine and good. What I'm trying to do is is have a second sheet have a "Names - Unique" column which…
-
Build List of Unique Values FROM A SEPARATE SHEET
Hello, I need to create entries in sheet A that contains only unique values from a column in sheet B. I've set a checkbox in the sheet B to identify the corresponding values to place in sheet A. Can someone please share the syntax to actually populate sheet A? Thanks in advance, Bill
-
Formula for running six-month total points for many employees
I am tasked with designing a sheet to track points that employees (~250) accrue daily (Sunday-Saturday). Point categories are 0.25, 0.50, 0.75, 1.00, and 2.00. The running points total needs to be over six months. I'm not great at formulas and from what I've seen in other Community posts about running six-month totals, the…
-
What formula can I use to count both the blank spaces of a column and the data from another column?
I want to count the blank spaces of a column titled "completed" where the cells are either blank or have "yes" on them, while at the same time counting the cells of another column in which the cells are blank, "enrolled" and "waitlisted"
-
Update sheet reference when copying sheet to new workspace
Hello, I created a template PMO workspace with sheets cross referencing each other at the project level. When I add a project and copy the sheets from the template to the new project, I want it to auto update the cross-sheet references with the sheets, that are named the same, in the new project. Is this possible or do I…
-
How do I set dates in a project schedule that automatically update when a prerequisite is met?
I am putting together a phase schedule for a project I'm on. We are currently in the "awaiting deliverables" stage, and we have preset 'assumed' start and end dates for all the tasks in each of the phases when we officially begin work on the project. I need to somehow set up the schedule that if deliverables arrive…
-
Counting prior month data
Hello, I'm trying to report on prior month data points within a Dashboard I created. I've built a metric sheet off a "master" sheet. I've attached a screen shot of the metric sheet and a screen shot of the master sheet columns. Here is the formula I've been using to capture metrics - it needs to be changed to capture prior…
-
COUNTIFS Formula with multiple criteria including a checkbox
Hello, I tried multiple formulas and can't seem to figure out to do a count that includes a report code (e.g., OWCA1) and a checkbox. Here is what I have so far: =COUNTIFS({UHG Risk Control Matrix Range 2}, CONTAINS("OWCA1", @cell), {UHG Risk Control Matrix Range 1}, CONTAINS("1", @cell)) Thank you for any help!!
-
Workflow notification - not providing correct information
When receiving the email notification, it does not show the added information but these set cells. This was not previously an issue, and without a workflow change it began doing this... Any thoughts on how to get it to just show the changed or added rows?
