Hello experts,
I'm currently having trouble with a formula in Excel. I'm wondering if there's any way to get a timestamp without having to refresh all of the rows. So far, I've managed to put a formula in place that seems to be working perfectly, with one small issue: when I change the value in the cell, the timestamp doesn't refresh to a new one. Any advice on how to fix this would be greatly appreciated.
I'm currently having trouble with a formula in Excel. I'm wondering if there's any way to get a timestamp without having to refresh all of the rows. So far, I've managed to put a formula in place that seems to be working perfectly, with one small issue: when I change the value in the cell, the timestamp doesn't refresh to a new one. Any advice on how to fix this would be greatly appreciated.
Excel Formula:
=IF(A1<>"", IF(B1="", NOW(), B1), "")