Help
Formulas
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Help with Scripting to Add Totals by Commercial and Year in Airtable

Hello Airtable community,I am working on a project where I need to automate some financial reports in Airtable and I would like to ask for your help to solve a specific challenge related to conditional sums in several tables.Context:I have a base wit...

Ramagu by 5 - Automation Enthusiast
  • 96 Views
  • 3 replies
  • 0 kudos

Resolved! Count unique values in a column

I have a grid view with a field that shows volunteers that have volunteered along with the date they volunteeredI want to figure out how many volunteers volunteered each month - how do I find how many unique volunteer names appear in this list, and i...

Lisa_Wetherby_0-1712696136417.png
Lisa_Wetherby by 5 - Automation Enthusiast
Solved
  • 207 Views
  • 4 replies
  • 5 kudos

Hardest Problem I've Ever Encountered

Okay guys, got a doozie... Basically, in the screenshot I have a table, which is the main table that 99% of things sprout off from. We have customers, who through a webflow form are able to select accessories to add on to their purchase. That gets re...

GolfCartsUSA by 5 - Automation Enthusiast
  • 296 Views
  • 8 replies
  • 0 kudos

Having birthdays show up on a calendar view in Airtable

I have a field where people can enter a birthdate. I want that to show up on a calendar view in Airtable. Unless the year is the current year, it's not showing up on the calendar. I tried using a formula field but then I can't get the formula field t...

akidz2 by 4 - Data Explorer
  • 235 Views
  • 2 replies
  • 0 kudos

Resolved! Reformatting Rollup Date Range

I have a rollup cell that is pulling a range of data from another sheet.  Is there a way to:1) Format these so it's easier to read : MM/DD/YY-MM/DD/YY 2) Format these so I can create a calendar view that would show these dates in a row on the calenda...

LaurenMaine by 5 - Automation Enthusiast
Solved
  • 429 Views
  • 2 replies
  • 1 kudos

Resolved! Consolidating Lookup Results

Apologies in advance if this was answered elsewhere, I did try to find it.I have a lookup cell that is pulling information from another sheet.  In that other sheet, the cells all share an attribute called “Daily Flow.” I’m wondering if there’s a way ...

LaurenMaine by 5 - Automation Enthusiast
Solved
  • 554 Views
  • 5 replies
  • 1 kudos

Separating multiple data entries in field

Hey,I imported my contact database into a table and am trying to separate these years so that "2019; 2020" would turn into multiple datapoints that can be filtered accordingly like "2019, "2020" etc. Is there any easy way to do this? Thanks!

Screenshot 2024-02-26 164505.png

Combining fields in table into formula

Can someone assist me with writing this formula? I'd like to basically have a column in which the staff or faculty nominee column is combined with the value. For example: Cameron, Ali - Innovative SpiritI'm running into an issue were if the staff col...

Resolved! Table for Long Text field

Can I add a table to “long text” field?I want to add table that include columns " code - description - price" example:code - description - price“1167 - bike tire - 75”