How to add a date criteria to the column to avoid forms adding below the formula line?

McPhersonTim

Andrée Starå

Hi @McPhersonTim

I hope you're well and safe!

Try deleting the empty rows between Thursday-Friday and test it again.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

McPhersonTim

I do delete the rows, but i want to prepopulate those cells as a range for my Averageif forumula.

Genevieve P.

Hi @McPhersonTim

Is there a reason that we can't reference the entire column?

=AVERAGEIF([Daily %]:[Daily %], <> 0)

If there's another criteria (for example previous rows you want to exclude) you could use AVG(COLLECT, for example:

=AVG(COLLECT[Daily %]:[Daily %], [Daily %]:[Daily %], <> 0, [Other Column]:[Other Column], <> "Criteria"))

Let me know if that makes sense!

Cheers,

Genevieve

McPhersonTim

I would love to reference the entire column and then only collect data for certain date ranges. I just can't seem to figure it out : D

Genevieve P.

Hey @McPhersonTim

Awesome! We can definitely help you build that out, but we'd need to know more - what date ranges are you looking for exactly? Can you explain your full scenario / end-goal, and are those dates in a Date type of column?

Did you try the AVG(COLLECT formula above?