Calculated Column Design Examples | LookBook 365

Days Until Due Formula Example

Days Until Due

Line Total Formula Example

Line Total

Age in Years Formula Example

Age in Years

Budget Variance Percentage Formula Example

Budget Variance Percentage

Build an Email Address Formula Example

Build an Email Address

Days Between Two Dates Formula Example

Days Between Two Dates

Calendar Quarter Formula Example

Calendar Quarter

Days to Complete a Task Formula Example

Days to Complete a Task

Discount Amount Formula Example

Discount Amount

End of Month Formula Example

End of Month

High-Value Flag Formula Example

High-Value Flag

Expires 30 Days After Last Edit Formula Example

Expires 30 Days After Last Edit

Expiration Date From a Start Date Formula Example

Expiration Date From a Start Date

Email Domain Formula Example

Email Domain

Priority by Days Left Formula Example

Priority by Days Left

Proper-Case a Name Formula Example

Proper-Case a Name

Quarter and Year Label Formula Example

Quarter and Year Label

Traffic-Light Status Formula Example

Traffic-Light Status

Reference Code Formula Example

Reference Code

Round to Cents Formula Example

Round to Cents

Month Name Formula Example

Month Name

On Track or At Risk Formula Example

On Track or At Risk

Overdue Flag Formula Example

Overdue Flag

Pass or Fail Formula Example

Pass or Fail

Email Username Formula Example

Email Username

Fiscal Year Formula Example

Fiscal Year

Full Name Formula Example

Full Name

Gross Margin Percentage Formula Example

Gross Margin Percentage

Initials Formula Example

Initials

Last, First Name Formula Example

Last, First Name

Markup Percentage Formula Example

Markup Percentage

Total With Tax Formula Example

Total With Tax

Trim Extra Spaces Formula Example

Trim Extra Spaces

Shorten Long Text Formula Example

Shorten Long Text

Uppercase a Code Formula Example

Uppercase a Code

Week Number Formula Example

Week Number

Day of the Week Formula Example

Day of the Week

Year From a Date Formula Example

Year From a Date

Start of the Week Formula Example

Start of the Week

Budget Variance Formula Example

Budget Variance

Mileage Reimbursement Form

Mileage Reimbursement Form

Simple Task List (Grid View)

Task List (Lists)

Project Risk Register (Board View)

Project Risk Register

IT Helpdesk Ticketing System Main List View

IT Help Desk Ticketing System