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
