Skip to main content

Hey


I want to track the dates of when we shipped our items.

So if I write Shipped, into one field, another field should be populated with the current date.

I tried this:

LEFT(IF({ ✍ Shipping status*} = “3. Shipped”, LAST_MODIFIED_TIME({ ✍ Shipping status*}),""),10)

But sadly this is not really what I am after since it would alter the date if someone changed the Shipping status field due to whatever reason.


Also writing an if formula with if (shipping status = SHipped), Today (), “”)

is also not working since it will update the date on the next day.

I need an if formula with Today, that will not change after calculating it once.


Thank you

If I’m understanding correctly, you have a single select field (shipping status), and you’d like to get the time/date when a given option was selected.


If that’s the case, I don’t think you’ll be able to find a well automated solution with vanilla Airtable. I posted a data persisting product suggestion a while ago that would address these needs.


Barring Airtable building that feature, you can either (1) have users fill out a date field manually (2) come up with a scripted solution (users manually trigger a button), or (3) make use of a third party integration. Both 2 and 3 would be some code that auto records values to a date field.

One tool that only recently became available, and which could probably help a lot in this case, is the scripting action beta. I’ve been using it for a little over a week, and it’s pretty amazing what it can do. Long story short, a script could be triggered by this system, and the script could fill a normal date field with today’s (or any other) date.

Reply


Terms & Conditions