I need a workaround to get totals from by registry - I hit the Smartsheet 25000 cell formula limit apparently.
I thought I could add virtual columns to my table to get all the totals so I started with just the total count:
=COUNT(LIST(Medical Needs Program Registry COMPLETED NORTH[Last Name]))
However, itโs counting each row not giving me the total of the entire table.
I was hoping to have a separate table to collect all totals from all 4 registry tables but the count expression wouldnโt locate other tables.
Is this even possible?
These are all the totals I need to get - just not sure how to accomplish in Appsheet:
COUNT[Last Name] COUNT[Caregiver First Name] COUNTIF[O2 over 5 lpm]=1 COUNTIF[O2 under 5 lpm]=1 COUNTIF[Vent],[Pump],[Suction],[Electric Wheelchair],[Hoyer]=1 COUNT[Other Elec Need] SUM[# dogs]+[# cats] SUM[# persons evacuating] COUNTIF[Service Animal]=1 COUNTIF[Age <=17] COUNTIF[Age >=65]
"However, itโs counting each row not giving me the total of the entire table. " - here, what do you mean by โthe total of the entire tableโ?. Are you looking for the sum of the values?
Yes, i want the sum of the column.
Instead it gave me a sum per row
User | Count |
---|---|
46 | |
29 | |
24 | |
22 | |
13 |