What's wrong with this formula please?
Trying to write a formula that pulls the current week's data into a "current data" column so I can point a dashboard metric at one column/cell. My shorter formula works correctly but when I add new columns & change column names it breaks. I've confirmed column names match 11. Any thoughts?
Short formula (works):
=IF(NOT(ISBLANK(Dec@row)), Dec@row, IF(NOT(ISBLANK(Nov@row)), Nov@row, IF(NOT(ISBLANK(Oct@row)), Oct@row, IF(NOT(ISBLANK(Sep@row)), Sep@row, IF(NOT(ISBLANK(Aug@row)), Aug@row, IF(NOT(ISBLANK(July@row)), July@row, IF(NOT(ISBLANK(June@row)), June@row, IF(NOT(ISBLANK(May@row)), May@row, IF(NOT(ISBLANK(April@row)), April@row, IF(NOT(ISBLANK(March@row)), March@row, IF(NOT(ISBLANK(February@row)), February@row, IF(NOT(ISBLANK(January@row)), January@row, ""))))))))))))
New formula (not working):
=IF(NOT(ISBLANK([Jun 28]@row)), [Jun 28]@row, IF(NOT(ISBLANK([May 26Jun 1]@row)), [May 26Jun 1]@row, IF(NOT(ISBLANK([May 1925]@row)), [May 1925]@row, IF(NOT(ISBLANK([May 1218]@row)), [May 1218]@row, IF(NOT(ISBLANK([May 511]@row)), [May 511]@row, IF(NOT(ISBLANK([Apr 28May 4]@row)), [Apr 28May 4]@row, IF(NOT(ISBLANK([Apr 2127]@row)), [Apr 2127]@row, IF(NOT(ISBLANK([Apr 1420]@row)), [Apr 1420]@row, IF(NOT(ISBLANK([Apr 713]@row)), [Apr 713]@row, IF(NOT(ISBLANK([Mar 31Apr 6]@row)), [Mar 31Apr 6]@row, IF(NOT(ISBLANK([March 2430]@row)), [March 2430]@row, IF(NOT(ISBLANK([Mar 1723]@row)), [Mar 1723]@row, IF(NOT(ISBLANK([Mar 1016]@row)), [Mar 1016]@row, IF(NOT(ISBLANK([Mar 39]@row)),[Mar 39]@row, IF(NOT(ISBLANK([Feb 25Mar 2]@row)),[Feb 25Mar 2]@row, IF(NOT(ISBLANK([Feb 1824]@row)), [Feb 1824]@row, IF(NOT(ISBLANK([Feb 1117]@row)), [Feb 1117]@row, IF(NOT(ISBLANK([Feb 410]@row)), [Feb 410]@row, ""))))))))))))))))))
Answers

Are you able to provide a screenshot of the formula open in the sheet as if you are about to edit it?
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.8K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 56 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!