You can't reset the default size across the entire spreadsheet, but you can do Ctrl+A to select all the cells in a tab and reset the size for all the cells in that tab. However, you CAN change default font and colors like this: ua-cam.com/video/yleiEGHlKDg/v-deo.html
Data is not reporting in other months on the inventory report tab. Downloaded your sheet and can not get data to show past Jan 2025. I even changed dates on Inventory Log to reflect data in Feb.
So the formulas will show a blank for future months, for example, take a look at this one: =IF(today()>F$5,sumifs(INVENTORY_LOG!$D:$D,INVENTORY_LOG!$A:$A,">="&F$5,INVENTORY_LOG!$A:$A,"="&F$5,INVENTORY_LOG!$A:$A,"
@@SheetsNinja Ok, thank you. I will try that. I also noticed that when I update the year to 2025 on Inventory Report and Inventory Log the data is not transferring over, it is only working for Jan. What would I need to do to update the formulas in the rest of the sheet?
I keep getting an error while trying to make the report "Error Circular dependency detected. To resolve with iterative calculation, see File > Settings."
This means somewhere you have a formula referring to another formula referring back to it. Whatever formula you're adding when you get this error, you'll want to check the cells referenced in the formula to see what cells they reference. Usually what it is in this kind of case is you need somewhere to actually set the initial inventory and then you can add/subtract from there.
how come i cant set another default format qua font and color and size.. why every other box keeps resetting to ex. veranda , size 10 ..
You can't reset the default size across the entire spreadsheet, but you can do Ctrl+A to select all the cells in a tab and reset the size for all the cells in that tab. However, you CAN change default font and colors like this: ua-cam.com/video/yleiEGHlKDg/v-deo.html
Data is not reporting in other months on the inventory report tab. Downloaded your sheet and can not get data to show past Jan 2025. I even changed dates on Inventory Log to reflect data in Feb.
So the formulas will show a blank for future months, for example, take a look at this one:
=IF(today()>F$5,sumifs(INVENTORY_LOG!$D:$D,INVENTORY_LOG!$A:$A,">="&F$5,INVENTORY_LOG!$A:$A,"="&F$5,INVENTORY_LOG!$A:$A,"
@@SheetsNinja Ok, thank you. I will try that. I also noticed that when I update the year to 2025 on Inventory Report and Inventory Log the data is not transferring over, it is only working for Jan. What would I need to do to update the formulas in the rest of the sheet?
I keep getting an error while trying to make the report
"Error
Circular dependency detected. To resolve with iterative calculation, see File > Settings."
This means somewhere you have a formula referring to another formula referring back to it.
Whatever formula you're adding when you get this error, you'll want to check the cells referenced in the formula to see what cells they reference.
Usually what it is in this kind of case is you need somewhere to actually set the initial inventory and then you can add/subtract from there.
@@SheetsNinja Okay I fixed that but now when I made the report, it's 0's all across. for some reason it's not pulling the data from the log