Referencing other sheets

CherylAK ✭✭✭✭
edited 12/09/19 in Smartsheet Basics


I have a sheet where I want to add totals in 7 other sheets for January - December for several drugs.

When I get to February, it tells me I am at the max for references.  I think it was 15.

We have 7 squads...each squad seizes many drugs per month.  I am trying to get the grand total of the drugs for all 7 squads for each month.  I had a listing of drugs and then tried to add the squad totals to that.

Is there an easier way to do this?