I'm having problems using the COUNTIF function in the new-ish sheet summary. Everytime I sort rows it changes the range. For example, in a summary text field I have =COUNTIF([Column A]1:[Column A]79, …
Has anyone come across a way to update the criterial for multiple reports at once? We have several reports that all draw from the same set of sheets. Every time we start a new project (and thus create…