Search found 3 matches

by jjtanner
Tue Apr 10, 2018 11:12 am
Forum: Other Member Technologies
Topic: Bishopric and Sacrament Meeting Template
Replies: 14
Views: 13118

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 ...
by jjtanner
Mon Apr 09, 2018 5:33 am
Forum: Other Member Technologies
Topic: Bishopric and Sacrament Meeting Template
Replies: 14
Views: 13118

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 ...
by jjtanner
Mon Apr 09, 2018 5:16 am
Forum: Other Member Technologies
Topic: Bishopric and Sacrament Meeting Template
Replies: 14
Views: 13118

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...

Go to advanced search