I Need assistance with Formulas in Smart Sheets.

Options
edited 12/09/19

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

• ✭✭✭✭✭✭
Options

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.

• ✭✭✭✭✭✭
Options

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• edited 10/16/19
Options

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

Thank you,

David