Forum Discussion
I need help with, #Spill error: spill range isn't blank
Is there a way to bypass this error? I would like to manually update one of the cells within the spill formula as the data is incorrect but when I do so the entire spill function "breaks". I tried...
You can't manually edit elements of the array, that's one object. But you may apply formula to the array which could change some elements based on applied logic. Like
=LET(type, [@Stock].[Instrument type], IFERROR( IF(type="ETF","REIT",type), ""))in second column here