Help

Welcome to the Airtable Community!

61836members
143856posts
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Activity

SUMIF function

Hi everyone, I'm trying to implement the following Excel SUMIF Formula: SUMIF('Tabella raggr'!B:B;T2;'Tabella raggr'!D:D) Basically I have to add up all the values in column D where the corresponding value in column B matches the value in T2.In the s...

  • 0 Views
  • 0 replies
  • 0 kudos

Share A Section Of Views?

Hi guys, I'd like to share a section of views (these 14) is there a smooth way to do this without sharing all of them individually?I don't really want to share the whole base as there are tables with sensitive info in themAny and all help appreciated...

natetable_0-1708606704566.png
  • 33 Views
  • 1 replies
  • 0 kudos

Sending Emails via Gmail distribution list

Hello, I am trying to set up an automation that is sending out all our Purchase orders as an email via a shared distribution list.I can link my account, but I do not have the option to choose the "send as" Example: me@test.com  is my account and I al...

  • 32 Views
  • 1 replies
  • 0 kudos

Assign a Month & Year based on if a date falls in period.

Hello All,I wish to create an if formula which will return a Month Year result based on if a date falls on or between two dates.For example, if date A is on or between date X and date Y then return Month YearThink along the lines of budgeting and exp...

  • 24 Views
  • 2 replies
  • 0 kudos

Resolved! layering filters in views

Is it possible to limit the filter option (tags) in one field based in the results of a filter set on another field?Example: I've created a view and shared the link. The user comes to my view and wants to filter the results displayed. Assume user wan...

  • 58 Views
  • 2 replies
  • 0 kudos

Interface Record Expanded View padding

Hi!I'm trying to remove whitespace on the sides of a full-screen expanded view of a record in my interface to make the expanded view of a record more condensed - is there any possible way to do this? I think it was a possibility in the old interface ...

  • 42 Views
  • 1 replies
  • 0 kudos

IF Formula Causing Trouble with Blank and Zero Amounts

I'm trying to build an IF Formula that seems like it would be straight-forwarded, but is proving to be more complicated than I thought it would be and has got me stumped. Both fields are Lookup fields getting a Rollup value from another table. I star...

  • 68 Views
  • 4 replies
  • 0 kudos

How to avoid multiple attachments with same file name

Dear Community,I hope someone can help me with the following issue...I have an automation sending out an email for a record ("shipment" table) with attachments. The attachment(s) come by lookup from my "inventory" table. Now, as some inventory items ...

  • 38 Views
  • 2 replies
  • 0 kudos

Automation to update record with today's date

Hi. Sorry, but I'm struggling to know how to do this. After my automation sequence, I want to update a date field with todays date to show when the automation ran. I've searched hard here, but I cannot find a way to do this. I've tried a formula in t...

  • 36 Views
  • 1 replies
  • 0 kudos

Need help with Find records action

Hello! I have 2 tables in my database:'Employee Directory' with fields: Name, Seniority, Department, and Email.'Equipment Requests' with fields: Request, Employee (linked), Department (lookup), Email (lookup), and Status.I would like to create an aut...

  • 52 Views
  • 2 replies
  • 0 kudos

Resolved! Can a form be used to enter new info for two different bases?

Hi everyone, a coworker and I are designing a new AT system to help our communications team manage content production, marketing campaigns, and individual tasks related to both content and campaigns. To solve for multiple needs and use cases, we're t...

  • 70 Views
  • 5 replies
  • 0 kudos

Preserving existing record values while updating a pay rate

I have a payroll base that tracks timesheets and commissionable transactions for our employees. It includes the following linked tables:EmployeesTimesheetsThe Employees table includes information for name, address, email, etc. Additionally, there is ...

  • 41 Views
  • 1 replies
  • 0 kudos

Add condition to formula to use column IF not Empty

Hello! I want to add something to the formula below. I want to add the condition that IF the column 'Fixed exchange rate' is not empty (there is a number filled in) THAN that number should be used BEFORE using the Forecasted exchange rate. IF the Col...

  • 49 Views
  • 1 replies
  • 0 kudos

Resolved! Automation - Less than and Greater than

For the automation above, I kept getting an error OR inaccurate output. When I would test it out and submit a 90% score, it keeps creating a record as if the score was less 89.99 

mikeeTHINK_0-1708523479070.png
  • 63 Views
  • 3 replies
  • 0 kudos

Updating field based on linked record

Hi all!I have two tables, the first is Stores, the second is Customers. They are linked. Customers has a Region single select, Stores a Region multi-select. All of the Region single selects are populated for the Customers tab. I need some help creati...

  • 92 Views
  • 5 replies
  • 0 kudos

Announcements

Introducing Expanded Support for Interfaces on Mobile

Hi all! I’m Rosalind – a product marketing manager at Airtable focused on helping teams build powerful, custom applications that make work more efficient. I’m happy to share that we have expanded the ...

Announcements

New Features and Templates for Project Management

Today we're excited to release three new features that will greatly improve Project Management workflows in Airtable. These include a new gantt layout option, date dependencies which work across views...

Announcements

Airtable Top Contributors | December 2023

Happy New Year and welcome to the December edition of our Top Contributors post! Every month, we like to give a shout-out to the rockstars in the Airtable Community who have gone the extra mile to hel...

Announcements