curiouscoder
New Member
- Joined
- Jun 24, 2022
- Messages
- 31
- Office Version
- 365
- Platform
- Windows
i am unable to show/upload my excel file as im working on a work device.
the H column consists of statuses in a drop down list with each status having its own respective column that records a time stamp whenever the status is selected.
my issue is due to the =NOW() function each timestamp is dynamic and keeps updating until the next status in the drop down list is selected. as you can see the timestamps assigned for the second 2 "Assigned" statuses are the same since neither of them haven't been set to the next status as of yet.
I have provided formulas for column J and L and would really appreciate if someone could show me how the formula in each column could be adjusted to show the static =NOW() timestamp as opposed to volatile.
thank you
the H column consists of statuses in a drop down list with each status having its own respective column that records a time stamp whenever the status is selected.
my issue is due to the =NOW() function each timestamp is dynamic and keeps updating until the next status in the drop down list is selected. as you can see the timestamps assigned for the second 2 "Assigned" statuses are the same since neither of them haven't been set to the next status as of yet.
I have provided formulas for column J and L and would really appreciate if someone could show me how the formula in each column could be adjusted to show the static =NOW() timestamp as opposed to volatile.
thank you
