Help

Discover what data silos are costing your org in our commissioned Forrester study. Learn more

Involves airtable formula and scripting

194 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello everyone, I’m setting up a database to access people’s task. I’ll state a task and assign a score to it, 1-5 to show how important it is, then check 3 fields. If the fields are checked, the value should equal the value score value selected earlier and if not, zero. Then the total vaue sholud be calculated only if the completed column is checked that the task is completed. So there are four checked to be checked. Let’s say i select a score of 4, and i check all three fields and then the complete field, the total score should be calcuated as 16, but if 2 fields and completed, I score 12 but if completed not checked at all, the total shouldn’t be calculated at all. I don’t know how to setup the formula for this or better still a script that can run this. Pls help out!

1 Reply 1

Hi,
use smth like
score1*(chbox1=1)+score2*(chbox2=1)
for total score
and IF for conditional display