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

Forum Posts

DATETIME_DIFF is killing me...

Problem formula: DATETIME_DIFF({Task Due}, TODAY(), 'hours') Short Version: It's currently 5pm Pacific. The Task Due is due tonight at 12:00am Pacific. DATETIME_DIFF reflects -24. Why is this hours calculation reflecting 24 hours instead of 7? Long V...

larae by 4 - Data Explorer
  • 283 Views
  • 4 replies
  • 2 kudos

Salesforce record link

Hi everyone,Everything works fine, but I would like to have a button that redirects me to the salesforce record when clicked.The JIRA integration has something similar.Has anyone found how to do this?

kerryball by 4 - Data Explorer
  • 174 Views
  • 1 replies
  • 0 kudos

Formula to find date of specific day prior to designated date.

I am trying to figure out the formula to populate the date of a specific day in relation to a designated date.Below are some examples of what I mean.I have a date field titled EVENT DATE. I want the column titled PAYMENT DUE to populate the date of f...

How to show most recent entry in group of numbers

Ok, I have been trying to do this for a while on my own with no luck.I have a list of serial numbers. These serial numbers have more than one entry. I group the view by serial number so I can see all entries for any particular serial number. What I w...

Rich_Nuzzi_0-1674682858384.png
Rich_Nuzzi by 5 - Automation Enthusiast
  • 1226 Views
  • 4 replies
  • 1 kudos

Resolved! Different timezone with automation from google sheet to AT

Hi guys!I'm using Ubiqod for attendance tracking in our company. When you scan code, you click on the correct button (arrival, break, going home). After you submit it, the data comes to google sheet and with automation it gets to the Airtable. Now th...

SpelaU_0-1715776296498.png SpelaU_1-1715776335812.png
SpelaU by 7 - App Architect
Solved
  • 482 Views
  • 4 replies
  • 3 kudos

Formula similar to WORKDAY but working backward from a due date

I receive a due date and have to calculate backward to identify different milestones in our projects. What formula(s) do I need to use to make this work? I've attached a picture of what I'm trying to do.  Thanks in advance for the help!

Branden by 5 - Automation Enthusiast
  • 257 Views
  • 1 replies
  • 0 kudos

Formula to calculate age on next birthday

I have a base with information about students in a music program, including their birthdates (MM/DD/YYYY). I have a formula that calculates their age as of today:DATETIME_DIFF(TODAY(), {Birthdate}, 'years') and a formula that calculates the number of...

Auto populate field from multiple columns

Hi,I cant for the life of me find a formula to I have 3 date columns in each record, only one of these will be populated per record, i want to create an additional single column which would auto populate with the date from either of these 3 fields so...

5arahlou by 4 - Data Explorer
  • 227 Views
  • 1 replies
  • 0 kudos

Resolved! Combine multiple lookup date fields

Hi,I have a series of lookup fields that return multiple dates.  I'd like to combine those fields into one, listing all of the dates returned in M/D/YYYY.  I've messed with datetime_parse and format with a concatenate, but the formatting is either no...

Nicole_N by 5 - Automation Enthusiast
Solved
  • 402 Views
  • 3 replies
  • 1 kudos