Cell history and Networkdays
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.
Cheers.
Answers
-
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.
-
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.
Cheers.
-
Are you and David in different time zones? Are your personal settings different time zones? Which time zone(s) are you in?
-
Both in same date and time zone - GMT+10, (MEL, Australia)
Cheers.
-
I am going to suggest reaching out to support. Unfortunately this one has me stumped.
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!