I Need assistance with Formulas in Smart Sheets.
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
Comments
-
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.
-
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.
-
Thank you so much for looking into this formula, if you would like you can email at dr@ttpdr.com
Thank you,
David
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives