Cell history and Networkdays

Jason P

Hi

Main issue is with the networkdays formula =NETWORKDAYS(DATEONLY([Date Submitted]@row), TODAY() - 1) Originally the formula was (thanks @Paul Newcome). =NETWORKDAYS(DATEONLY([Date Submitted]@row) + IF(AND(VALUE(MID([Date Submitted]@row, 10, FIND(":", [Date Submitted]@row) - 10)) >= 3, CONTAINS("P", [Date Submitted]@row)), -1), TODAY()) but this started adding a day so reverted back.

As this is causing wrong reporting data for management and looks unprofessional. See attached example of an entry today 02/06/21 and cell data as -2 days in the sheet. When looking into (again) I came across strange data in cell history - I can not explain this as users have no reason to change this cells data and manually doing so removes the formula. - am I missing something here? - seems like Smartsheet is fighting a formula?

Regards Jason.

Paul Newcome

Is it similar for other cells within the column? It may be that it is saying a user has "edited" the cell when in all reality it is the TODAY function picking up on the sheet being activated.

Jason P

Hi Paul,

This is a difficult one. Entries are by form, date and time system generated & should anyone modify the cell the formula is removed, I can confirm the formula remains in these cells. On further investigating I found the initial -2 changed to -3 for another user - see screen shot.

David and I refreshed and saved same time however the cell for him says -3, for me -2...

Currently I'm in the office running the sheet through Google. David is working from home approx 1 Hr away and same access. It's as if were running off different system time zone clocks?

At some point the date corrects, well for me, but not David.

Paul Newcome

Are you and David in different time zones? Are your personal settings different time zones? Which time zone(s) are you in?

Jason P

Both in same date and time zone - GMT+10, (MEL, Australia)

Paul Newcome

I am going to suggest reaching out to support. Unfortunately this one has me stumped.

Jason P

Cheers.