Display Issue with Formula
I have another equation that is not displaying the value I need to pull down. I think I have the formula right, it's not coming back with an error, yet there is no numbers displaying. Ultimately I want it to pull down the generation from a previous year so wer can compare. Ideas/ Thoughts?
Best Answer

Hey @NuGenAdmin
I'm not sure I understand what you're trying to achieve. Try this to see if the guess was correct.
I purposely left off the IFERROR until the formula is working correctly as it will mask any error the formula generates.
=INDEX(COLLECT([Also Energy Production]:[Also Energy Production], Year:Year, [Previous Year]@row, Month:Month, Month@row, [Project Name]:[Project Name], [Project Name]@row),1)
Is this what you need?
Kelly
Answers

Hey @NuGenAdmin
I'm not sure I understand what you're trying to achieve. Try this to see if the guess was correct.
I purposely left off the IFERROR until the formula is working correctly as it will mask any error the formula generates.
=INDEX(COLLECT([Also Energy Production]:[Also Energy Production], Year:Year, [Previous Year]@row, Month:Month, Month@row, [Project Name]:[Project Name], [Project Name]@row),1)
Is this what you need?
Kelly

@Kelly Moore Thats it!!! Thank you so much!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 200 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!