Discussions

Expand all | Collapse all

Need help with a date formula

  • 1.  Need help with a date formula

    Posted 02-20-2019 16:07
    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, 


  • 2.  RE: Need help with a date formula

    Posted 02-25-2019 16:38
    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. 


  • 3.  RE: Need help with a date formula

    Posted 02-26-2019 14:09
    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,