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?