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

Forum Posts

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”

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
  • 146 Views
  • 0 replies
  • 0 kudos

Resolved! Attachment URLS

I know I am late to the game here. I have been ignoring the updates until now. I currently have uploads and the links for the uploads through a formula - which allows me to create a download button.I use these so in the public share link to my base -...

Elizabeth_Aucti_0-1676346277967.png

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
  • 289 Views
  • 1 replies
  • 0 kudos

Utlization summary looks ''across'' multiple weeks

The Utilization Summary works differnt than I expected, and I can't figure out why.I think this image summarizes my question: In short:I have 5 working days (40 hours) per employee as ''Available hours''And my tasks are split into working days, where...

Vincent3_0-1701271471929.png
Vincent3 by 4 - Data Explorer
  • 158 Views
  • 0 replies
  • 0 kudos

Resolved! Color record based on formula field has ERROR condition

I have a formula field that calculates a value (results a number) based on a lookup field (e.g. a date). When the lookup field is empty due to a missing input, formula field results with a NaN or ERROR.In that case, I want to highlight RED color to t...

ni5ni6 by 5 - Automation Enthusiast
Solved
  • 360 Views
  • 2 replies
  • 1 kudos

Resolved! Combining different data fields into one column

Hi there,I want to have a column which displays two bits of data. Those are a cumulative $ amount and below that a cumulative % amount. I have these two lookup fields separately however need to combine them into one field column. Any help would be gr...

bartdubs by 4 - Data Explorer
Solved
  • 1027 Views
  • 9 replies
  • 2 kudos

Simple Conditional setting not working for Lookup field?

I am attempting to make a Travel Sheet my Supervisors access through a Form view, that allows the selection of Employees (linked from our Employee Table) based on their current Employment Status (which is a dropdown selection on the other table). Whe...

halffrozen by 5 - Automation Enthusiast
  • 329 Views
  • 1 replies
  • 0 kudos

Locate Completed Record

Hi, where do I find completed record when it disappeared in the table?

reign by 4 - Data Explorer
  • 315 Views
  • 1 replies
  • 1 kudos

Resolved! Prefilled Forms with Conditionally Hidden Fields - Continuous Forms

Hi Everyone!I'm relatively new to AirTable and figured this might be a question for you all! For context... I work with people who don't always reply to their emails or often miss conversations that we need their input on. Which means process get del...

bweber by 6 - Interface Innovator
Solved
  • 1722 Views
  • 4 replies
  • 0 kudos

Recreating SUMIFS and Expenses Sheet by date and category

I would like to recreate a transaction sheet and P&L sheet from Google Sheets into Airtable. In Sheets, there is a "Transactions" sheet with all of the company's expenses. The relevant columns for the P&L sheet are data, amount, category 1, subcatego...

triple_0-1689178631094.png
triple by 5 - Automation Enthusiast
  • 404 Views
  • 1 replies
  • 0 kudos

when copy formula values "HTML code"

I've HTML Code to use inside formula to insert virables inside the HTML code then export it as final HTML Code.. the problem is when i tried to copy the field it add some extra character (")...Here's the formula code:"<div style='position: fixed; top...

Karek_Rami by 5 - Automation Enthusiast
  • 466 Views
  • 1 replies
  • 0 kudos