Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jan 14, 2023 05:01 AM
Hi,
Hope you are all doing well.
I need a little help. I have a simple single select column which have different tags and can be updated time to time. I want to calculate the edit history of each tag in other column and wanted to know how many days requiring each tag i.e when it was changed from in progress to shipped. I want to calculate the time and no. of days.
I'd really thankful if anyone provide me best solution 🙂
Thanky you
Solved! Go to Solution.
Jan 24, 2023 07:10 PM
Okay, here's a sample of the fields:
It's one automation for all the fields. The trigger watches for "Process Stage" to be updated. Then it's a series of conditional actions.
Jan 17, 2023 09:07 PM - edited Jan 17, 2023 09:08 PM
Is there a typical order of the status changes? (ie, from ordered --> shipped -->delivered?)
If so, what I've done for this is create date columns for each status and then use automations to record the date that status is first changed. For example, I would have an automation that triggers when the status column updates. Then a conditional action that would paste the date (from a column with the Today formula) in the Ordered Date column when the status equals "Ordered", and another conditional action that would paste today's date in the Shipped Date column when the status equals Shipped.
Jan 20, 2023 01:04 AM
Thank you so much for your response @Micki_O_Neil
I have a column and there are around 5 stages of production. Each tag is updated when it moves from one step to next.
Also, I have paid plan with shows history of 6 months.
Let me know if these automation works on December & November sheet? I wanted to get data of old sheets. If not, is there any other solution?
Thanks again 🙂
Awaiting for your response
Jan 20, 2023 06:50 AM
This should work, although it will work a lot easier if you keep all the data in one table and create views of each month to filter out old data.
Just make a field for each stage's date and a field with the formula Today(). You can then make one automation triggered by updates to the stage field and five conditional actions to update the relevant column with today's date (using the Today field).
Jan 23, 2023 04:33 AM
I am sorry to bother you again.
Can you please share any example with screenshots?
TIA 🙂
Jan 23, 2023 12:40 PM
Do you need screenshots on the automations? Or the fields/table set up? Or both?
Jan 23, 2023 11:13 PM
Both 🙂
Jan 24, 2023 07:10 PM
Okay, here's a sample of the fields:
It's one automation for all the fields. The trigger watches for "Process Stage" to be updated. Then it's a series of conditional actions.