help

Please help

Please help ✭✭✭

01/23/23 in Formulas and Functions

create an average of how many "Yes" there are when the columns where yes are are every other column and not all next to eachother. (there are 12 months of yes)

0 ·

Answers

Paul Newcome Community Champion

01/24/23

Are you able to provide some screenshots for clarification?

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Formula to check a box if a PARTIAL string is present in a specific cell in a descendant row.
Hey Folks! I have a working formula to check a box in a parent row if a condition is met in a descendent row. In this case, if the row "Type" is "Action Item". This is working and the formula is as follows: =IF(COUNTIFS(DESCENDANTS(Type@row ), "Action Item") > 0, 1, 0) This works well because the cell type is a drop down…
Creating a tailored drop down list in a column based on the value in another column.
Example - Risk Log. I want to be able to create dynamic filtering of a dropdown column "Sub-Category" based on the value selected in the Name/Number "Category" column. I've seen this done in Excel using the combination of: Excel Functions: INDIRECT() – to reference a named range dynamically SUBSTITUTE() – (if needed) to…
Index Match with a multi-select dropdown
I am trying to write a formula that looks at a multi-select column to pull email addresses from a reference sheet. With my current formula it only works when there is one value in the multi-select column. =JOIN(COLLECT({Reference Sheet | Contact Q2}, {Reference Sheet | BID}, HAS(@cell , [Sites to be included]@row )), "/")…