help with my Index Match formula.
![System](https://us.v-cdn.net/6031209/uploads/userpics/650/n67RVONBT7K0D.png)
Answers
-
Hi all,
I need help with my Index Match formula.
So I want to collect Invoice values for different months (Example "Invoice July'23" column) and I used the formula below but it returns "No Match"
- =INDEX([Invoice Value]:[Invoice Value], MATCH(IFERROR(MONTH(@cell), 0) = 7, [Planned Finish]:[Planned Finish], 0))
Additionally, any suggestions as to how to add year to the formula, so that I only pull data for a specific year.
Below is the formula that I am currently use to get the sum of all the values per month for each year by replacing 7 and 2023 with the the corresponding values for the months and year respectively. However, I need to of double check for correctness. Hence the need to pull the data using 1 above.
"=SUMIFS([Invoice Value]:[Invoice Value], [Planned Finish]:[Planned Finish], IFERROR(MONTH(@cell), 0) = 7, [Planned Finish]:[Planned Finish], IFERROR(YEAR(@cell), 0) = 2023)"
-
Try an INDEX/COLLECT instead. The COLLECT function would be filled in exactly like the SUMIFS.
=INDEX(COLLECT(............), 1)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!