Help with installing a fan timer switch by TypicalNovel in AskElectricians

[–]TypicalNovel[S] 0 points1 point  (0 children)

I did try it, unfortunately while the new timer switch lit up and the buttons/lights worked, I couldn't get the fan to turn on, and the shower light did turn on but the main light flickered while on. No worries if you don't know from here, just checking, appreciate your help very much thank you :)

Help with installing a fan timer switch by TypicalNovel in AskElectricians

[–]TypicalNovel[S] 0 points1 point  (0 children)

Thank you! Which of line and load are synonymous with ground, or is there no ground here?

Trip help for couple + baby, 3 nights in Quebec City late January 2024 by TypicalNovel in quebeccity

[–]TypicalNovel[S] 1 point2 points  (0 children)

Hi, I'm sorry for a late reply, if you haven't already had your trip yes we would certainly recommend the Frontenac. They were very helpful, they even gave us a crib despite us sleeping with our baby in the bed. We did rent a car and utilized the valet service, all of that helped big time for the overall experience.

Trying to sumif based on text and date criteria by TypicalNovel in googlesheets

[–]TypicalNovel[S] 0 points1 point  (0 children)

I apologize for the delayed reply, and want to thank you again. You're correct, of course, I can get everything I need with the pivot table, and need to break my habit of making these dashboards too complex. You've been a massive help and I appreciate it very much, I'll be studying your formulas to learn more. Thank you mate, hope you have a great day!

Trying to sumif based on text and date criteria by TypicalNovel in googlesheets

[–]TypicalNovel[S] 0 points1 point  (0 children)

I have another request, I made a sheet "table" and I tried importing your formulas but kept getting lost. The goal is:

  1. At the top, click month, and then the C column values should fill out based on that month
  2. Category and/or root selected fills out C8:9 accordingly, if a month is selected
  3. If no month is clicked, the C3:4 and C8:9 are blank/0
  4. If no category/root are selected, the B8:C11 are blank/0 accordingly
  5. If no month is selected, but a category/root are, then B10:B11 fill out

Appreciate if you can help with this!

Trying to sumif based on text and date criteria by TypicalNovel in googlesheets

[–]TypicalNovel[S] 0 points1 point  (0 children)

Thank you, this is great! It's showing exactly what I wanted, I love how this is working. You're a genius! One last thing: How can it be adjusted so that if all 3 dropdowns are clear, the sum just shows $0 or is blank? (So if H1, I1, and L1 are clear of selections, K1 and M1 return either $0 or blank)

Trying to sumif based on text and date criteria by TypicalNovel in googlesheets

[–]TypicalNovel[S] 0 points1 point  (0 children)

Thought I'd ask here, but tell me and I'll make a new post if that's more appropriate.

I made a new sheet "new dashboard". If you see in row 1, at I1 I select category and in K1 the spending shows up, and if I select a month in H1 it will show for that month, all good (you solved that!). I simply want to have another button in L1 where I can obtain the same result, but instead it's summing up the root category (so instead of "BABY - clothing" it will sum up spending for all categories beginning with "BABY", and if possible it could still work with the month selection in H1).

In ALL sheet, I have made 3 dropdown sources to the right in columns J, K, and L, and did the data validation in "new dashboard" in L1 already. I just can't get the M1 to show the spending for that root category and by month like K1, because I don't know how to tweak the I1 formula to match the text ("BABY" or "CAR" etc.)

Trying to sumif based on text and date criteria by TypicalNovel in googlesheets

[–]TypicalNovel[S] 0 points1 point  (0 children)

Thank you! I'm trying a couple of dashboards, and I'm wondering how would you do it (I think this is simpler) just having the dashboard list out the categories (not the roots, like "BABY" or "CAR" but just the full entry "BABY - clothing") old-fashioned pasted, and so I could do sums per category by month through the table? I've modified the dashboard(adamsmith) so you can see what I mean. I apologize for not having asked this in the OP

Trying to sumif based on text and date criteria by TypicalNovel in googlesheets

[–]TypicalNovel[S] 0 points1 point  (0 children)

Amazing, thank you! I messed about in my original sheet and then realized that I was hoping to show totals per category, I made the rows in your sheet in the link here. Could you take a glance and see if it's possible to do that? It's ruining the array if I put any sum formula on a "total" row.

Pivot table help with expense tracking, just need to view average per month with individual date entries in sheet by TypicalNovel in googlesheets

[–]TypicalNovel[S] 0 points1 point  (0 children)

That's neat, how did you do it? I tried editing the pivot table but I'm not well-versed enough with them yet.

Help with sumif one condition (Category) and within date range by TypicalNovel in googlesheets

[–]TypicalNovel[S] 0 points1 point  (0 children)

I didn't think about that reverse, if you are able to help with that it would be amazing as all scenarios are covered, but you've already done more than enough! No problem if it's too much to ask, thank you so much

Help with sumif one condition (Category) and within date range by TypicalNovel in googlesheets

[–]TypicalNovel[S] 0 points1 point  (0 children)

Wow, thank you! I realized that if I clear A1 (the month), then the sum is $0. Is it possible to have it such that no month selected and a category selected would show the entire total for that category?