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.
I've got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…
