Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

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

Formulas Activity

#ERROR using SUBSTITUTE()

Hello! I want to generate some HTML code using a Lookup function and I've been running into a weird issue. Each HTML button is defined in a table, then is combined like such in a Lookup function:<a href="/water-coaster/192/" style="text-decoration: n...

  • 25 Views
  • 1 replies
  • 0 kudos

Formula to show true/false based on attachment field

Hi there, hoping someone can assist me. I need a formula that will note true/false based on an attachment field.For further context, this will be used in another formula that combines various fields into a link which goes to a custom Typeform. The fi...

  • 39 Views
  • 0 replies
  • 1 kudos

Formula discriminates between outputs

Hi all - I'm having a very strange issue with a Formula field. I've got a Status field (single select) that informs a Formula field. i.e. if the Status field says ABC, then make the Formula field say XYZ. It's working perfectly except for two outputs...

  • 122 Views
  • 7 replies
  • 0 kudos

'If today is within (date range)' formula

Hi, I'm trying (and struggling) to create a formula that allows us to filter by 'people who are currently contracted by us'. We have a start date and end date column within the table, so ideally I'd like to add a formula that allows us to filter base...

  • 124 Views
  • 3 replies
  • 0 kudos

How to compare two field in different tables in the same base

I have two tables in the same base. Each has a field that contains a member number. However in table 1 the member number is a formula. How can I write a formula that will return a different field (member name) from the second table into a new field i...

  • 81 Views
  • 1 replies
  • 0 kudos

How to add cells in the same column to each other

Hi,I am trying to add cells together in order to find the line by line tracking.For example, in the image below, I am looking to add up the different profits in order to obtain the amount present in the bank account.Can you help me ?Thanks !

bguiraud_0-1727208702876.png
  • 121 Views
  • 4 replies
  • 0 kudos

Resolved! DATEADD WORKDAYS VALUE using a number field from a lookup

 Hey there. I came soooo close to getting a working formula for what I was trying to achieve but fell at the last hurdle.I have a date field and a number field from a lookup. I am trying to create a formula that gives me a new date based on the the d...

Screenshot 2024-09-24 at 14.43.17.png
  • 118 Views
  • 2 replies
  • 0 kudos

Formula for input or calculation depending on checkbox

{Rate (from Contract LU)}/{Frequency (from Contract LU)}Rate is a currency field and Frequency is a number field. Both reside in the Contract LU table.I have been using the above simple formula in invoicing successfully for quite a while. I recently ...

  • 78 Views
  • 1 replies
  • 0 kudos