Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

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

Forum Posts

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
  • 775 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 6 - Interface Innovator
Solved
  • 1089 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 6 - Interface Innovator
Solved
  • 1904 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”

rullagaddimath by 5 - Automation Enthusiast
Solved
  • 1203 Views
  • 3 replies
  • 3 kudos

formula to calculate events dated last week

Hi everyone,I'm trying to create a formula field to calculate last week.I have a view that shows me the events that refer to last week, I added a formula field to calculate all the events that have the "Date" field dated to last week, but it doesn't ...

Eugenia by 4 - Data Explorer
  • 772 Views
  • 1 replies
  • 0 kudos