Need help with a date formula
I would like to track the number of days after a field contains a specific text phrase. Any suggestions on how i can accomplish this? Thanks,
Forum Discussion
Hi Aaron,
When looking to track the number of days after a field has changed to a certain phrase you usually need to create a field that will be used to capture the date of the change as fields just hold the current value and not the time that value changed.
For example on a Tasks table if I wanted to capture the date the status field was changed to Complete I would create a date field named "Date Completed" to hold the date of the change. Then to populate that field I could create an Automation that is set up to say when my Status is edited and the Status field changes to Complete then fill Date Complete with the current date. Then once that field and automation are set up whenever a Task is marked complete it will be updated with the date. Then you can create a formula field that is set to track the difference between the current date and the Date Complete. It takes a couple of steps to get started at first but then going forward it can track for you.
I can go into more detail on the Automation if that would be helpful but I hope this at least gets you started.
When looking to track the number of days after a field has changed to a certain phrase you usually need to create a field that will be used to capture the date of the change as fields just hold the current value and not the time that value changed.
For example on a Tasks table if I wanted to capture the date the status field was changed to Complete I would create a date field named "Date Completed" to hold the date of the change. Then to populate that field I could create an Automation that is set up to say when my Status is edited and the Status field changes to Complete then fill Date Complete with the current date. Then once that field and automation are set up whenever a Task is marked complete it will be updated with the date. Then you can create a formula field that is set to track the difference between the current date and the Date Complete. It takes a couple of steps to get started at first but then going forward it can track for you.
I can go into more detail on the Automation if that would be helpful but I hope this at least gets you started.