Simple Inventory System & Report Tutorial in Google Sheets

[@Seba-gc5ss]

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 ..

[@SheetsNinja]

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: kzbin.info/www/bejne/r53Imnh9fdF-esk

[@HannaWilkins-q6y]

I keep getting an error while trying to make the report "Error Circular dependency detected. To resolve with iterative calculation, see File > Settings."

[@SheetsNinja]

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.

[@HannaWilkins-q6y]

@@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