Our database tracks blog content generation for clients. Each line item includes a multi-select column for author and a multi-select 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
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 if-statement?
Without Answer
-
- 319
- 0
- Apr 29
-
- 1285
- 1
- Apr 4
-
- 413
- 1
- Mar 20
-
- 417
- 0
- Mar 14
-
- 356
- 0
- Feb 21
-
- 341
- 1
- Feb 14
-
- 423
- 0
- Feb 13
-
- 421
- 0
- Feb 11
- see all
Recent Activities
joeythelemur commented Apr 29
How can I better organize a LOT of properties?amandabee selected an answer Apr 29
Adding a basic feedback form to pages in a Notion…amandabee answered Apr 29
In Notion, I want the “Title” column to be filled …amandabee answered Apr 29
How can I better organize a LOT of properties?
...