-
Seemingly Easy Formula For Countifs on a Rollup Sheet With OR...
I'm working on a rollup sheet where I want to count two instances in the same column. I am currently counting one instance and the formula works fine. When I try to add the second instance it returns unparseable. See below: Current Working Formula: =COUNTIFS({FY21 PEP Dec 20 Cycle (v1) Range 5}, "1", {FY21 PEP Dec 20 Cycle…
-
Need Formula with IF
Hi , I want to create this formula IF the cell's text include specific word or sign than to change it to blank and the same formula condition but to change it to specific text Thank you
-
Commission Formula
Evening, Hope you're all well. I’m hitting a brick wall inserting a formula into a tracker for my sales teams commission structure which is being redone. It’s a tiered system whereby the salesperson will get commission in brackets until they reach target, and then a higher percentage on anything over target; (0.1% for the…
-
Newbie: INDEX and cross-sheet reference.
Hi...and thank you for any help you can offer. It is quite a transition from Excel and Google Sheets to SmartSheet, but I know it's going to be worth it! I am trying to make a master sheet and then use different columns of data in other sheets. I know this works for 1 row: =INDEX({Symbol}, 1) I cannot figure out how to…
-
How to convert a number with a fraction reading as text, to a number (3 2/3) to 3.66
I'm having an issue with incoming data being read as a text. I need it changed to read as a number so I can incorporate formulas. I've tried a few value formulas. The initial formula to pull the numbers from the original text is substitute function. Thanks in advance
-
Symbols Color Change based on Dates
Hello, I'm looking for a formula that will automatically change based on close we are to the due date. So let's say the following: 30 days till the live date, Green 15 days till the live date, Blue 5 days till the live date, Yellow under 5 days, red Thanks in advance.
-
Sales Projections Sheet
Hello All: I'm working on a sales projections sheet and looking to create and easy to notice symbol, on target, below target, and off-target. What is the formula to be able to easily create this? Thanks in advance. MH
-
Multiple IF statements
Hi, I'm attemping to assign PRICE to items based on CONDITION and CATEGORY but my limited skills with formulas are keeping me from my desired results. I'm hoping some one can help me out. In my PRICE column if have the following formula. It works for the "Chair" category but nothing else. Any guidance is appreciated.…
-
how do i import multiple large googlesheets, with multiple worksheets, and then integrate them?
Hi, I have inherited several google worksheets. each worksheet is stand alone, with about 20+ workbooks per sheet. the first several workbooks of each sheet are basically summary dashboards of the remaining workbooks. so there's lots of vlookups, sumifs and so forth. When I try to import, of course only the first sheet of…
-
Formula to fill multi-select from a join of other columns?
Hi, See my use case below. I'm using columns as shown in (1) for users to identify which documents are required per category (rows). I use simple formula columns in (2) to get the appropriate text. My target is a formula which yields a result as (3). However, I don't know how to do it and end up with (4) which just…