Hello All!
I’m using a formula to concatenate different dates an area was worked on as the record ID. In one tab I have all the offices and all of the associated data with them, and in the other I have a submissions page that’s linked to the office p...
Hello!
I have a table that has multiple single select fields with the options of “Complete”, “In Progress”, and “To Do.” I was wondering if there was a formula to count the number of fields with “Complete” as the selected option and turn that into a ...
Hello!
I am working with a formula that is computing a rate for each area that is being updated from a submissions tab; however, not every area has data yet, so Airtable assumes 0. This means that in the future records we get the output NaN as we are...
Hello!
I am working on a project that collects data from multiple areas (collect sequentially), and I am tracking the percent complete each area is. I want to make a pie chart that shows the percent complete of each area over the entire project. (For...
Hello!
I have a submission table that lists dates of a submission and an associated “office” to each submission. I also have an Office tab that takes all the submission data with other rollups. There can be multiple submissions a day to the same or m...
