This functionality is available for "Row" reports, but "Summary" reports really should be included. Many clients use sheet summary to keep grids clean and lean; but, if we can't leverage dynamic scopi…
I'm in process of making updates to templates for a control center blueprint, and it would be easier for me to make a copy of the existing template set, make the changes there, and update the blueprin…
I'm trying to use Zapier to input formulas into a Text/Number column (which does support formulas) and it comes over as a text string: '=INDEX(PARENT(), 1) I'm using Control Center which creates new r…
I've created the following cross sheet CountIfs formula: =COUNTIFS({Hutto NA Status}, "Done", {Hutto NA Owner}, [Primary Column]15, {Hutto NA Date}, >TODAY(-7)) Each segment works perfectly on its own…
I need to create a cross-sheet formula that counts the number of entries for a month and if there is text in another column. I've come up with the formula below, but I get an Incorrect Argument error:…