Help with tracking dates

Hi,

I have a drop down 'Action Owner' column in a sheet and I need to track the number of days the action has been on that team. The column could be changed to a team such as Engineering more than once.

Could anyone advise me on the best method for recording this data?

Thanks!

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You would need to set up a record a date automation triggered when the Action Owner changes and then in another column use a formula to subtract the recorded date from TODAY().

  • WillH
    WillH ✭✭

    Thanks Paul.

    I didn't explain what I need that well, I will try and explain better.

    Say the AO is on Materials and has been for 10 days, the AO then changes to Engineering. I need it to record the 10 days in a Material Days column.

    It could then be on Engineering for 10 days, and could change back to Materials again. The 10 days would then need to be recorded in Engineering Days column.

    If it were on Materials for 10 days again I would need it to add the 10 days on to the existing 10 days in the Material Days column making it 20.

    Basically, I need to track the number of days each part spends under each department.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    This is possible. I have done it before, but I am struggling to explain it here. Give me a little time to review my existing solution and put together some screenshots, and I will get back to you.

  • WillH
    WillH ✭✭

    Thank you, I appreciate your help!

  • WillH
    WillH ✭✭

    Hi @Paul Newcome, just wondering if you managed to get those screenshots? :)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!