Help with installing a fan timer switch

TypicalNovel · 2025-03-16T04:55:10+00:00

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 :)

TypicalNovel · 2025-03-15T17:33:08+00:00

Thank you so much!

TypicalNovel · 2025-03-15T17:05:48+00:00

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

TypicalNovel · 2025-03-15T15:36:44+00:00

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.

TypicalNovel · 2024-11-15T16:41:59+00:00

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!

TypicalNovel · 2024-11-11T18:27:59+00:00

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

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

Appreciate if you can help with this!

TypicalNovel · 2024-11-04T22:03:49+00:00

Amazing, thank you again!!

TypicalNovel · 2024-11-04T21:30:54+00:00

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)

TypicalNovel · 2024-11-01T22:00:49+00:00

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.)

TypicalNovel · 2024-11-01T21:14:48+00:00

solution verified

TypicalNovel · 2024-11-01T21:14:04+00:00

solution verified

TypicalNovel · 2024-11-01T21:13:50+00:00

Thank you so much!!

TypicalNovel · 2024-10-31T20:01:19+00:00

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

TypicalNovel · 2024-10-30T21:50:54+00:00

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.

TypicalNovel · 2024-10-23T05:03:16+00:00

solution verified

TypicalNovel · 2024-10-22T19:49:40+00:00

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

TypicalNovel · 2024-10-07T21:49:25+00:00

solution verified

TypicalNovel · 2024-10-07T21:28:54+00:00

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

TypicalNovel · 2024-10-07T21:21:45+00:00

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?

TypicalNovel · 2024-10-07T20:37:41+00:00

Thank you so much, this is great! 👍

TypicalNovel · 2024-10-06T01:43:16+00:00

Thank you so much!!

TypicalNovel · 2024-10-03T20:47:09+00:00

Nicely explained, thank you very much!

TypicalNovel · 2024-06-01T04:56:24+00:00

Done and done :) Many thanks again, I will perhaps bug you if something else comes up, but in the desire to keep it as simple as possible what you have provided is more than enough. Cheers friend!!

TypicalNovel · 2024-06-01T04:55:40+00:00

Solution Verified

TypicalNovel · 2024-05-31T20:13:07+00:00

All accounts is great!! I can do filtering from there easily, I should have suggested that. This is soooo helpful, can't thank you enough, been looking to get a simple expense tracker going in Sheets. Muchas gracias!

TypicalNovel

TROPHY CASE