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

Formulas Activity

Recreate If statement from excel

Hello everyoneI'm NawafI have a long nested if statement that i used to use in excel but I can't figure out how to use it in airtable the idea is i have 3 columns first ( permit status ) second is ( remark ) when the conditions meet, I want the third...

  • 60 Views
  • 1 replies
  • 0 kudos

Resolved! Find the maximum of three date fields including time stamp

I found this formula in the community. However I want to include a timestamp aswell. Since {date 1}, {date 2}, {date 3} may occur on the same day. I tried adding a format specifier but it wont work... The formula sets the time to a default 12:00am in...

  • 78 Views
  • 1 replies
  • 1 kudos

Attachment through Formula

Probably no way of doing this without an Automation right?I'd just like to have an image for my records based on a single select field. Essentially a Single Select field for images! I want to be able to assign a Logo for each record. Then on an inter...

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

  • 76 Views
  • 1 replies
  • 0 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!

  • 90 Views
  • 1 replies
  • 0 kudos