(09-06-2024, 10:21 AM)cland Wrote:

(09-06-2024, 08:34 AM)Mikey Wrote: TWITAFCS sheet

If somebody can test this link out and reply, lemme know:

• can you access the standings/view the sheet?
  
• can you edit a cell? use a blank cell in column G or something, please don't overwrite a formula
  
• can you see/unhide hidden sheets?
  

Thanks for any feedback! This should make tracking super easy.

So I can view the sheet, but it comes up in read-only mode.  So I can see the spreadsheet, but can't edit it.  Can't edit Column G, and can't see the hidden sheets.  I did request write access with a 'testing it' message.

Perfect. Exactly what I was hoping for. I got that request, too. Thanks for your help! I may unhide the picks sheet so everyone can confirm selections, but I'd rather keep the sheet as view only and picks be made on the board. I'm recording picks as they are posted and I'll be sure to update picks that qualify before changing to results.

Edit: Sheet updated with picks visible. Quick explanation: PW and PL are entries for pick to win/lose. If AFCS plays AFCS I take one of the teams out and log picks based on win/lose for the other team. So anyone who picks the clots in W1 are listed as PL for HOU.

---