I need to create a time stamp when a check box is checked. I then want to create a formula field that calculates the difference between time stamp and a deadline or now.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
  1. I need to create a time stamp when a check box is checked.  How do I do this?  
  2. If that check box is checked, I want to create a formula field that calculates the difference between that time stamp and a deadline.  How do I do this?
  3. If that box is not checked, I want the formula field to calculate the difference between now() and the deadline.  How do I do this?
  4. Under either condition, I want the result to be the number of hours (over)/under due for the record.  How do I do this?
Photo of Brett Telford

Brett Telford

  • 20 Points

Posted 3 years ago

  • 0
  • 1
Photo of Brett Telford

Brett Telford

  • 20 Points
In an effort to get this to work, I tried the following:

  1. I used a form rule that updates a field called 'Time Completed' with the current time.
  2. This answers 2, 3 and 4 from above but it does not seem to be holding the calculation fixed even when I switch the status of my drop down box to 'Completed'.  It continues to calculate the change between Now and my Deadline.  Not what I am intending to do.
         ToHours(If([Task Status]="Complete",[Deadline]-[Time Completed],[Deadline]-Now()))


Thoughts??
Photo of Brett Telford

Brett Telford

  • 20 Points
Nevermind!  Got it to work!