Search found 3 matches
- Tue Apr 10, 2018 11:12 am
- Forum: Other Member Technologies
- Topic: Bishopric and Sacrament Meeting Template
- Replies: 14
- Views: 16144
Re: Bishopric and Sacrament Meeting Template
In case anyone is interested, there is an update to the spreadsheet that will automatically remove extra spaces between 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 ...
- Mon Apr 09, 2018 5:33 am
- Forum: Other Member Technologies
- Topic: Bishopric and Sacrament Meeting Template
- Replies: 14
- Views: 16144
Re: Bishopric and Sacrament Meeting Template
I have a work-around to my problem (question about Hispanic ward members with multiple last names) but still would prefer a way to include all names before the comma as the last name. The work-around is to copy from online MLS into Excel. Then I run this Excel formula to remove spaces between names ...
- Mon Apr 09, 2018 5:16 am
- Forum: Other Member Technologies
- Topic: Bishopric and Sacrament Meeting Template
- Replies: 14
- Views: 16144
Re: Bishopric and Sacrament Meeting Template
Once more, again, an updated link for the template to make your own version - https://docs.google.com/spreadsheets/d/1I9DFq2CwPAUywfkCb8jrSOm1a8nsj5scm2NbVr0GEi0/edit#gid=54 This is brilliant, thanks! I'm not familiar with Google Apps Script and am not sure how to fix an issue with the speakers imp...