Our database tracks blog content generation for clients. Each line item includes a multiselect column for author and a multiselect column for editor. I would like to assign a dollar amount to each author name and each editor name so that I can calculate total cost for each blog post. Hopefully then I can pull a list of blog posts completed within a certain time frame and get total costs for that.
Connect
Notion Answers
Help between Notion users
Register & Ask
It's free & easy
Get answers
Answers, votes & comments
Vote and select answers
Receive points, vote and give the solution
Question
1 Answer
Create two new Notion formula properties in your database and use something like this.
Formula for Authors
if(prop("Author") == "John", 250, if(prop("Author") == "Charles", 300, 0))
John makes $250 and Charles $300.
Formula for Editors
if(prop("Editor") == "James", 220, if(prop("Editor") == "Rick", 430, 0))
James makes $220 and Rick $430.
The formulas are checking two names, you will need to extend them with more ifs to match your Authors and Editors number.
Related questions
 How can I calculate minutes to add total hours (or minutes) in a formula to add totals?
 Is it possible to return the name of every day within a time range via formula?
 Formula to calculate the amount of money spent last 3 months
 Formula to calculate a person's age given we have their date of birth?
 How to calculate test results with a nested ifstatement?
Without Answer

 48
 0
 2 days ago

 88
 0
 Sep 10

 103
 0
 Sep 4

 91
 1
 Aug 29

 73
 1
 Aug 26

 380
 1
 Jul 4

 599
 1
 May 14

 460
 1
 May 9
 see all
Exclusive for Notion Answers Users
 • Dynamic Calendar Icon  Info  Download
 Add yours here
Recent Activities
carlote asked 2 days ago
I have a block with writing "No Access". Unable t…notionhq selected an answer 5 days ago
Fatal error during installationgoatqueen asked Sep 10
Filter & calculate attendance every yearnotionhq selected an answer Sep 10
How I can auto fill a data base with consecutive n…polle commented Sep 9
Need help with a time formula
...