-
INDEX MATCH is matching same values to everything
Good morning all, I'm having some issues with this INDEX MATCH, that are really stumping me. Here is my formula: =INDEX({NE INVOICES Range 4}, MATCH([PO#]@row, {NE INVOICES Range 1})) And here is what I'm getting: This would normally be fine, as those PO's don't exist on my source (Here is the source sheet) The issue is as…
-
Can I get Unique values on a metric sheet without a complicated work around or report?
I have a column with associate names, over 3,000 rows with over 100 unique names. In order to provide dashboards, I need a dynamic list of unique names listed in that column on a sheet I use to build our KPI metrics. Easy in excel or any other dashboarding tool I use, is this now possible in Smartsheet without using the…
-
Adding year to quarterly equation to count
I want to count how many projects in each network have expected completion dates within the quarter per year. For example, in Upstream, I know 3 projects will complete in Q1 2024 but 1 will complete in Q1 2025. The formula I'm using won't account for the year and count correctly for what I know are the actual expected…
-
Is there a way to have text repeat all the way down the primary column?
Is there a way to have text repeat all the way down the primary column, even when new rows are added without having to manually enter? I am trying to use this as a helper column so this is what displays in the calendar.
-
How can I use a function to pull dates from Sheet A to Sheet B?
I have a master sheet of dates for multiple programs and projects. The layout of the sheet is: Program | Project | Start Date | End Date Each program is divided into hierarchies as such: Program A --Program A-1 ----Program A-1 | Project A | Start Date | End Date ----Program A-1 | Project B | Start Date | End Date…
-
Auto Calcuate Due Date Formula
I am trying to calculate a due date based upon a 5, 15, 30 day criteria. The problem I am running into is that the way I have the 1st row of each area setup (it is broken down by equipment, then sub categorized into dates). I have a formula setup to auto calculate the # of days criteria based upon "low, medium, high"…
-
What formula to write - Vlookup or Index/Collect Formula???
Hello, I am creating a New Hire and CFO Buddy Tracker to assist me with paring new hires to mentors within the company. I have two sheets set up one that has the name of all the mentors currently available and another with the list of New Hires. The idea is that on the Mentor list I want it populate with the name of the…
-
Want a formula to autopopulate the task names of other rows
So, I have a project. We have milestones listed at the top, which are not tied to any waterfall style deliverables. They are just each their own milestone, with 0 duration, and manually entered dates. I don't want to create a complex GANTT chart just to get the dependencies between milestones to show. So I am trying to…
-
Im trying to assign a formula only to parent cells, to get % completed
I have a column called "Done" and i want the child cells to have checkboxes and the parents to have the % of the project done( some rows dont have child cells and are stand alone). I have a formula that works: =IF(COUNT(CHILDREN([Primary Column]@row)) >= 1, COUNTIF(CHILDREN(), true) / COUNT(CHILDREN()) * 100 + "%") but I…
-
RYG based on cell value
Hello, I'm trying to set the RYG ball based on the value of a cell and I can't seem to get it right. If the value is: Greater than 0 = Green Between 0 - 0.5 = Yellow Less than 0 = Red =IF(Remaining@row > 0, "Green", IF((Remaining@row >0, AND(IF(Remaining@row<0.50,))), "Yellow", IF(Remaining@row<0), "Red")))
