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...
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...
I have a table "Performance" with device performance data of my app. The table has the following columns: user-id, device-name, fps, time-stamp Now I want to extract the devices which have "fps" below a threshold (let's say below 10), because I want ...
Hi, I have multiple Image attachments in airtable I want to show only 1st image in the pic#1 column is that possible i try few solution/formula it showing image URL ? any quick solution?
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...
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...
Hi,I have a base with a lot of records being submitted that have dates attached such as events. I want to be able to show the next 20 records coming up, keeping in mind this will change any time a new record is created with an upcoming date in the ne...
Hi, where do I find completed record when it disappeared in the table?
So I found a formula someone else made that does exactly what I need it to do. I need to display the dates of certain events as "week of" so I can group the event by the week and see how many posts are made during the week. The problem with the for...
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...
