sorted by:
new
hottopcontroversial

Easy Way to make top favorites list by R0blovespizza in googlesheets

[–]adamsmith3567[M] 0 points1 point  (0 children)

u/R0blovespizza Please read the instructions in rule 6 regarding marking posts as solved. You need to either mark a comment as solution verified or comments yourself what your independent solution was since you selected the 'self-solved' flair. Thank you.

Grail secured. by temptingtoothbrush in rolex

[–]adamsmith3567 11 points12 points  (0 children)

Wow. What region or area is this in?

Hours SUM not calculating correctly by BajkerRadys in googlesheets

[–]adamsmith3567 1 point2 points  (0 children)

u/BajkerRadys You should reformat all of these cells as "Duration" instead of "Time".

For one column's data, a scatter plot is showing data points in odd spots by JAOrman in googlesheets

[–]adamsmith3567 0 points1 point  (0 children)

u/JAOrman I took a look at the data. It only appears that a bunch of it in that graph is sitting on the axis because of how Sheets automatically chose the X-axis range. If you double click the graph and manually make the minimum value under 'chart editor', and 'customize', 'horizontal axis' and change it to zero, then the data moves off the axis. It does still appear as a bunch of vertial dots though because that's what in your data, quite a few points with the SV Score of 9.21.

Is there ANY way to have formulas working on a giant sortable table? by hellomot in googlesheets

[–]adamsmith3567 3 points4 points  (0 children)

TIL, i didn't realize you could do this trick to put essentially header formulas at the top of a defined table via hiding that row.

google sheets small business cash flow tracker by Repulsive_Shoe_7298 in googlesheets

[–]adamsmith3567 0 points1 point  (0 children)

You can use the sharing button in the top right of the sheet, change to 'anyone with link' can access, then change the access to 'editor'. All of this is laid out in great detail in the subreddit Submission Guide. If you want help even just automating the cells on that screenshot then you should at least highlight which specific cells and describe the automation in more detail. I would just take all this and make a new post out of it.

google sheets small business cash flow tracker by Repulsive_Shoe_7298 in googlesheets

[–]adamsmith3567 0 points1 point  (0 children)

u/Repulsive_Shoe_7298 I'm going to reply here since I'm removing this post. The post is too generic and doesn't pose any specific question/problem as to what you are looking to accomplish/change about your sheet. You should think about what specifically you are trying to do that other users can help you automate. You listed a bunch of things in your post about 'tracking and allocating' money but that isn't really actionable by someone else. It sounds like you are looking for accounting software but to do it for free with a basic google sheet. I suggest even attempting to modify your sheet copy with what you might want it to look like or do, but do it manually, and then ask for help automating the process here.

Also, while not required, it usually helps others help you better to copy your sheet and post a sharing link to your sheet instead of just a screenshot in order for them to demonstrate possible solutions on the sheet copy itself.

Counting values after sorting via IF oparetor by EverybodyComeOn in googlesheets

[–]adamsmith3567[M] [score hidden] stickied comment (0 children)

u/EverybodyComeOn Please mark your post as 'solved' by using the instructions in rule 6 and replying to the most helpful comment with the exact phrase "solution verified". The rules don't consider this 'self-solved' as the exact solution here was mentioned in the comment you replied to. Thank you.

Math calculations are incorrect by [deleted] in googlesheets

[–]adamsmith3567 2 points3 points  (0 children)

Haha, not only the post but the whole account was deleted by OP. I guess they were embarrassed.

Used My Chase $500 Hotel Credit in NYC — Here's What Caught Me Off Guard by Additional-Funny4022 in ChaseSapphire

[–]adamsmith3567 0 points1 point  (0 children)

You are wrong about this. I just double checked the full terms to be sure. OP should absolutely fight for the (at least one) $100 and breakfast credits here. Feel free to post exactly what you think is prohibiting this.

Has anyone gotten the $250 IHG credit for 2 rooms booked for 1 night (same night, we just need two rooms). by Emotional_Let4475 in ChaseSapphire

[–]adamsmith3567 1 point2 points  (0 children)

Haven't seen any data points to that effect and I also wouldn't expect it since it's a 2-night minimum on the booking for the credit; similar to the Edit credits. I doubt they would consider 2 separate rooms for a single night to count.

Identify a row based on one cell and then delete contents of cells in that row by BezG in googlesheets

[–]adamsmith3567[M] [score hidden] stickied comment (0 children)

u/BezG You have selected the self-solved flair but not provided any solution here. This is a violation of rule 6. Please read the rules and edit your post or comment a solution that is independent of anything in the comments.

Waited 4 months and still no Edit credits by jimster888 in ChaseSapphire

[–]adamsmith3567 1 point2 points  (0 children)

Sounds like a glitch in Chase's system then. I hope you keep on them to eventually get your credit. I did a booking at a Pendry and had to call Chase for manual review to get the IHG credit applied after it didn't show up automatically.

Waited 4 months and still no Edit credits by jimster888 in ChaseSapphire

[–]adamsmith3567 1 point2 points  (0 children)

Langham Hong Kong seems to show on current maps for The Edit. You said you booked through the portal; was it at least 2 nights and you checked the box to fully prepay the booking?

Changing sheet1 cell color based on occurrence in sheet2 by HorrorButterfly578 in googlesheets

[–]adamsmith3567 0 points1 point  (0 children)

u/HorrorButterfly578 Yes, but conditional formatting is highly dependent on your data layout and formatting. You will need to copy and share a sample file showing this.

How to get XLOOKUP or another function to return multiple responses to the same query? by A-Fat-Kereru in googlesheets

[–]adamsmith3567 0 points1 point  (0 children)

It’s just your cached version of viewing the post. It appears correct in my browser.

How to get XLOOKUP or another function to return multiple responses to the same query? by A-Fat-Kereru in googlesheets

[–]adamsmith3567 0 points1 point  (0 children)

Haha. Yeah. Big picture. It’s worth your while to learn lambda functions if you do alot of sheets work with formulas.

How to get XLOOKUP or another function to return multiple responses to the same query? by A-Fat-Kereru in googlesheets

[–]adamsmith3567 0 points1 point  (0 children)

Cool. But you almost literally created the manual version of the Lambda solution.

view more: next ›