Make an Escape Room Activity with Google Sheets
Click to make a copy I saw a Google sheet that had math problems and if you got the problems right it revealed the image. I was tempted to buy the sheet on TPT, but I thought I could do it myself. In my first attempt a few weeks ago, I didn't get anything to work. But after a few hours this morning, I got it. Here is my flow. Steps to make it 1. First I searched for [google sheets reveal image]. 2. I found this site https://sheetshelp.com/image/ 3. I scanned the article and went to the comments. 4. The first comment talks about basing an image on another cell and the author's reply gave a link to a support document. 5. The support document was for the function IFS (which means two IF statements) but I wanted one. So I went to the support page for the IF function. 6. I got the syntax for the IF function. 7. I found an image I could use. I wasn't picky so I went to Pixabay and looked for an open picture of a robot. 8. I thought I could cut it into 9 pieces using GIMP (o