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

Formulas Activity

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

  • 62 Views
  • 3 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? 

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

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

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

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

  • 98 Views
  • 2 replies
  • 0 kudos