Hello all. So I have been using Airtable since Christmas and it is really the answer to most of what I need and I am already excited about the functionality of Airtable and how it is going to help us.
Quick back story - I work for an advertising agency as a Video Editor and I am using Airtable to create a database to monitor a number of things, including the projects we are working on, which hard drive they are on and how big the projects are (amongst many other features I have found on Airtable). So far what I have is one database, which has a table which monitors the projects - location, size, external links, etc - and another table which monitors the hard drives we use - so this records the data capacity, how much is used/available etc.
I found a really helpful article to help me calculate the data available on each drive here (Forumla to add Hard Drive sizes) and it works perfectly in giving me the data on how much space is on each drive. In short, this formula helps to calculate the drive space and manages to convert all of the data types such as MBs, GBs and TBs, which is really helpful.
As part of my job I need to predict how much space we will need in order to buy more drives as jobs come in, so it would be great to have some sort of dashboard view of how much space we currently use of our capacity and how much is available compared to that. I have tried a couple of tutorials where you make a rollup or formula to calculate the sum total of one column, but none seem to work. I would imagine the above tutorial with converting the file types, could be why the rollups or formula’s aren’t working to give me correct value (usually coming back as 0).
Does anyone know of a way that I can calculate the total of three things individually; Total Capacity of the drives (from one column), Total Used Capacity of the drives (from one column) and the Total Available Capacity of the drives (from one column)? I feel like I have hit a brick wall a bit and I am swimming in the deep end of a world that I know very little about.
If there is anyone that knows of a workaround or technique I would be truly grateful.