I am trying to create a priority score for a team travel destination based on a series of checkboxes. This is what I tried:
SUM(IF({1 Must Do}5,0),(IF({2 high on list}4,0),(IF({3 would like to do}3,0),(IF({4 maybe if in the area}2,0))
This isn’t bein...