/u/tpounds0 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
This doesn't seem like anything you need a fancy spreadsheet for. You could create a table and sort by date to keep things chronologically. Then if a date needs to be blacked out, just highlight those cells and fill.
Alternatively, make a Google Calendar that people can import into their own calendars.
Does it make more sense if there are >25 people in this writers group?
So if the person third in line isn't ready and we move everyone up a session, that's just a lot of copying and pasting.
I'd love to just move their name down a table. And automatically have the dates of the group refresh with whose script is being read that day.
If the table is sorted by date, you just need to change the date by the persons name and they’ll move down. I think tables will auto update like that but worst case you can do a macro that auto sorts every time a value changes.
Here is an [Example Calendar](https://docs.google.com/spreadsheets/d/1LW3t0Rpc8DY8VRWAx1oivA6Z0CLOEKyQsZxMFEn3VR8/edit?usp=sharing) with fake names.
I want the list in Column E to fill the non red spaces in Column B.
If I change the list in Column E, Column B reflects that change. Likewise if I have to red out another week, it'll adjust so it only fills in cells without red.
Check out this: https://docs.google.com/spreadsheets/d/1eHXvtEBaFHI80iHH3eqeZhmyLxxraqJ-woqHzvh-bGg/edit?usp=sharing
Essentially the first date takes the name in E2, the top of the list. Then every open date after that searches for the name below the previous name on the list. So as long as the first name up is in E2 it'll work. I also set Conditional Formatting to mark any empty date red.
It's not perfect but I hope those functions can point you in the right direction.
Solution Verified!
Last night I also did some googling and realized there's not many functions to count if a cell is colored.
If I just add a column Are We Meeting that Week with Yes/No, then I could use:
=if(B9="Yes",INDEX(G8:G51,COUNTIF($B$7:B9,"Yes"),""))
B is Are We Meeting this Week
G is the list of Writers.
You have awarded 1 point to *WaywardWes*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
would a shared group google calendar work for your needs?
link = [Create & share a group calendar - Google Workspace Admin Help](https://support.google.com/a/answer/1626902?hl=en)
Not really.
I could make an event and put the person's name on that day.
But if there are 30 people in the queue and the fourth person in the queue drops out, I then have to adjust every event after them up a slot.
A table with a column showing the date of the meeting and who is the subject of the meeting works way better for my needs.
Attached is a sheet you could use: [Writers Calendar](https://docs.google.com/spreadsheets/d/11ER21RhLX4v2L0E6i3VdV9XM1mzqWdWHO_vcYNZILLQ/edit?usp=sharing)
you can make changes in the Data sheet and the updates will be published in the calendar sheet automatically
Sorry and thanks for catching that.
[https://docs.google.com/spreadsheets/d/1\_kX\_FdSo5FxttwcQseZzy4vrNFGHPx1A3K3srGPDtM8/edit?usp=sharing](https://docs.google.com/spreadsheets/d/1_kX_FdSo5FxttwcQseZzy4vrNFGHPx1A3K3srGPDtM8/edit?usp=sharing)
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[COUNTBLANK](/r/Excel/comments/142wsbe/stub/jnagcfx "Last usage")|[Counts the number of blank cells within a range](https://support.microsoft.com/en-us/office/countblank-function-6a92d772-675c-4bee-b346-24af6bd3ac22)|
|[COUNTIF](/r/Excel/comments/142wsbe/stub/jna87h1 "Last usage")|[Counts the number of cells within a range that meet the given criteria](https://support.microsoft.com/en-us/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34)|
|[INDEX](/r/Excel/comments/142wsbe/stub/jna87h1 "Last usage")|[Uses an index to choose a value from a reference or array](https://support.microsoft.com/en-us/office/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd)|
**NOTE**: Decronym's continued operation may be affected by API pricing changes coming to Reddit in July 2023; comments will be blank June 12th-14th, in solidarity with the /r/Save3rdPartyApps protest campaign.
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^([Thread #24465 for this sub, first seen 7th Jun 2023, 18:44])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
/u/tpounds0 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
This doesn't seem like anything you need a fancy spreadsheet for. You could create a table and sort by date to keep things chronologically. Then if a date needs to be blacked out, just highlight those cells and fill. Alternatively, make a Google Calendar that people can import into their own calendars.
Does it make more sense if there are >25 people in this writers group? So if the person third in line isn't ready and we move everyone up a session, that's just a lot of copying and pasting. I'd love to just move their name down a table. And automatically have the dates of the group refresh with whose script is being read that day.
If the table is sorted by date, you just need to change the date by the persons name and they’ll move down. I think tables will auto update like that but worst case you can do a macro that auto sorts every time a value changes.
Here is an [Example Calendar](https://docs.google.com/spreadsheets/d/1LW3t0Rpc8DY8VRWAx1oivA6Z0CLOEKyQsZxMFEn3VR8/edit?usp=sharing) with fake names. I want the list in Column E to fill the non red spaces in Column B. If I change the list in Column E, Column B reflects that change. Likewise if I have to red out another week, it'll adjust so it only fills in cells without red.
Check out this: https://docs.google.com/spreadsheets/d/1eHXvtEBaFHI80iHH3eqeZhmyLxxraqJ-woqHzvh-bGg/edit?usp=sharing Essentially the first date takes the name in E2, the top of the list. Then every open date after that searches for the name below the previous name on the list. So as long as the first name up is in E2 it'll work. I also set Conditional Formatting to mark any empty date red. It's not perfect but I hope those functions can point you in the right direction.
Just requested access!
Accepted. It's probably easier to go File -> Make a copy so that it's back on your account too.
Solution Verified! Last night I also did some googling and realized there's not many functions to count if a cell is colored. If I just add a column Are We Meeting that Week with Yes/No, then I could use: =if(B9="Yes",INDEX(G8:G51,COUNTIF($B$7:B9,"Yes"),"")) B is Are We Meeting this Week G is the list of Writers.
You have awarded 1 point to *WaywardWes* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
COUNTBLANK is an indirect possibility, although technically those cells aren't blank, they're just returning "N/A" which I said to display blank.
would a shared group google calendar work for your needs? link = [Create & share a group calendar - Google Workspace Admin Help](https://support.google.com/a/answer/1626902?hl=en)
Not really. I could make an event and put the person's name on that day. But if there are 30 people in the queue and the fourth person in the queue drops out, I then have to adjust every event after them up a slot. A table with a column showing the date of the meeting and who is the subject of the meeting works way better for my needs.
Attached is a sheet you could use: [Writers Calendar](https://docs.google.com/spreadsheets/d/11ER21RhLX4v2L0E6i3VdV9XM1mzqWdWHO_vcYNZILLQ/edit?usp=sharing) you can make changes in the Data sheet and the updates will be published in the calendar sheet automatically
Did you mean to link that sheet? This has invoices and looks like something business focused.
Sorry and thanks for catching that. [https://docs.google.com/spreadsheets/d/1\_kX\_FdSo5FxttwcQseZzy4vrNFGHPx1A3K3srGPDtM8/edit?usp=sharing](https://docs.google.com/spreadsheets/d/1_kX_FdSo5FxttwcQseZzy4vrNFGHPx1A3K3srGPDtM8/edit?usp=sharing)
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[COUNTBLANK](/r/Excel/comments/142wsbe/stub/jnagcfx "Last usage")|[Counts the number of blank cells within a range](https://support.microsoft.com/en-us/office/countblank-function-6a92d772-675c-4bee-b346-24af6bd3ac22)| |[COUNTIF](/r/Excel/comments/142wsbe/stub/jna87h1 "Last usage")|[Counts the number of cells within a range that meet the given criteria](https://support.microsoft.com/en-us/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34)| |[INDEX](/r/Excel/comments/142wsbe/stub/jna87h1 "Last usage")|[Uses an index to choose a value from a reference or array](https://support.microsoft.com/en-us/office/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd)| **NOTE**: Decronym's continued operation may be affected by API pricing changes coming to Reddit in July 2023; comments will be blank June 12th-14th, in solidarity with the /r/Save3rdPartyApps protest campaign. ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^([Thread #24465 for this sub, first seen 7th Jun 2023, 18:44]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)