i protect my worksgheets when i add formulas before i give to the other staff
i add 100 blank rows to my tables to allow them to add data without VBA
when i add the formulas i get rows of NA instead of blank
please help me fix the formulas:
=XLOOKUP([@[CLIENT NAME]],brokers_cm[Participant],brokers_cm[tabs id],"NA") what do i do when client is blank
=[@[ LATEST SAP DATE]]+180 - how do i compute only when sap date is not blank
same for =DATEDIF([@[ LATEST SAP DATE]],TODAY(),"m") sap date is blank
same here =XLOOKUP([@[Tabs ID]],brokers_cm[tabs id],brokers_cm[Broker Name],"NA")
somehow i keep making errors when rows are blank
i add 100 blank rows to my tables to allow them to add data without VBA
when i add the formulas i get rows of NA instead of blank
please help me fix the formulas:
=XLOOKUP([@[CLIENT NAME]],brokers_cm[Participant],brokers_cm[tabs id],"NA") what do i do when client is blank
=[@[ LATEST SAP DATE]]+180 - how do i compute only when sap date is not blank
same for =DATEDIF([@[ LATEST SAP DATE]],TODAY(),"m") sap date is blank
same here =XLOOKUP([@[Tabs ID]],brokers_cm[tabs id],brokers_cm[Broker Name],"NA")
somehow i keep making errors when rows are blank