PARTIAL MATCH NOT Return desired output well Don't know why the function is not working well? =IFERROR(TEXTJOIN(" ",TRUE,QUERY(ARRAYFORMULA(IF(RE…

0 Updates 1 Recommended Answer 2 Replies 0 Upvotes

Different permissions on separate tabs in the same Google sheet I have a work roster that I need to share to all team members on a monthly basis. It currently has t…

0 Updates 1 Recommended Answer 2 Replies 0 Upvotes

I want to run a macro automatically when a sheet opens I want to run a macro automatically when a sheet opens. How can I set this up?

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

TODAY in UK format Howe do I make TODAY produce a result in UK format not US (i.e. 23/06/2024 instead of 06/23/2024)? T…

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

Using XLOOKUP and COUNTIFS to derive total out of offices (OOO) within a date range I have two sheets. In one sheet (sheet A) I have team member names with the date range defined and i…

0 Updates 0 Recommended Answers 12 Replies 0 Upvotes

I did not wish to purchase app but think I did. I do not want app. I think purchased and do not want. Was done with in last three mi utes. 

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

I choose line spacing 1 but there is still a gap between lines I am trying to not leave space between lines. In some part of the documents I can do it and in anoth…

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

I need to pull the the row that contains the last instance of a criteria I have an Book Inventory Spreadsheet. Column D Is Languages (8 different options in this column) Col…

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

Google Docs Page Break Update Google Docs just updated and it looks so ugly because all the page breaks are all connected and inst…

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

Confirmation message shows the previous message I've created a Google Form with two questions: 'Score 1' and 'Score 2.' I want to automatically calc…

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

$ based off cash/electronic , home/mobile to my totals tab for different subjects. I made a sheet called Jan.(one for each month )In the Jan tab i have each massage I provided with in…

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

How to maintain formatting using TOCOL ? Hi ! i need to understand if there is a way if i use TOCOL the "bold" cells remain "bold" when they …

0 Updates 1 Recommended Answer 3 Replies 0 Upvotes

How to allow commenters to filter the spreadsheet just for them? Hello everybody. I am in the following situation: I created a form and created a spreadsheet that is…

0 Updates 0 Recommended Answers 7 Replies 0 Upvotes

Couple of styles plugins are asking for all permissions to all of my Google Docs I was trying to create a custom style in Google Docs but unfortunately the native Google Docs doesn'…

0 Updates 1 Recommended Answer 2 Replies 0 Upvotes

mysterious light blue box in the middle of my Sheets A big, light blue box appeared in the center of my sheets page. blocks my view, can't select or move…

0 Updates 0 Recommended Answers 3 Replies 0 Upvotes

Importing data from CSV or google sheets to specific cells Hi, I own a bakery, we use a weekly google sheet with multiple tabs to manage the bakery production …

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

Issue editing sheets In my phone, I cannot edit sheets with my profiles which are not the main one.

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

Counta not recognizing data in previously reliable formula Hello all, I have been effectively using a Counta formula that I received from another post on this …

0 Updates 0 Recommended Answers 8 Replies 0 Upvotes

how to get cumulative pending payment for each loan I have this sample sheet https://docs.google.com/spreadsheets/d/14eLH6fM0nvysNM5GKg1k-j8YCm0ZpKHYo3R…

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

import notes into keep Hi everybody I've been using another notetaking application for a while, but I'd like to concentrate…

0 Updates 1 Recommended Answer 4 Replies 0 Upvotes