Hopefully I’m not stepping on anyone’s toes here, but since reviews are popping up already, I figured it’d be good to get a review spreadsheet going as soon as possible! (Not sure why the preview says “This Sheet is private”; that’s definitely not the case.)
I used the same basic template as last year’s, which was originally created by Autumn Chen.
The sheet is open for anyone to add reviews, whether your own or ones you come across (here on the forum, on IFDB, or anywhere else). You can add columns for new reviewers by right-clicking. For reviews posted only in the private author’s forum, if you scroll to the right there’s a section specifically for those.
An easy option is to use the menu bar at the top under the “IFComp 2025 Review Spreadsheet”.
First of all copy your link for the review from the forum here - scroll to the relevant review in your review thread, then copy the address/URL from your web browser. It should have a number e.g. /5 or /6 etc. at the end to show which post you’re going to link directly to. This copy is probably most easily done on a computer (desktop or laptop).
Then go to the IFComp 2025 Review Spreadsheet linked from here in Google Sheets. Scroll to the spreadsheet cell in the column under your name for the row for the game you want to add a review for.
Then click on the “Insert” menu at the top left of the spreadsheet window, and from that vertical menu that appears click on “Link”.
Screenshot of IFComp 2025 Review Spreadsheet, showing multiple game rows and reviewer columns, and showing the “Insert” menu popped open and the “Link” entry in it about to be selected.
This will pop up a little window with two fields you can type into. For the “Text” field type “Review”, and paste your copied link to your review into the other box. Then click “Apply”.
I’m trying to add a conditional formatting rule to the spreadsheet to make games that still have zero reviews show up as a brighter red, but nothing I’ve tried has worked! Anyone want to take a crack at it? If you highlight column A and open the Conditional Formatting pane, you’ll see my latest failed attempt at the bottom.
When you apply a condition to a range in Google Sheets, you just write the condition as it should apply for the first cell, and it extrapolates from there. So in this case it’s just =C2=0 (“if cell C2 is 0”) and that gets extrapolated to =C3=0, =C4=0, and so on.
@moderators Could we get this thread pinned, perhaps? Since it doesn’t see many actual comments, it gets buried quickly and it’s a bit of a pain to search for it to add new reviews.
My creation was just one post off (led to The Olive Tree) but I think that should be fixed now, and the rest worked as expected.