Questions tagged [regexextract]

For questions about a spreadsheet function that allows selection from a string on the basis of a regular expression.

Filter by
Sorted by
Tagged with
4
votes
1answer
4k views

How to apply a relative reference in conditional formatting formula?

I have a whole bunch of cells (28 so far) that need conditional formatting. Here is what the data looks like: I want the colours in the top "Last Period" metric cells to vary depending on the values ...
3
votes
1answer
135 views

How to modify REGEXEXTRACT to import total hours played on Steam

My problem is similar as the one answered here: How to create an auto updating Google spreadsheet with information from Steam? Only I need to modify the REGEXEXTRACTs to find total hours played ...
0
votes
1answer
26 views

Pretty print google sheet formula?

Finding answers on Web Apps SE or Reddit is wonderful, but if you don't understand them you can't modify them. I recently came across the following as part of an answer: ={"Corrected List 2";...