Timeline for Totally confused by my arrayformula(IF+FILTER+IF) function
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 16, 2017 at 10:58 | comment | added | TheMaster |
Great. To show weekend, it might require WEEKDAY function. If weekday(date) = 7 or 1, then do this.
|
|
| Sep 16, 2017 at 10:52 | comment | added | Michael Kim | i actually solved this problem by using FILTER, and frankly I don't know why it works. lol here's my final work. Now I'm trying to figure out how can i make some data show 'weekend'. docs.google.com/spreadsheets/d/… | |
| Sep 16, 2017 at 10:44 | comment | added | TheMaster | Will all the rows above the blank rows be filled always? I mean, Would the first blank only start at the end? | |
| Sep 16, 2017 at 10:41 | comment | added | TheMaster | Wait.. I'll do a counta on this formula | |
| Sep 16, 2017 at 10:37 | vote | accept | Michael Kim | ||
| Sep 16, 2017 at 10:37 | vote | accept | Michael Kim | ||
| Sep 16, 2017 at 10:37 | |||||
| Sep 16, 2017 at 10:34 | comment | added | Michael Kim | Oh wait. I just added 1 () at the early timevalue, and it works. However, now it is causing reference error because it's filling all the empty rows with "", which seems empty but not really. My scripted sheet is now automatically adding values far beyond the last row, like 600~700 rows away from my last one. That's pretty much why i put filter on my function. | |
| Sep 16, 2017 at 10:30 | comment | added | Michael Kim | thanks, but this function still shows wrong values. It says 'yes' for the data collected at 11PM. | |
| Sep 15, 2017 at 11:31 | history | answered | TheMaster | CC BY-SA 3.0 |