How to create an IF formula that assigns priority based on a value in Stackby?

2026-05-02T16:50:00Z

Trying to automatically assign priority in Stackby based on certain values?

Use a nested IF or SWITCH formula. Example: IF({Score} >= 90, ‘Critical’, IF({Score} >= 70, ‘High’, IF({Score} >= 50, ‘Medium’, ‘Low’))). For cleaner syntax, use SWITCH: SWITCH(TRUE(), {Score}>=90, ‘Critical’, {Score}>=70, ‘High’, {Score}>=50, ‘Medium’, ‘Low’). This auto-fills a Priority column based on your scoring criteria.