Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Is there anyway to use elapsed time in Lags like durations?

Bob Larson
edited 12/09/19 in Archived 2015 Posts

Such as paint cure times etc.

Comments

  • Zack S
    Zack S Employee

    Hello Bob, 

     

    Currently there isn't a way have elapsed time in lag days, but I'll note your idea for this option in our enhancement request list for our Product Team. 

     

    -Zack

  • Bob, 

     

    This exact scenario can be solved using Azuqua, an integration partner of Smartsheet. I work for Azuqua and we have the ability to log a timestamp for the start of an event and then log a timestamp for the end of the event and using a formula calculate the exact duration of the task. 

     

    In your particular instance if you used two columns, both checkes, to indicate the start and finish of the paint cure times using Azuqua you can set up a monitor for those two events and when each even happens it will log the exact timestamp of the action and the result of both start and end will provide you with duration. 

     

    If you want to learn more please visit our app listing at Smartsheet here:

    https://www.smartsheet.com/apps/azuqua

     

    Please feel free to follow up with me with any questions or would like to learn more.


    -Patrick

This discussion has been closed.