-
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…
-
Nested Criteria on COLLECT
I'm trying to get an income by multiplying quantity with Price. Price is located on another sheet so I have to find it based on type, route, and active date. Here's the formula that I have: =IFERROR([Economy QTY]@row * (INDEX(COLLECT({Price Range}; {Type Range}; "Economy"; {Route Range}; CONTAINS(Route@row; @cell); {Active…
-
Best formula for a complicated desired result?
Hello, I have tried many different formulas and even tried combining formulas but can't seem to get one that works in a way for syntax to be used as a column formula. Any help would be appreciated, and I thank anyone in advance for tackling this. The desire result is a formula that can be converted into a column formula…
-
I would like to make an IF index collect
I am working on creating an IF(ISBLANK({cross sheet reference of column}), " ", Index(Collect({ NAME},{cross sheet Helper column}, helpercolumn@row,{cross sheet status}, "Status, {CrossSheetDate}, Contains("/",{CrossSheetDate}),1) I get an error for the contains part and the formula works without the date, but I am trying…
