This is a great way to skip a copy & paste step.

The videos below demonstrate this shortcut.

Video thumbnail for How to use the MATCH Function for exact matches

Video thumbnail for How to generate random values

Video thumbnail for How to create a named constant

Video thumbnail for Shortcut recipe: fill in missing data

Video thumbnail for Shade groups of rows with conditional formatting

Video thumbnail for How to perform a random sort