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

Formulas Activity

Champ de recherche et formule de date

Bonjour,J'ai dans ma base un champ de recherche qui me permet de récupérer les dates de différents enregistrements liés. Parmi toutes les dates remontées, je souhaite définir quelle est la plus petite (ou la plus grande) : comment faire ?Merci pour v...

  • 61 Views
  • 1 replies
  • 0 kudos

Update an Airtable field when a Google Sheets cell is updated

Hi,I'm trying to figure out if there is a script or formula to allow for when cells are updated in a column of a Google Sheet to update a corresponding column in Airtable. Here's the scenario I have:I have a Google Sheet that is organized by client p...

  • 105 Views
  • 3 replies
  • 0 kudos

Resolved! Calculating work date differences for due dates

I'm using a simple formula to calculate the due date difference between today and the project due date:WORKDAY_DIFF(TODAY(), {Due Date})-1Which works for anything due today and in the future, but does not calculate properly for past due things. If to...

Screen Shot 2024-11-19 at 8.49.27 AM.png
  • 82 Views
  • 1 replies
  • 0 kudos

Resolved! Weighted drop down

Hi all,I want to prioritise datasets in Airtable. For that I've created checkbox fields and a drop down field.I now want to create a formular field and add there a weighted text drop down menu by giving each text option a number. For the checkbox fie...

  • 109 Views
  • 2 replies
  • 0 kudos

Remove all text after a parentheses

Can you help me with a formula to remove all characters including and after the "(" in Los Angeles (hollywood)?So my goal is to make Los Angeles (hollywood) --> Los Angeles

  • 121 Views
  • 2 replies
  • 0 kudos

Week Of Forumla

How do I write a formula to populate anything that is created in that week, it will add the Monday date of that week. For Example:I have records for 10/7, 10/8, 10/10. I need the Starting Week of to be: 10/7 for all Dates. Then I need records for 10/...

  • 71 Views
  • 1 replies
  • 0 kudos