The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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...