Formula Question

Sky Schofield

We have different types of signs populated from a form selection criteria. I want to assign a $ value to each of the signs when they are selected, through a formula. What formula should I use and how should it be written? The criteria are below.

Vinyl Door Decal (24"x24") - $200

Vinyl Door Decal (36"x36") - $300

Aluminum Panel (48"x96") - $2000

Acrylic Panels (48"x96") - $2000

Monument (48"x48") - $3000

Monument (48"x144") - $5000

Large sign on post (60"x120") - $1000

3D Letters, Linear Logo (10' wide) - $5000

Sky Schofield

Soumitra Bhowmick

The best way is to keep a master reference of different sign and their cost estimate in a different Smartsheet. In the main sheet, pull them using Vlookup formula.