-
If/Index/Match help!!
Hi! I am relatively new to Smartsheet. Usually I can poke along and work through to get the result. Today, not so much. I am trying to pull data based on data input. With the data, I need to match and select from one of 3 columns on another sheet. I have attached a couple screenshots. User selects accumulation from the…
-
Column formula to sum children
I am struggling with my formula. I have a helper column that identified Parents (1) and Children (empty) I have a column that contains a value for all children, I like to create a column formula that always provides a total of all children values at the parents row (yellow) when the parent has children. My formula has an…
-
Sum dollars based on names in multiple columns
I have a shared tips sheet. A big tip is divided by the coaches that are coaching for the group. If John is coach 1, Dave is coach 2, and Skye is coach 3, then the $30 tip would be split $10 each. The next group may have Skye , Mike, and Nate and may have a $60 tip. Etc. I am trying to write a formula that says of Skye is…
-
Index Collect value based on a date
I want to index a value if the "This Sheet Date" on my final result sheet is greater than "Date Value Effective" on my database sheet. Screenshots should help. I have a column showing the value that I want it to return. It's showing me the 2% because technically all of the "This Sheet Dates" are greater than the "Date…
-
How to sum total meeting hours members of a project will have to attend?
I have a Smartsheet that contains the meeting name, the number of hours the meeting will be conducted, and a contact list of the attendees of each meeting for a project. I would like to create a formula that will sum the total meeting hours each member of the project team will be expected to attend. For example, the…
-
Subtraction Issue when there is no input
Hello, I have two separate formulae to collect data based off of dates and input, I need a further formula to subtract one from the other, but I am struggling to get it to work. Subtracting them works fine, Cell v Cell, until there is no data input. I thought perhaps ISNUMBER might be a strong way to go but hit an…
-
Multi-select Dropdown - Select Starting Number characters From Each Option
Hello, I am trying to create a helper column that pulls data from one of my Multi-select Dropdown columns. The data I want the helper column to collect is the number portion of each option selected in the Multi-select Dropdown. I've looked a several posts showing how to pull text strings from multi-select options, but it…
-
Reporting from worksheet with heirarchy
I have a worksheet that has parent child relationships. I have created a couple of 'helper' rows ('HELP-Phase' and 'HELP-Phase 1') to aid areport in illustrating the parent child relationships (i.e., group by one of the 'helper' rows). The % Complete and the date columns are not displaying in the 'group' heading. I would…
-
Pipedrive + Smartsheets
When a deal in my pipedrive reaches a new stage 'Job Scheduled' it automatically adds a new row to Smart Sheets with a Task Name and Duration. What I need Smartsheets to do next is automatically enter a starting and end date based off of the row above Predecessors and autofill a new Predecessors for the next row that will…
-
Right formula
I am looking to extract the string of data to the right of the LAST "/". Here is my formula =RIGHT([HELP-Phase]@row, FIND(" / ", [HELP-Phase]@row)) HELP-Phase cell contains the below; Project Platform (2022-1107) / Core Concept Design and Business Modeling / Creative Development and Attraction Design (Phase 2) What I am…