Trending in Formulas and Functions
-
Divide by Zero Error With AVG(COLLECT(...
Hoping someone can help because I am totally twisted with this one. I don't use AVG(COLLECT very often so I may be missing something simple here… What I'm trying to do is take the average of Column17 where both the year (Column22) and the weekday (Column9) match the year and weekday that I've indicated in Column21. (Yes I…
-
Formula to Check Restricted items in a Multi List Drop Down
I have a field "Failure Summary" in a sheet that has a drop down list that allows multiple selections. I want to write a formula that will check mark those specific items in the drop down list, if a corresponding column@row has "NO" as the value in that field. Is it possible to write a formula to do this?
-
How to automatically update text every week?
Hello, So I have two columns: "Date Week Ending" that lists the last Saturday of each week and "Reference" that lists an X value. I want to have the X value appear for the PREVIOUS week ending date when my current week starts. For example, if today is 9/9 then I want the "X" value to appear for the week ending date of 9/7.…