Extract Date with Day from text So I have a column with date like this: Even Thu, 08/22/2024 ١٧ صفر ١٤٤٦, and I want to extract the …

0 Updates 0 Recommended Answers 1 Relevant Answer 1 Reply 0 Upvotes

Sum of transactions on certain days of the week Hello everyone! I am trying to create some kind of formula or chart that will display £ taken on spe…

0 Updates 1 Recommended Answer 5 Replies 0 Upvotes

SUM duration being calculated incorrectly I've created a timesheet to track how long I'm spending on various tasks. It was working fine but th…

0 Updates 0 Recommended Answers 2 Replies 0 Upvotes

Looking for a formula to return a cell text if part of it is found Hey, I'm looking for a formula that will return a specific cell text from a range of cells if part o…

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

CONVERT TO TABLE OPTION NOT AVALABLE CONVERT TO TABLE OPTION NOT AVALABLE IN GOOGLE SHEETS

0 Updates 0 Recommended Answers 1 Relevant Answer 1 Reply 0 Upvotes

Smart chips When I use people chips I am getting an error that says "We've encountered an error converting chips…

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

Not able to open link in the Android mobile when trying to open with the google drive. I have created a sheet which is share with multiple folks but later I found that, we are not able to…

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

Trying to filter away other fruits and importrange "apple" with dates into a new sheet. Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered " <ID> "COL4 "…

0 Updates 0 Recommended Answers 1 Relevant Answer 3 Replies 0 Upvotes

Is there a way to make this LEN SUBSTITUTE code more specific? I'm making a gaming spreadsheet, and I'm using this to count the days I spend on each game. ​=((LEN(…

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

Help needed for formula I have attached a sheet link in thick I want the all according numbers should be placed in table num…

0 Updates 0 Recommended Answers 12 Replies 1 Upvote

How to avoid empty column cells and arrange/short data without any blank I want to short column cells without the empty cells. I have some empty cells, I just need too short…

0 Updates 1 Recommended Answer 1 Reply 0 Upvotes

2024 sheet replaced by mistakenly 2024 sheet was repalced kindly replace the 2024 previous sheet

0 Updates 0 Recommended Answers 1 Relevant Answer 1 Reply 1 Upvote

Filter to return recurring data only Hello, I have a dataset where I want to use the filter function to return the data in column A, but …

0 Updates 1 Recommended Answer 3 Replies 0 Upvotes

Update Subtotal formula based on Slicer Hey everyone, I have a table with several columns and rows, and I have a slicer to filter a column, …

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

copying cells to move ok I am stuck I have a group of cells to move with a consistent moving up in numbers though the hori…

0 Updates 0 Recommended Answers 1 Relevant Answer 1 Reply 0 Upvotes

Copy data from one sheet to another So i have 2 sheets. One that i enter data on and another i want the data to get added to, the proble…

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

dropdown fields I have one google sheet that when users bring it up, there is no dropdown arrow. They can double cli…

0 Updates 0 Recommended Answers 1 Relevant Answer 1 Reply 0 Upvotes

Sort column A by column C and have it start a new column while skipping column B Essentially this but I manually sorted the red cells. I want column A (and anything I put beyond A8)…

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

Sheets - "Error linking spreadsheets. Source spreadsheet has reached maximum capacity" We are getting the following error when using the IMPORTRANGE function in Sheets: Context: Work Orde…

0 Updates 0 Recommended Answers 1 Reply 1 Upvote

Google Sheets Filter function formula with Regexmatch Please Help! Trying to get this formula to work: =filter(Database!A5:W,REGEXMATCH(Database!A5:A,B2),…

0 Updates 0 Recommended Answers 1 Relevant Answer 1 Reply 0 Upvotes