vlookup with id and date range
Hello:
I am super thrilled that I have mastered a formula that originated in Ecwid, used zapier to populate a smartsheets and then with a sumif in my smartsheets row I matched the participant id and date range to plug a payment in for a participant in our program. I want to pull the associated payment number/Ecwid Id into the same row as a reference. I am having a hard time figuring it out. It is true that there could be multiple payments in one week, so I could concatenate the payment numbers from Ecwid.
HELP. Can I reference the same rows that the sumif came from some how?
Here is my sumif: =SUMIFS({Square Payments Range 2}, {Square Payments Range 1}, [Participant ID]749, {BIP Online Payments Range 1}, <=[Group Date]749, {BIP Online Payments Range 1}, >([Group Date]749 - 7))
Not sure how to share the sheets without also sharing all the data? Thank you for all the help you might offer.
Answers
-
Are you able to share a screenshot with sensitive/confidential data removed, blocked, and/or replaced with mock data? If needed, you could "save as new" and just replace names with fictional names and that kind of thing. It doesn't even need to be a fully operational sheet. Just what you currently have and then what you want (manually entered).
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!