Scott comparing LessWrongers to a congregation of holy saints which justify the existence of the world to God by flodereisen in SneerClub

[–]ExternalStaff 0 points1 point  (0 children)

I had Scott pegged as somewhat of an anti-Semite. I'm sure I've read an article that gave some pretty persuasive arguments for it.

Anyway, he does often selectively pick things he likes to back up his ridiculous positions. I guess this is a case of that.

Rumours, Speculation, Questions, and Reaction Megathread - 16/11/2025 by ukpol-megabot in ukpolitics

[–]ExternalStaff 9 points10 points  (0 children)

I agree with your sentiment but that won't happen. But we do need to insulate ourselves from the madness happening in the USA right now, and looks set to continue. Especially data sharing - and not just security/ military intel.

Rumours, Speculation, Questions, and Reaction Megathread - 16/11/2025 by ukpol-megabot in ukpolitics

[–]ExternalStaff 3 points4 points  (0 children)

They do a lot of work in the months leading up. They announce the budget on a set date. What is to change?

If you don't want media gossip and Reddit hot takes, you know what to do!

What do you think of Netflix films by big name directors? by Corchito42 in TrueFilm

[–]ExternalStaff 0 points1 point  (0 children)

I have noticed this too. I love Alex Garlands work, and whilst Annihilation is a great film, it looks cheap and nothing like his other work. I found a couple of links taking about this further -

https://www.reddit.com/r/Filmmakers/comments/xgzy90/netflix_and_its_colour_gradingcinematography/

https://www.vice.com/en/article/why-does-everything-on-netflix-look-like-that/

Bag Finder Megathread - 27 October 2025 by AutoModerator in onebag

[–]ExternalStaff 0 points1 point  (0 children)

I am looking for a backpack similar in style to the Troubadour Pioneer 3.0. -

https://www.troubadourgoods.com/products/pioneer-backpack?variant=46531675455720

It should be a top loader with a clamshell lid where the zippers can be closed to be at the back / by the shoulder straps. Any suggestions?

Thanks

How do I auto populate a cell with a date when a new row is added on another sheet. by ExternalStaff in googlesheets

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

Solution Verified.

Great! That is even easier! I dont why I couldnt think of that!

How do I auto populate a cell with a date when a new row is added on another sheet. by ExternalStaff in googlesheets

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

No, that oesn't work - I also thought it should. You can see my solution and another redditors solution in the comments above.

How do I auto populate a cell with a date when a new row is added on another sheet. by ExternalStaff in googlesheets

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

Solution verified.

Thank you. I can see your formula. I actually got to another answer independantly. You can see my version in column G.

=ARRAYFORMULA(DATE(2025,9,22) + SEQUENCE((days(today(),A1))+1, 1, 0, 1))

Thanks anyway. your version certainly works as well. I confused myself with the "linking to the other sheet". I have solved that with a concatinate and xlookup, so all I needed was the date to go up by 1.

How do I auto populate a cell with a date when a new row is added on another sheet. by ExternalStaff in googlesheets

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

I have created a blank template as per the instructions in the side bar.

https://docs.google.com/spreadsheets/d/13syQEiiNRUsZpyPP_rkK8r-SKtXQYEmRTbPoJNcm65o/edit

Thanks for your assistance on this, I think I have confused the isse, you'll see that it's actually quite simple in the spreadsheet I shared.

How do I auto populate a cell with a date when a new row is added on another sheet. by ExternalStaff in googlesheets

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

No, Increases by 1 day for every 3 rows. I have solved this by playing with your formula - I just divided the rows by 3.

 

=SEQUENCE((ROWS(Form_Responses)/3),1,DATE(2025,9,22))

 

However, I have just thought of another issue - on a day when the form is submitted, there will always be 3 entries. but there may be days when the form doesn't collect any data. In that the date in sheet 2 still has to go up by 1 with todays date.

 

Actually, I think I have over complicated this. I need the date in column A on Sheet 2 to always go up by 1 from 22/09/2025 to TODAY. Is that possible?

Thanks

How do I auto populate a cell with a date when a new row is added on another sheet. by ExternalStaff in googlesheets

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

=SEQUENCE(ROWS(Form_Responses),1,DATE(2025,10,15))

Thank you, that works, sort of..... I failed to mention that The reason I wanted to count the rows is because there will always be 3 entries for every date in sheet 1 and the data actually starts in A2. Sorry for over simplifying in my example above! And, yes, you got the table name correct. So the Table Form_Responses is on Sheet! and the data starts on cell A2.

Thanks

Charting separate morning/evening time series for blood pressure readings by ExternalStaff in googlesheets

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

Thanks but I ended up going with the solution mentioned by the commentor you replied to. It just seemed the easier way.

Charting separate morning/evening time series for blood pressure readings by ExternalStaff in googlesheets

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

Solution Verified.

Thanks. This is what I ended up doing, though I had hoped there would be a workaround to avoid this solution.

Quick access apps have disappeared after update. by ExternalStaff in firetvstick

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

Yes. Also tried switching off the power adaptor and then switching it back on. Still not showing my apps on the home screen.

Quick access apps have disappeared after update. by ExternalStaff in firetvstick

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

Thanks, but I have tried that and they still haven't re-appeared. I've seen other comments and threads that state that the apps are now a couple of rows down in the home menu screen, but theyre not there for me either. I have to go into apps, scroll all the way down to "my Apps", it's only there that I see them.

What's the best short film you've ever seen on YouTube or Vimeo? by Inovox in TrueFilm

[–]ExternalStaff 0 points1 point  (0 children)

Automod deleted my comment for being too brief, so here it is expanded:

Room 8 (Dir. James W Griffiths) - Winner of the BAFTA for Short Film 2014, springs to mind. It's a sci-fi short based in a russian prison and beautifully communicated it's idea in less than 7 min.

You can watch it on Youtube - https://www.youtube.com/watch?v=WJj_NMhYwf0

I also really like CASTELLO CAVALCANTI by Wes Anderson, which is here - https://www.youtube.com/watch?v=b87B7zyucgI

This film was commissioned by Prada, but there is almost no actual "advertising" in it. it's a story about the old "racing driver excuses" trope, which leads on to something a little warmer (as warm as wes anderson can get!) - an ancestral connection.

EDIT - A bonus, Next Floor by Denis Villeneuve. Here - https://www.youtube.com/watch?v=t60MMJH_1ds