brianschmidt
brianschmidt
Reactions
-
Re: COUNTIF & COUNTIFS Formulas
I think you're close but that both need to be COUNTIFS formulas with all your ranges and criteria included. =COUNTIFS({Country or Territory Name}, Label7, {Request Type}, "Outside of the US"…1 · -
Re: Average IF Formula
I would probably opt for using an AVG(COLLECT formula instead. Try this: =AVG(COLLECT([Approved Budget]:[Approved Budget], [Completion Date]:[Completion Date], >DATE(2021, 1, 1), [Completion Date]…1 · -
Re: Only Show Row if Data is in Specific Columns in a Report
I think there are a couple of ways you could accomplish this. In the sheet, you could create a helper checkbox column with the following column formula: =IF(ISBLANK(JOIN([Leftmost Date Range Column]@…1 · -
Re: Can I make my Contact List column appear on a mapped PDF as just their name?
I would suggest creating an additional column that is formatted as "Text/Number" with the formula =Email@row This will pull just the name(s) out of the contact column. Then, you can use tha…1 · -
Re: Formula to assign a number based on criteria
I figured out a way to mark the first iteration of a batch (as opposed to marking 1, 2, 3, 4, etc.). First, I added a "Row ID" (aka Auto Number) column so that each row can be distinctly re…1 ·
