Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Need Airtable expert to help build formulas

1813 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Kevin_J_Ross
4 - Data Explorer
4 - Data Explorer

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 Replies 2
Andrew_Johnson1
8 - Airtable Astronomer
8 - Airtable Astronomer

Hi Kevin,

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

Best Wishes,
Andrew

Gareth_Pronovos
7 - App Architect
7 - App Architect

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