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

Forum Posts

IF this field is full use it otherwise use this field

Hi,I am creating a formula for my fixed field for a sponsor base. Not all sponsors have business names; therefore I am looking for a formula that will be something along the lines of:IF({Business Name (from Contacts)}, {Business Name (from Contacts)}...

IFconfused by 4 - Data Explorer
  • 155 Views
  • 1 replies
  • 0 kudos

Strip time from date and add a new time

(i edited this to make more sense hopefully浪)I want to create a new date and time, by stripping the time from a date, add a certain number of days, then add a duration field back as a new time to the date such as :1/3/24 11:00 am   to   1/3/24    add...

Mike_Shaw1 by 6 - Interface Innovator
  • 216 Views
  • 3 replies
  • 0 kudos

Limiting Duplicate Text in Lookup Cells

Hello-I have a lookup cell that is pulling data from multiple cells. The results are showing a list of topics. The topics are repeated (as they're pulling from different cells). You can see, for example, that "Space" is being pulled multiple times. I...

LaurenMaine by 6 - Interface Innovator
  • 414 Views
  • 5 replies
  • 0 kudos

Google Drive Folders Synced to Record

I have a table that is creating a record for each client that completes a form. I have another table on the same base which is a synced google drive table with all client folders. Is there a formula/automation I can use to link the "open in google dr...

tahsinh by 4 - Data Explorer
  • 347 Views
  • 8 replies
  • 1 kudos

Price per Square Foot

Hi! I thought a simple formula shown below would calculate price per square foot for my table. {Price} / {Building SqFt} Both Price and BuildingSqFt are columns in my table, so I am not sure why the formula gives me an ERROR response. What formula do...

Admin_LI by 5 - Automation Enthusiast
  • 173 Views
  • 2 replies
  • 0 kudos

DATETIME_FORMAT returning wrong time

I am using a DATETIME_FORMAT formula to reformat a Date input field and make it pretty. For some reason no matter what time I put in to the Date input field the formula field spits out a time exactly four hours later. Anyone know why this is happenin...

Resolved! Group by / Unique Values

Hi everyone,I am wondering if there is a workaround/solution without using make.com or scripting.I have data in one column for example. The column is a linked field.Items | Qty_to_BuyA|5A|1B|1B|1B|6C|10 I want to create a table with the following out...

aryan201215 by 4 - Data Explorer
Solved
  • 175 Views
  • 1 replies
  • 0 kudos

Resolved! Roundup results in #ERROR

Hi.I have two Date files with Time Called Start and Ende.g.:Start=08.05.2024 09:54End= 08.05.2024 12:00in another filed I'd like to calculate this into hours rounded to full 15 minutes using:IF( AND({End}, {Start}),ROUND(DATETIME_DIFF({End}, {Start},...

f0rd42 by 4 - Data Explorer
Solved
  • 125 Views
  • 2 replies
  • 0 kudos

Resolved! Create Date formula, today at hours, minutes

I want to create a formula fields equal to now() with specific hours and minutes. My formula must return a date equals to today at 18:00. Exemple today is 05/06/2024 16:12 -> 05/06/2024 18:00Thanks

GorillaDev by 4 - Data Explorer
Solved
  • 165 Views
  • 1 replies
  • 1 kudos

Formula Helper Dialogue Obstructs View of Formula Edit Field

Hi, is there an option to stop the Formula Helper dialogue box appearing when I click in the Formula edit box?The thing obstructs visibility of the formula when I'm trying to edit.   I'm having to click out of the formula edit field to close the dial...

Jason_Woodruff1_0-1714816666908.png