Skip to main content

Help with formulas

  • January 26, 2018
  • 4 replies
  • 28 views
L

Hi,
I am having trouble writing a formula for the following. I would be most grateful for help!
I have a calendar field for Due Date. I’d like to make a field that says “overdue” when the Due Date has passed, “today” when the Due Date is today, “coming up” when the Due Date is 2 days out, and “next week” when the Due Date is 7 days out.
Thank you,

4 replies

A
  • Ali_Aboutera
  • Participating Frequently
  • January 26, 2018

I did a base that has 3 fields:

1- Meeting Date (Date)
2- Days Remaining (formula)
3- Status (formula)

This is the formula for Days Remaining:
DATETIME_DIFF({Meeting Date}, TODAY(), ‘days’)

This is the formula for Status:
IF({Days Remaining}=0,
“1- Today”,
IF({Days Remaining}=1,
“2- Tomorrow”,
IF({Days Remaining}<0,
“4- Past Meeting”,
“3- Future Meeting”)))

have a look and let me know, hope it was helpful.

L
  • Leah_Paulos
  • Author
  • New Participant
  • January 26, 2018

I did a base that has 3 fields:

1- Meeting Date (Date)
2- Days Remaining (formula)
3- Status (formula)

This is the formula for Days Remaining:
DATETIME_DIFF({Meeting Date}, TODAY(), ‘days’)

This is the formula for Status:
IF({Days Remaining}=0,
“1- Today”,
IF({Days Remaining}=1,
“2- Tomorrow”,
IF({Days Remaining}<0,
“4- Past Meeting”,
“3- Future Meeting”)))

have a look and let me know, hope it was helpful.


Thank you Ali! I’m not sure why but it is saying there’s an error for me.

I have a column with dates called “Due date” so I made a new column and tried this as the formula:
DATETIME_DIFF({Due date},TODAY(), ‘days’)

Am I doing something wrong?

A
  • Ali_Aboutera
  • Participating Frequently
  • January 27, 2018

Thank you Ali! I’m not sure why but it is saying there’s an error for me.

I have a column with dates called “Due date” so I made a new column and tried this as the formula:
DATETIME_DIFF({Due date},TODAY(), ‘days’)

Am I doing something wrong?


I’ve created a new table as an example here:
https://airtable.com/invite/l?inviteId=inv9rF37HK4qwoQpA&inviteToken=94ca06da4585b2ac9bd4e32185602a1ea544d16e066692b7e8393f91ab946f73

L
  • Leah_Paulos
  • Author
  • New Participant
  • January 29, 2018

thank you so much!! i really appreciate it.

A
Terms & ConditionsAccessibility statement