Instead of using a column format, we’re using the formula here. In column 2, we’ve set the formula Movie(thisRow.SearchTerm, “CA”) so that our streaming results are Canadian.
You can also dig into the details within the results. The Stars column is a formula: MovieResult.Starring.Photo
Movie() Formula
SearchTerm
Movie Result
Vertical Poster
Year
Canadian Streaming
Canadian Rental
Canadian Buy
Stars
SearchTerm
Movie Result
Vertical Poster
Year
Canadian Streaming
Canadian Rental
Canadian Buy
Stars
1
Dune
Dune
2021
[]
Apple iTunes
Google Play Movies
Cineplex
YouTube
Apple iTunes
Google Play Movies
Amazon Video
Cineplex
YouTube
Microsoft Store
2
Dune 1984
Dune
1984
Crave
Crave Starz
Crave Plus
Starz Play Amazon Channel
Apple iTunes
Google Play Movies
Cineplex
YouTube
Microsoft Store
ILLICO
FlixFling
Apple iTunes
Google Play Movies
Cineplex
YouTube
Microsoft Store
3
Clouds of Sils Maria
Clouds of Sils Maria
2014
Criterion Channel
IFC Amazon Channel
Apple iTunes
Google Play Movies
Cineplex
YouTube
Apple iTunes
Google Play Movies
Cineplex
YouTube
4
A Bigger Splash
A Bigger Splash
2015
[]
Apple iTunes
Google Play Movies
Amazon Video
Cineplex
YouTube
Microsoft Store
Apple iTunes
Google Play Movies
Amazon Video
Cineplex
YouTube
Microsoft Store
There are no rows in this table
Want to print your doc? This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (