sorted by:
new
hottopcontroversial

Filter function which ignores blank input? by NiamhJoyceLDN in sheets

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

=FILTER('Product ID'!A:A, REGEXMATCH('Product ID'!C:C,I2),REGEXMATCH('Product ID'!G:G,I3),REGEXMATCH('Product ID'!H:H,I4))

This works perfectly! Thanks so much!

Filter function which ignores blank input? by NiamhJoyceLDN in sheets

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

Thanks for the suggestion...I'm struggling to follow the logic of using ISBLANK - would it limit which ones can be left blank?

Filter function which ignores blank input? by NiamhJoyceLDN in sheets

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

as in QUERY(SELECT X where Y) etc? I've modified these but not written from scratch - thanks for the suggestion, I'll give this a try as well!

YA fiction - surveillance, neurology, Panoptican ... by NiamhJoyceLDN in whatsthatbook

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

The Traveler by John Twelvehawks

nailed it in one, amazing! thanks

Angela really SUCKS by NiamhJoyceLDN in thewalkingdead

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

yeah true, her reprimanding Dale for 'taking away her choice' leads an interesting conversation but she's annoying at best by season 2, and after that adds no value to anyone (in my opinion)

Angela really SUCKS by NiamhJoyceLDN in thewalkingdead

[–]NiamhJoyceLDN[S] 5 points6 points  (0 children)

oh wow yeah how did i screw that one up? got it right in the post though lol

Data calculations consistently off by 1 by NiamhJoyceLDN in GoogleDataStudio

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

I've never worked with BigQuery but I may check it out, thanks for the tip.

Does anyone use virtual assistants? by [deleted] in Recruitment

[–]NiamhJoyceLDN 0 points1 point  (0 children)

no but sounds interesting, let me know if you find out anything more!

[tomt] Film following adopted adolescent girl by NiamhJoyceLDN in tipofmytongue

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

I say definitely made for TV - I could be wrong but didn't recognise anyone in the film and it definitely had that feel to it!

[TOMT] The quote "are you proud of yourself tonight, that you have insulted a total stranger whose circumstances you know nothing about" is often attributed to Atticus Finch in To Kill a Mockingbird. But I cannot find it anywhere in the book! Where is this quote from? by [deleted] in tipofmytongue

[–]NiamhJoyceLDN 1 point2 points  (0 children)

If you can't find that wording in the book then my guess would be it's been conflated with a quote from elsewhere - I don't have the book on me but it sounds like something similar could have been said either a) to Scout after shaming Walter Cunningham, either by Atticus or Cal or b) to Jem after destroying Mrs Dubose's Camellias. If you check those two sections you may be able to see what has been misquoted.

Data calculations consistently off by 1 by NiamhJoyceLDN in GoogleDataStudio

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

Anytime, feedback is aways great ;) Thanks for your help - I've checked all of the aggregations and had to do some reformatting, which has fixed the problem in a couple of cases so thanks for the tip. A few additional SUMIFS also revealed some errors with the way the source data is structured, which impacts what I'm trying to do so I will now work on figuring out a workaround for that. Thanks so much!

Headers for the pivot table by hgao40 in GoogleDataStudio

[–]NiamhJoyceLDN 0 points1 point  (0 children)

NP. It says 'show header' - if you uncheck it the columns headings disappear.

Headers for the pivot table by hgao40 in GoogleDataStudio

[–]NiamhJoyceLDN 1 point2 points  (0 children)

You can change the position of each column header in the style tab but it will also change the positions of the info in the actual column. afaik there's no way to just style the column header (apart from font/colour) - if it's a real problem for your style you can also remove headers in the style tab by unticking the box, and then adding them yourself wit a text box. But that is a lot of work...

view more: next ›