I have a table which requires that several cells' values need to be manually updated. This causes a cascade of calculations to be triggered and results are displayed.
As each of the manually-updated cell values are entered, I would like to display (by any means) the difference between the old...
I have an inventory-type spreadsheet that inserts TODAY() in the date column whenever a new item is entered in a different column, "Item", which is handy. The problem is that every time the worksheet is opened, every cell in the "Date" column that has a corresponding "Item" get updated to...
I am making an invoice sheet which will include historical as well as current purchases.
I auto-populate the date field with the current date when a new item is entered with =IF(F3<>"",TODAY(),""), where cell F3 is a cell for a new item name.
My problem is that when I open the sheet...
I've added comments to graphs with arrows pointing to a specific data point, as for example, a point in time when some factor changed. It may offer an explanation of why the slope of a line changed.
However, as additional data is added over time, the arrow is not linked to the data point, but...