I’m trying to make an Airtable spreadsheet/database for investment properties that my husband and I own. One of the data sets I want to collect is the amount of taxes we paid since purchasing each property (for each year of ownership, there should be an amount we paid in County taxes and an amount we paid in City taxes. The columns which pertain to property taxes are named as follows: (2017 Tax Paid to County; 2017 Tax Paid to City; 2018 Tax Paid to County; 2018 Tax Paid to City; 2019 Tax Paid to County; 2019 Tax Paid to City)

Clearly, properties we acquired in 2017 will have data in every column (2017 Tax Paid to County; 2017 Tax Paid to City; 2018 Tax Paid to County; 2018 Tax Paid to City; 2019 Tax Paid to County; 2019 Tax Paid to City). Properties we acquired in 2019 won’t have data for 2017 County, 2017 City, 2018 County or 2018 City. I would like to be able to indicate or somehow delineate a cell that is empty because it still needs review vs a cell that is blank because it has no corresponding data. In other words, I’d like to be able to look at the spreadsheet and immediately recognize which cells need my attention (need data). I don’t want to see a blank cell under 2018 Tax Paid to County and then spend time factoring in the purchase year in order to determine if this is an intentionally blank cell or one that needs tending to.

For example, if a home was purchased in 2019, it would be great if there were a way to automatically “grey out” or visually communicate that the related cells are empty by design. They have been completed, even if there sin’t a f 2019 is entered as the year, please automatically make the cells relating to 2018 & 2017 incapable of receiving data (or highlight them in some way to that I automatically know not to gather unnecessary data). In other words, I would like to be able to look at the spreadsheet and know that blank cells represent work that remains to be done (rather than cells that are complete but without data).

Does that make sense?