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

Formulas Activity

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

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

  • 134 Views
  • 4 replies
  • 0 kudos

Individual fields/topics to repeat

Hi, we track which topics will be posted to social media mainly in calendar view in Airtable. Ex. Have "receipe" show up every Wednesday on the calendar instead of having to input the date manually. Any suggestion on how to accomplish that? 

  • 179 Views
  • 1 replies
  • 0 kudos

Resolved! Taking Text from One Field and Altering it in Another Field

Hi there— Grateful for your help in figuring this out.I have a single select dropdown field in one cell. If a user selects an option in that dropdown field, I'd like the cell next to it to replace the text based on whatever is selected. So in the scr...

  • 108 Views
  • 2 replies
  • 0 kudos

Resolved! Automatic duration calculator

I want to have a select field with a couple of options for clients that need a subscription. Like: "1 month subscription", "2 month subscription", ... . This would ideally convert the answer into a 31 day duration field that can then be used in a dat...

  • 95 Views
  • 3 replies
  • 0 kudos

Resolved! Formula cell maodifies text

Hi! I'm having trouble with a formula where it brings back text and adds " " when it is done. Here is the layout:Column 1: Formula cell with the following formula {Client} & ' - ' & {Total Volume}Column 2: Linked to another table, displays {Client} n...

  • 110 Views
  • 2 replies
  • 0 kudos
ARiios by 5 - Automation Enthusiast
Solved

Exclude Duplicate/Repeating Values via Lookup or Rollup

Hi everyone! I have an Airtable base for a virtual event my team is planning for Learning at Work Week. The base includes the following:An "Activities" table with all of the activities that learners can complete, each worth a certain point value. The...

  • 131 Views
  • 2 replies
  • 0 kudos