Use case
1
Calculate how many days were spent on a task
2
Get a countdown from today to the due date of the project
3
Convert a date into a label
4
Calculate the subtraction of X days from a date
5
Check if the due day is before/after today
6
Calculate the number of days that have passed based on the start date of your project
7
Calculate how many hours ago a task was created
8
Calculate % of budgeted time spent on the task
9
Check if the project is delayed by comparing the planned time and the actual time spent
10
Get the status of a task
10 rows
Department
Formula
Description
Project Management
field('Due date') - field('Kickoff date')
If you have a start date (Field A) and an end date (Field B) for a task, and you want to calculate the number of days spent on the task.
Project Management
field('Due date') - today()
If you have a due date (Field A) and you want to calculate the countdown between today and the due date.
Project Management
if(field('Due date') < today(), 'Past', if(field('Due date') = today(), 'Today', 'Future'))
If you want to convert a date (Field A) into a label (e.g., "Past," "Today," "Future") based on its relationship to the current date.
Project Management
today() - date_interval('7 days')
If you have a date (Field A) and you want to subtract a certain number of days (e.g., 7 days) from it.
Project Management
if(field('Due date') < today(), 'Before', 'After')
If you have a due date (Field A) and you want to check if it's before or after today's date.
Project Management
today() - field('Kickoff date')
If you have a project start date (Field A) and you want to calculate the number of days that have passed since the start date.
Project Management
date_diff('hour', field('Task creation time'), now())
If you have a task creation time (Field A) and you want to calculate how many hours ago it was.
Project Management
field('Time spent in hours') / field('Budgeted time spent') * 100
If you have a budgeted time (Field A) and actual time spent (Field B) on a task, and you want to calculate the percentage spent.
Project Management
if(field('Due date')>field('Kickoff date'), 'On time', 'Late')
If you have a planned end date (Field A) and an actual end date (Field B) of a project, and you want to check if the project is late.
Project Management
if(field('Completed') = true, '✅ Completed', '🔴 Start ASAP')
If you want to get the status of tasks based on the checkbox field (Field Check).