Formulas 101: five you will use every week

Formulas reference other fields in curly braces, like {Due date}. Here are five we reach for constantly.

1. Days until due

IF({Due date}, DATETIME_DIFF({Due date}, TODAY(), "days"), BLANK())

2. Overdue label

IF({Due date} < TODAY(), "Overdue", "On track")

3. Cost per hour

IF({Hours}, ROUND({Budget} / {Hours}, 2), "")

4. Full name

{First name} & " " & {Last name}

5. Short code

UPPER(LEFT({Company}, 3)) & "-" & {Number}

Not sure how to write one? Describe it in the formula field and let AI write it for you.