This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Help
Formulas
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Formulas Activity

Create a Post

If Formula for naming Client

Good day all. I am trying to create a formula to name my Clients based on the following: If {company} is not blank, use {company} and if {company} is blank use {last name}, {first name} - and if there is a spouse name use {last name}, {first name} & ...

  • 16 Views
  • 0 replies
  • 0 kudos

Formula If client is married, primary field will show spouses name.

I have the primary field set as a formula right now as CONCATENATE({Client Last Name},', ', {Client First Name}). I want the formula to include the spouses name after the client's name if the marital status (separate field) is married. What would be ...

  • 25 Views
  • 1 replies
  • 0 kudos

Count Items Based on Color-Code Option in Multi-Select

Hello!I have a list of names under a multi-select. Everyone in Blue is a FT staff member, everyone in yellow is a contracted worker. I want a count field (or formula field) that will automatically count all the Blue multiple select to give me the tot...

  • 88 Views
  • 6 replies
  • 0 kudos

Need help regarding advanced formula usage

Hello there,I am trying to create a formula that calculates the total cost of items based on their quantity and unit price; while also factoring in a discount percentage if applicable. I have tried using nested IF statements; but I am running into so...

  • 73 Views
  • 2 replies
  • 0 kudos

Insert a space before a capital letter

Hi I have a file name / string of texte.g. 'ThisIsTheFileName'I would like to insert a space before each capital letter. Is there a formula to do this?Thanks 

  • 73 Views
  • 1 replies
  • 0 kudos

Auto-allocate 100% across multiple projects

Hey all! I am trying to set up a form that is being sent out to about 200 people for the purpose of tracking time allocation for employees. To do so, the employees will fill out a form at the end of the week, selecting the projects they worked on thr...

  • 169 Views
  • 1 replies
  • 0 kudos

Resolved! How can i get info from a Linked Record through a Formula

I have 4 Tables (Payments, Receivables, CostCenters, Extract)The Payments and Receivables records are linked to CostCenters records.The Extract records are linked to Payments ou Receivables records ("If it's a receipt, it will be associated with an a...

  • 73 Views
  • 1 replies
  • 0 kudos

Resolved! IF statements with numbers and time

Hi everybody,if I can ask for help with formulas in IF statementsI have developed Glide app with Airtable, works really good.I have a table WorkOrders, and among other columns, I have:"Start time", "Start kilometers", "End Time", "End kilometers", "T...

  • 112 Views
  • 3 replies
  • 0 kudos

Resolved! Restringir fecha before today

Hi, I am doing a form for a remiders request, and I need that the filed "fecha de envio" the person is requesting the reminder have not the option to select a day before Today (current day).

  • 224 Views
  • 3 replies
  • 0 kudos
Load more
Airtable Community Guidelines
Looking for tips before asking a question? Make sure to review our Airtable Community Guidelines for best practices.
Labels
Copyright © 2024 Khoros, LLC