Need help with a date formula

  • 1
  • 1
  • Question
  • Updated 3 months ago
  • Answered
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, 
Photo of Aaron Snow

Aaron Snow

  • 260 Points 250 badge 2x thumb

Posted 3 months ago

  • 1
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 11,778 Points 10k badge 2x thumb
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. 
Photo of Aaron Snow

Aaron Snow

  • 260 Points 250 badge 2x thumb
Even,  
Thanks for the insight. I was able to get a formula to work. However, it likely would have been easier to create an automation as you suggested.

Thanks,