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

Formulas Activity

IF formula that pulls only part of the text from a field

Hello! I need to create a formula that pulls records from fields that correspond to answers of multiple-choice questions, like "What language do you speak"? Our multiple-choice questions also have an "Other" field. "Other" fields hold records which a...

  • 246 Views
  • 1 replies
  • 0 kudos

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

  • 260 Views
  • 1 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 ...

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

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

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

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

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

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

  • 114 Views
  • 3 replies
  • 0 kudos