Page 1 of 1

Street Sort

Posted: Tue Apr 12, 2016 3:35 am
by WWS36
Where can I get my ward sorted by Street address instead of Alphabetically?

Re: Street Sort

Posted: Tue Apr 12, 2016 6:37 pm
by sbradshaw
There isn't currently a way to do that in Leader and Clerk Resources. You should send this as feedback using the "Do You Have Feedback" link at the bottom of the page. I've also sent feedback on this in the past. Some of the other columns are sortable, but not the address. Phone number would also be handy to sort, to organize by area code.

Re: Street Sort

Posted: Tue Apr 12, 2016 9:45 pm
by WWS36
A good brother sent these EXCEL formulas to me and they work like a charm!!!
THanks, WWS
try these
=LEFT(A1,SEARCH(" ",A1)-1)
=MID(A1,SEARCH(" ",A1)+1,50)

or these
=LEFT(A2,SEARCH(" ",A2,SEARCH(" ",A2)+1)-1)
=MID(A2,SEARCH(" ",A2,SEARCH(" ",A2)+1)+1,50)

Re: Street Sort

Posted: Tue Apr 12, 2016 11:00 pm
by sbradshaw
It's a lot of work to keep a separate spreadsheet, though – it'd be nice if Leader and Clerk Resources could sort.

Re: Street Sort

Posted: Wed Apr 13, 2016 3:32 am
by WWS36
Tell me about it. I'm doing the whole Stake!