icon picker
DEMO: Creating a Priority from Rank

1-circle-c

OVERVIEW

suitcase

Use Case

Create a table that automatically sets priority based on item score.
1-3: High
4-7: Medium
8-10: Low
spotlight

Highlights

For the formula, we simply check for 1-3 (high) first, then 8-10 (low). Otherwise, it’s 4-7 (medium).
Using a slider ensures the Score stays between 1 and 10.

us-dollar

Total Cost

Coda Plan: Free | Pack Cost: Free
do-not-drop

Packs Required

None

Did you enjoy this?
Subscribe to The Coda Magic Daily to get a new demo EVERY DAY, plus all the latest updates on packs and releases! And it’s FREE!
2-circle-c

SUPPORTING PAGES IN THIS DOC (TABLES AND FORMULAS)

None

disney-movies-

THE DEMO!

Item Priorities
0
Name
Score
Priority
1
Item 1
00
1
High Priority
2
Item 2
00
Medium Priority
3
Item 3
00
Medium Priority
4
00
Medium Priority
There are no rows in this table
if(thisRow.Score<=3, "High Priority", if(thisRow.Score>=8, "Low Priority", "Medium Priority"))
The formula reads like this:
If score is less than or equal to 3, set High Priority, but if it’s greater than or equal to 8, set Low Priority. If it’s neither of those, then set “Medium Priority.”
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.