Question

I want to type in a "name" of something and it autofills with the "number" that it's set to. Example. Sofa = $145

So when I am in a database, and I type sofa, I want the box to autofill to $145 instead of sofa.

Answer 1

That is not how Notion formulas work, you need 2 properties.

1- Name
2- Formula

In 1 you write the name: Sofa
In 2 you have something like this:

if(prop("Name") == "Sofa", "$145", "")

If the name is equal to Sofa, show $145, otherwise show nothing.

So if you have 20 variables, you will need to create a complete formula checking everything and displaying what you need.

Hope that helps.