-
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…
-
Need help with buried IF statements.
I need help with a formula that I think will have multiple IF statements. Please see below. I am trying to determine the Maint Tech YTD Score. For the formula, we will only be using the "Community Average Score", "Company Wide Satisfaction Avg.", and the "Score Delta". We are comparing the Score Delta to the Company Wide…
-
How to pull rows from a different sheet only if they're marked as "in progress" ?
Hi there, I'm looking for a way to pull rows from another sheet if they are marked as "in progress" (or any other status that's not "complete"). Ideally, I'd want to pull everything from that row and not just a single cell. Is there a way to do this? Thanks in advance!