BigBoiJack
New Member
- Joined
- Dec 3, 2019
- Messages
- 3
- Office Version
- 365
- 2019
- Platform
- Windows
- MacOS
I currently have a document that is shared via Onedrive to multiple other users who all use it simultaneously.
within this Spreedsheet is a simple if formula
O3=IF(K3=" ", " ",IF(K3="vacant"," ", " ",IF(K3="leave", " ", " ",IF(K3<>R3,R1,O3))))
where
K3= current status of a position (eg leave, vacant, current etc.) selected from a list
R3= the following fomula "=IF(K3=R3,R3,K3)"
R1= now()
pretty much what i want is when the status changes in cell K3 to input a time stamp into O3 unless nothing/vacant/leave is the status then delete the time stamp.
this is working fine on my spreadsheet both in excel and the web version. but once the document is shared with other users so they can also edit statuses i start getting a strange issue.
when the page is refreshed the times in cell O3 will all change by about 12 hours and i will notice the R1 cell time will change momentarily to the 12hour difference before changing back to the current time.
i am unsure what is causing this issue, formula error, or maybe a setting within excel for web?
thankyou for any help
within this Spreedsheet is a simple if formula
O3=IF(K3=" ", " ",IF(K3="vacant"," ", " ",IF(K3="leave", " ", " ",IF(K3<>R3,R1,O3))))
where
K3= current status of a position (eg leave, vacant, current etc.) selected from a list
R3= the following fomula "=IF(K3=R3,R3,K3)"
R1= now()
pretty much what i want is when the status changes in cell K3 to input a time stamp into O3 unless nothing/vacant/leave is the status then delete the time stamp.
this is working fine on my spreadsheet both in excel and the web version. but once the document is shared with other users so they can also edit statuses i start getting a strange issue.
when the page is refreshed the times in cell O3 will all change by about 12 hours and i will notice the R1 cell time will change momentarily to the 12hour difference before changing back to the current time.
i am unsure what is causing this issue, formula error, or maybe a setting within excel for web?
thankyou for any help