Index Match returning incorrect information
I have a smartsheet with trade numbers and I want to pull in the invoice number, invoice due date and invoice amount for the invoices tied to a specific trade number. I had it working correctly but then lost the formulas when I ran out of rows carrying the formula and now I can't get it to work right.
Each week I get a new invoice list that has about 50 lines on it. When I couldn't get the correct information returned (I realized it was wrong because it is giving me a due date of 3/8/24 when I know the due date is 5/15/24), I removed all lines except the one line that ties to my trade. When I did that, all three fields populated correctly. So I added back all the other lines and when I do that, the data in two of the three fields changes.
I've tried referencing the same trade number for all three fields initially. The one field that returns correct information is the invoice number. So then I tried referencing the invoice number for the two fields coming through incorrectly, and that doesn't help.
I've checked my table to make sure that there is only one reference tied to the trade number and there is just the one. So I don't understand why my formulas keep referencing a completely different trade for a different counterparty when the full list is populated but everything is correct with no error messages when just the specific details are listed.
Any ideas?
Answers
-
This has been resolved. It is all about the ,0 and where that goes.
-
Hi @Laurie C
I hope you're well and safe!
Excellent! I am glad that you got it working!
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
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.
Help Article Resources
Categories
Check out the Formula Handbook template!