Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Mar 11, 2019 08:45 PM
I have a column that is multiple select, in which I enter dates in the format mm/dd/yy, to keep track of when I bought things. So let’s say for Cinnamon, the History column might have dates 02/20/19 and 03/01/19 as multiple select entries.
I am trying to:
Thank you very much for any help!!
Mar 12, 2019 11:12 AM
Not sure that this can be done with a multi-select, but if you make that field a Link to Another Record field you can then use a Rollup MAX(values)
aggregation. From there you can use a Formula field that has the formula `DATETIME_DIFF({Rollup Field},TODAY(),‘days’)