Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Jan 13, 2022 06:21 AM
In Google Sheets, I’m experimenting with making a Sheet to log blood test results.
Due to complexity of views, I can imagine using an Airtable Table eg. to group test types - eg. there are a number of White Blood Cell test types.
But how else / how well could this translate to Airtable?
Each thing tested for has a normal range, defined by two column cells containing the lower and upper thresholds, accordingly. This allows me to use Conditional Formatting to shade the cell background cell green/red if the reading is out of range. What can I do with Airtable here?
Indeed, do I have the axes the right way around? Am I better off recording each test (eg. Nov 6, 2021) as a record, with numerous horizontal fields for each thing tested for?
Any charting opportunities in any of this?
Thanks.
Jan 13, 2022 06:30 AM