Sign in to join the conversation:
Within a sheet (call it "A") I used a formula referencing a different sheet (let's call it X).
Later I deleted sheet "A". However I see an annoying "Used in formula from unknown sheet" in sheet X. Is there any way I can clear these out?
Please help.
Currently, you need to:
undelete the sheet
remove all formula references (I just delete all rows)*
add content to sheet that requires a save.
wait two hours
check if the <unknown sheet> reference is gone
then delete the sheet again.
Developers are working on a better fix, so I am told.
Craig
*kind of defeats the point of having the sheet recoverable for 30 days but ... I hope we won't need to do it this way for very much longer.
Thanks. I cannot delete the row.
Is there a way I can 'delete the reference' to a cell just like 'remove link'. I couldn't find that. Remove link works well but I can't seem to find delete reference.
Im doing cumulative formula and the cells will not format properly. Tried moving the info to a new sheet but still wont format. Help! IF([Column 26]72 = 0, "", VALUE([Column 26]72) + VALUE([9]@row ))
Need some help with a formula that doesn't seem to be working. For context, here is a description of the sheet setup and formulas I'm using (+ I've attached an image with screenshots of all the pieces as a visual aid). The sheet I'm working on is our RAID log template that we have built into our control center solution. We…
I'm using the move row action to automate archiving. The flow works fine, however when the rows get added to the new sheet, the are added to the same row number e.g. row 100. So my archive sheet now has 99 blank rows before the archived items are added. Is there a way to fix this? Screen shot of my automation below. I also…
