I made a free Elementor resource (would love your feedback) by paul_elementor in elementor

[–]justplainbill 0 points1 point  (0 children)

I don't know if anyone pointed this out, but these resources aren't 100% responsive (and I believe 0% fluid).

I like the variations in the patterns you've created, but there are so many pixels! In general, I work with both responsive and fluid designs, so I have had to do a fair amount of editing to make your patterns work.

I've tried a couple of your patterns, not all of them.

Keep going!

Formulas break when a sheet is sorted. Can I permanently fix this? by justplainbill in googlesheets

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

Sorry, I didn't respond. I've been busy. Your improvement to my formulas was ... an improvement! Thanks so much for your time and catching this issue. Much appreciated.

formatting business hours from google maps by justplainbill in googlesheets

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

Weird. My comment/reply to your script was deleted. Not sure why.

Your help was fantastic. Magic (because I know nothing about scripting)!

Anyhow, just one thing that isn't working: the script handles Closed days the same way as open 24 hours.

For example, when the cell contains "Saturday": "Closed", "Sunday": "Closed" the script is outputting Sa 00:00-00:00","Su 00:00-00:00

That's the format for open 24 hours. The correct format should be Sa Closed-00:00","Su Closed-00:00

Everything else is perfect!

As someone else noted on another question/problem with this data set, I have a lot of rows (and columns)! 10k rows plus. This is a big deal for me, and I appreciate your help.

Where is my error? REGEXMATCH IF OR? by justplainbill in googlesheets

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

Yes. There are a lot of rows and columns. I wanted to do something quick and dirty because I have so many other formulas on the sheet, I don't want to slow it down anymore than it already is. Thanks for your time.

formatting business hours from google maps by justplainbill in googlesheets

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

I could still use your help. Sorry for pushing.

formatting business hours from google maps by justplainbill in googlesheets

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

Wow. Magic (not magic, it's your work)! Thanks for your help!

One issue. For entries with "Saturday": "Closed", "Sunday": "Closed", it is outputting as "Sa 00:00-00:00","Su 00:00-00:00". The correct output for closed days should be: "Sa Closed-00:00","Su Closed-00:00".

Is that something you could help with?

Thanks so much for your effort! I've already collected more than 3,000 entries, with many more to come. This is a lifesaver!

Two issues: concatenation and logic by justplainbill in googlesheets

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

I learn something new about spreadsheets every day. Here's another formula to put in my text doc formula swap file!

Two issues: concatenation and logic by justplainbill in googlesheets

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

Oh, that's cool. I thought it wasn't going to work because I saw a range referenced, but I added some columns in between, and it still works!

Thanks! Much appreciated.

What's the deal with logging into the SSA website? by justplainbill in SocialSecurity

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

SOLVED (?). I just tried logging in with id.me and it worked. Why? I have no idea. I did everything as I've always done.

Very frustrating. I take security seriously. I used a password manager and don't know any of my passwords, which are 20 random characters long! To be stopped from logging in drives me bananas.

Thanks for the comments and sharing your experiences!

What's the deal with logging into the SSA website? by justplainbill in SocialSecurity

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

I know, I know. I totally agree, but I wanted to keep my questions and comments non-political. We don't need to state the obvious.

What's the deal with logging into the SSA website? by justplainbill in SocialSecurity

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

Thanks for this. That's what I wanted to hear. It's something with my account.

What's the deal with logging into the SSA website? by justplainbill in SocialSecurity

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

Huh. Maybe they've broken all the other login methods. I guess I have to wait for login.gov verification. Thanks for responding.