Art Directors Guild Nominations

[OscarGuy]

I do two columns, sort by the alphabetizing column, and then use concatenate to combine the two fields again. It seems a lot easier that way.

[Big Magilla]

I assume you copied this form elsewhere? I am bugged by how many prominent organizations don't seem to understand that excel spreadsheets do not sort alphabetically. The Prom does not come after Promising Young Woman. The Croods is not alphabetized after Soul and more...

Sorry, major pet peeve.

Yes, it's quite annoying. Microsoft has a quick fix for eliminating the articles a, an, the, so that you don't have to do it manually on long lists but then you wither have the titles without the article so if you want to display them you have to add the article back in after the sort. What they need to do is come up with a way of ignoring the article when sorting without eliminating it.

This is the recommended quick fix:

https://answers.microsoft.com/en-us/mso ... 40243f3983

[Mister Tee]

I assume you copied this form elsewhere? I am bugged by how many prominent organizations don't seem to understand that excel spreadsheets do not sort alphabetically. The Prom does not come after Promising Young Woman. The Croods is not alphabetized after Soul and more...

Sorry, major pet peeve.

Copied from Variety. You know -- the Bible of show business.

Have all the peeves you want. Don't get me started on the Oxford comma.

[OscarGuy]

I assume you copied this form elsewhere? I am bugged by how many prominent organizations don't seem to understand that excel spreadsheets do not sort alphabetically. The Prom does not come after Promising Young Woman. The Croods is not alphabetized after Soul and more...

Sorry, major pet peeve.

[Mister Tee]

Nominees:

PERIOD FEATURE FILM
“Mank” (Production Designer: Donald Graham Burt)
“Ma Rainey’s Black Bottom” (Production Designer: Mark Ricker)
“Mulan” (Production Designer: Grant Major)
“News of the World (Production Designer: David Crank)
“The Trial of the Chicago 7 (Production Designer: Shane Valentino)

FANTASY FEATURE FILM
“Birds of Prey: And the Fantabulous Emancipation of One Harley Quinn” (Production Designer: K.K. Barrett)
“Pinocchio” (Production Designer: Dimitri Capuani)
“Tenet” (Production Designer: Nathan Crowley)
“The Midnight Sky” (Production Designer: Jim Bissell)
“Wonder Woman 1984” (Production Designer: Aline Bonetto)

CONTEMPORARY FEATURE FILM
“Da 5 Bloods” (Production Designer: Wynn Thomas)
“I’m Thinking of Ending Things” (Production Designer: Molly Hughes)
“Palm Springs (Production Designer: Jason Kisvarday)
“Promising Young Woman (Production Designer: Michael T. Perry)
“The Prom (Production Designer: Jamie Walker McCall)

ANIMATED FEATURE FILM
“A Shawn the Sheep Movie: Farmageddon” (Production Designer: Matt Perry)
“Onward” (Production Designer: Noah Klocek)
“Soul” (Production Designer: Steve Pilcher)
“The Croods: A New Age” (Production Designer: Nate Wragg)
“Wolfwalkers” (Production Designers: Ross Stewart, Tomm Moore, Maria Pareja)