I need a workaround to get totals from by reg...

expressions
(Tammi Canelli) #1

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?

(Tammi Canelli) #2

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]

(Deep Foundations) #3

"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?

(Tammi Canelli) #4

Yes, i want the sum of the column.

Instead it gave me a sum per row