number of days between one state and another (not including weekends)

Carla_Ahzul

I need to include a column that shows me the number of days that a person maintains each state (not including weekends), if you don't enter the form every day to update the information. Could someone help me with this?

date of creation| Name     | Status    | DAYS WITH THAT STATUS

 03/03/2018        | cristian    | busy         | 1

 02/27/2018        | cristian    | available  | 4

 02/26/2018        | cristian    | busy         | 1

 02/26/2018        | Carolina  | available   | 5

Shaine Greenwood

Hi Carla,

There currently isn't a way to perform calculations on the last time a specific cell was edited, but you can do a few things to get visibility.

You might consider using highlight changes to show everything that has been changed within a certain amount of time. In turn, what cells haven't been changed won't be highlighted (which gives you insight into who hasn't updated a status). More info on this here: https://help.smartsheet.com/articles/521974-highlight-changes-made-to-a-sheet

Otherwise, you could track the number of days between the current date and the last change made to any cell in the row. To do this, create a date (modified) column in your sheet. (More info on this and other system columns is available here: https://help.smartsheet.com/articles/1964567-system-columns). Then, create a Text/Number column in your sheet and create a NETWORKDAYS formula in that Text/Number column. This will only count M-F between the two dates.

An example of this is as follows:

=NETWORKDAYS([Date Modified]1, TODAY())

More on NETWORKDAYS here: https://help.smartsheet.com/function/networkdays