Skip to main content

Using formula field in time tracker

Y

I’d like to calculate duration by due date and current time like DATETIME_DIFF(Date, NOW()) and refer it from time tracker. However, this field is not selectable in time tracker. Of cource i configured format type to duration.
Does anyone know how to use formula in time tracker?

    3 replies

    E

    The Time Tracker block measures the duration and sets it in a Duration field, and optionally fill the Start Date (and Time).

    You can’t use the block to calculate time from now to due date, the formula you typed already does that :thinking: . You can’t use that field in the Time Tracker because it is not a Duration type field, it’s a Formula type.

    Y
    • Yuku_Kotani
    • Author
    • New Participant
    • 1 reply
    • February 26, 2019
    Elias_Gomez_Sai wrote:

    The Time Tracker block measures the duration and sets it in a Duration field, and optionally fill the Start Date (and Time).

    You can’t use the block to calculate time from now to due date, the formula you typed already does that :thinking: . You can’t use that field in the Time Tracker because it is not a Duration type field, it’s a Formula type.


    Oh i see. I misunderstood that time tracker is something like reminder.
    Thank you for answering!

    E
    Yuku_Kotani wrote:

    Oh i see. I misunderstood that time tracker is something like reminder.
    Thank you for answering!


    Check this for reminders:

    Reply


    Most helpful members this week

    Terms & Conditions