Count days

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

Count days

cpezzcpezz
edited 12/09/19 in Using Smartsheet

I'd like to track the number of days that my entries are in the same status on my grid. For example, I have 3 entries, and I'd like to track the number of days each entry is in status 1, status 2, status 3, and so on. What formula would I need to accomplish this? 

Comments

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    You would (for now) have to manually enter the dates for the changes and track that way. There is talk of timestamps for specific actions being in the works, but until then it would have to be a manual task or automated through the use of the API or a 3rd party tool such as Zapier.

  • Thanks!

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Happy to help! yes

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi,

    Zapier is a great option for this scenario. Is that an option for you?

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Thanks Andree. I was hoping you'd stumble across this. yes

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Happy to help! laugh

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.