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.
Help between Notion users
It's free & easy
Answers, votes & comments
Receive points, vote and give the solution
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.
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.