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

Formulas Activity

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? 

  • 29 Views
  • 0 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...

  • 65 Views
  • 2 replies
  • 0 kudos

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

  • 41 Views
  • 2 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...

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

  • 85 Views
  • 2 replies
  • 0 kudos

Resolved! Switch with numerical operator?

I have a score card with a computed percentage grade (e.g., 84) that I want to turn into an easy letter grade for my stakeholders.Rather than using a huge nested IF formula I thought I'd try to use SWITCH to compare and create some values.SWITCH( {%...

Screenshot 2024-04-29 at 10.25.59.png
  • 95 Views
  • 2 replies
  • 0 kudos

Setting Up a Counter System for Vertical Hierarchy in Airtable

I’m working on a project management system in Airtable, and I need to set up a counter system to assign unique numbers to tasks within a vertical hierarchy. The goal is to create a structured numbering system that reflects the task relationships and ...

  • 114 Views
  • 1 replies
  • 0 kudos