![]() ![]() Similarly, the bulletin / Music document would only display first names. While this really shouldn't be a big deal, the way the background formulas and scripts work 2 extra spaces between a first and last name would often cause the pulpit sheet to only display first names. In case anyone is interested, there is an update to the spreadsheet that will automatically remove extra spaces between names. All multiple spaces are turned into just one space, which is not at all helpful in this situation.] You can paste the formulas into each cell and then edit the formula in your favorite spreadsheet program to add the space, or you might just copy the file again using the link at the end of the post.Īgain, this is a Forum software limitation. This needs to happen for all three cells. There should be two spaces between the quotes surrounding the single space after the comma. In each formula, there is a double asterisk in quotes, followed by additional quotes and spaces like this: "**","")," ". [Moderator note: A limitation in the Forum software does not allow the formulas to be displayed correctly. Screen Shot at 5.06.12 PM.png (269.43 KiB) Not downloaded yet Screen Shot at 5.07.36 PM.png (213.6 KiB) Not downloaded yet Its still a work in progress (still finding a few bugs) so just keep that it mind. IF this is not an appropriate venue for this - feel free to move it or delete! I'm just putting this out there as it has been an enormous time saver for our Bishopric. ![]() You choose what time the emails go out and what the message is and they will read the schedule on the planner and send out automatically. Īlso - if you enable the options in the SETUP tab, it can send out automatic email reminders for Spiritual Thought and Handbook training assignments for Bishopric and automatic emails for Ward Council / PEC reminders and Spiritual Thought assignments. ![]() Oh and if you are stuck for a speaker and topic - click the Liahona for guidance. The Sacrament Planner also tracks when someone last spoke. Since using this I have received and given ZERO calls to / from music leader or bulletin editor about what is happening on a given Sunday. The Bulletin Leader has access to the music document so she can see who is speaking, what the music is, etc. The music document receives the speakers and topics so she can plan music accordingly. The music leader has access to the music document. iew#gid=54īasically this allows us as a Bishopric to plan our speakers and topics and it will automatically update a "pulpit" sheet that we print off (or use ipads) every Sunday. dit#gid=52įeel free to mess around - (all the names are fake.)Īnd if want to make one for your unit - use this link and follow the instructions. This is a sample of what it looks like with fake names.Ī) Sacrament and Bishopric Planning Document. I am not sure if this is an appropriate venue for posting this, but here is a link to a google sheet that will enable a unit leader to make a customized Bishopric and Sacrament Meeting Template. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |