Google Sheets: How to delete rows with #REF! error while referencing other rows from a different sheet

[RicardoRincon]

I think the solution must be simple. So I have two sheets, one with data that is added every time a new order is made, Column A is the Brand Name and column B is the Order Name for that brand. In the second sheet I reference Column A and B of the first sheet to have the exact same data, brand name and order name, the other columns in the second sheet are other calculations that I make for the specific Order, but I think that's irrelevant for my problem. My problem is that when data is eliminated in either columns A or B or an entire row is eliminated in the first sheet, I get a #REF! error in the relevant row of the second sheet and the reference formula of the entire column skips this row with the #REF! error. So the optimal scenario would be for the entire row that gives #REF! error to be eliminated and to prevent it from being skipped from the reference formula to the other sheet. I hope this makes sense, I will attach both sheets to have a better understanding.

When I eliminate highlighted row...

 

[RasGhul]

OMG IT WORKED!!! Now columns A and B don't give me errors when deleting rows in the first sheet. But sadly columns C, D and E do give the same REF error. I mean I guess we need to do the same for them? Column C gives the date for when someone marks a check, Column D does the same, And E substracts the dates to have a duration, simple. But I don't know how to integrate your formula on them ?.

Formula column C:
View attachment 56781

Formula column D:
View attachment 56782

Formula column E:
View attachment 56784

YOU HAVE BEEN A LIFE SAVER RashGul

Maybe try for Cadena C & D column check marks

=if(CadenaC4<>"",If(C2="",NOW(),C2,"")