How to add a date criteria to the column to avoid forms adding below the formula line?
Answers
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I do delete the rows, but i want to prepopulate those cells as a range for my Averageif forumula.
-
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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
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
-
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?
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!