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

Formulas Activity

Formula field for a created time field

Hi I have two fields ie a created time field and a formula field for the time field. I have an issue with time displayed in the formula field. It seems to convert the time I don't know why,, here is the formula: IF( {Posting Date} > NOW(), "Posted: T...

  • 44 Views
  • 1 replies
  • 0 kudos

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...

  • 69 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...

  • 111 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
  • 86 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...

  • 118 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

  • 126 Views
  • 2 replies
  • 0 kudos