-
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…
-
How do you automatically populate columns from a master sheet if a specific item is selected?
Hi All, I'm building a database of products and would like to automatically populate different data when a specific product is chosen from a drop-down column. For example: Column A > Product Column: Select "Software A" -automatically populates- Column B > Marketing Manager: John Smith Column C > Product Manager: Sally…
-
Need Help with multiple IF statements within a formula
Attempting to update a status column to show either Not Started, In Progress, or Complete based on blank or not blank statements from other columns. These formulas work by them selves. =IF(COLUMN1@row = "", "Not Started", "In Progress") =IF([COLUMN 10]@row <> "", "Complete") but put together and they don't. I get the…
-
Sumifs totals - how to carry formula to other columns
I am using a sumifs formula with the same criteria to total 15 columns on my sheet. How do I carry this formula to other columns to maintain the criteria and sum up the total of the column it was carried to? I saw posts from 2018 saying this wasn't possible. Is there newer information on this? I appreciate any help you can…
