Need Airtable expert to help build formulas


#1

Very simple project. We need someone to build formulas for our Software Development Board table - specifically to create a formula that sums up the different ‘variables’ (1) for each task, and outputs a ‘score’ (2) to help prioritize each task.

Here’s an example of the structure we look to create:

The current input variables are:

  1. Urgency (+)
    • Very Urgent (10)
    • Urgent (5)
    • Normal (2.5)
    • Not Urgent (0)
  2. Business Value (+)
    • Very High Value (10)
    • High Value (7)
    • Normal Value (5)
    • Low Value (3)
    • Very Low Value (0)
  3. Potential User Value (+)
    • Very High Value (10)
    • High Value (7)
    • Normal Value (5)
    • Low Value (3)
    • Very Low Value (0)
  4. Effort Required (-)
    • <1 hour (0)
    • 1-3 hours (-1)
    • 3-5 hours (-2)
    • 5-10 hours (-3)
    • 10-20 hours (-5)
    • 20+ hours (-7)

So, for each of our dev tasks, we would attribute one option per variable. For example:

Task A (inputs):

  • Urgency (Very Urgent, +10)
  • Business Value (Very High Value, +10)
  • User Value (High Value, +7)
  • Effort Required (1-3 hours, -1)

Task A (output):

  • Priority Score = 26 (10+10+7-1)

Anyone who can build this for us, please leave your email/contact info below and I will reach out to you ASAP.

Thanks,
kjr


#2

Hi Kevin,

I would be glad to help you out on this.
You can reach me on andrewjohnson56782@gmail.com

Best Wishes,
Andrew


#3

Hi Kevin,

It sounds like you’ve fully planned out the architecture here - seems like a formula or two would get this fully operational.

If you’d like to chat, please book some time with me, here.

Thanks,
Gareth