Multiple time frames based off item select

Topic Labels: Formulas
1437 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I am trying to do a date diff formula and i need help. Lets say it has to do with aging. Products a for a 1 week, product b for 2, etc. If I have product type in column “Product” and start date in “last active”. I need “aged” column to look at “product” to get the type know how many weeks it needs to age and do a date diff from “last active” to tell me either “within min time” or “time met”. Any ideas?

1 Reply 1
8 - Airtable Astronomer
8 - Airtable Astronomer

basic structure,

1st, create a table that has product names and aging times

2nd table has list of instances(ex. specific wheels of cheese), and has the date you got the wheel, has a linked field to the appropriate product type in table 1, and then use a Lookup field of the linked field to pull the aging time from table 1. You can probably do the datetime_diff() from there.


Linked record fields

A linked record field allows you to represent the relationships between related records by creating links between them. This is particularly helpful when you have multiple tables of related items o...