I Need assistance with Formulas in Smart Sheets.

Basedr

Hello, i am having difficulty with formulas in SmartSheets, Index, Match, and IF Statements.  If anyone is an expert, I can get the formula to work in Excel but not in SmartSheets.

I have used the help desk, all the formulas they have tried have not worked, I found 1 expert in the Pro Desk who could help the other could not, I have been told I need 10 hours of time at a cost of $2,500.  I can not afford that for a formula that works in excel just not in Smartsheets

Please advise, I have been working on this formula for 3 weeks

Excel Formula

 

1.) =IF(J10="Retail",INDEX('commission and Revenue.TC.316.T'!$X$7:$X$24,MATCH(Sheet1!K10,'commission and Revenue.TC.316.T'!$AA$7:$AA$24,0)),0)*I10

1.) with notes =IF(J"this Number Rolls"10="Retail",INDEX('commission and Revenue.TC.316.T'!$X$7:$X$24,MATCH(Sheet1!K"this Number Rolls"10,'commission and Revenue.TC.316.T'!$AA$7:$AA$24,0)),0)*I"this Number Rolls"10

OR this one

2.) =INDEX('commission and Revenue.TC.316.T'!$X$7:$X$24,MATCH('Sheet1 (1)'!K10,'commission and Revenue.TC.316.T'!$AA$7:$AA$24,0))*i225

2.) with notes =INDEX('commission and Revenue.TC.316.T'!$X$7:$X$24,MATCH('Sheet1 (1)'!K"this Number Rolls"10,'commission and Revenue.TC.316.T'!$AA$7:$AA$24,0))*i"this Number Rolls"225

Thank you,

David 

Paul Newcome

Can you explain in detail exactly what you are trying to accomplish with the formula? Screenshots with sensitive/confidential data blocked, removed, or replaced with "dummy data" would also be very helpful.

Andrée Starå

Hi David,

Can you describe your process in more detail and maybe share the Excel file/sheet (s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Basedr

Thank you so much for looking into this formula, if you would like you can email at dr@ttpdr.com

Thank you,

David