Skip to main content
Solved

How to stop TONOW() from updating

  • December 28, 2022
  • 2 replies
  • 23 views
O
Forum|alt.badge.img+1

Hello,

I have 4 columns setup. 

Date Opened - is a created time field, logs when an entry is created
Time Opened - is a formula field with the following:  TONOW({Date Opened}) - Simply logs in minutes (will likely change to hours) how long an entry has been opened for.
Done - Simple checkmark box
Date Closed - Is a formula Field with the following: IF(Done = 1, LAST_MODIFIED_TIME(Done)) - simply logs the time an entry is marked as Done with a checkmark.

My current issue is, I'd like Time Opened to stop counting as soon as Done is checked and I cant quite figure out how to do this. Does anyone have any pointers?

Thanks!

Best answer by kuovonne

IF(

  {Done},

  DATETIME_DIFF(

    {Date Closed},
    {Date Opened},

    "minutes"

  ) & " minutes",

 TONOW({Date Opened}) 

)

    2 replies

    kuovonne
    Forum|alt.badge.img+29
    • kuovonne
    • Brainy
    • 6009 replies
    • Answer
    • December 28, 2022

    IF(

      {Done},

      DATETIME_DIFF(

        {Date Closed},
        {Date Opened},

        "minutes"

      ) & " minutes",

     TONOW({Date Opened}) 

    )

    kuovonne
    Forum|alt.badge.img+29
    • kuovonne
    • Brainy
    • 6009 replies
    • December 28, 2022

    If you want the time formatting in something other than minutes after it is closed, that will take a bit more work. 

    You should also be aware that TONOW() does not update on a regular basis, especially if the base is closed, so it’s value is likely to be off/inaccurate. 


    Terms & ConditionsAccessibility statement