ColA has 3 different transaction numbers.
The first always starts with TEX followed by numbers.
The second is always just numbers.
The third is always blank.
I need a formula that will look at ColA
If ColA has TEX, in ColB put Text Me
If ColA does no...
I have a tab that is used to register partner leads.
It has a column that links to my partner tab, specifically a view that only shows the partner’s names.
I have created a form where the partner fills it out, finds their partner name and adds it t...
share.getcloudapp.com – 22 May 20
Screen Recording 2020-05-22 at 08.54 AM.gif
Shared with CloudApp
We have an airtable set up to list the podcasts we are sponsoring. We have the main scheduling ...
Column #1
{Need Hotel?}
Yes or No
Column #2
{Hotel Cost (Estimate)}
{Estimated # Staff} * 250 * {Duration (Days) (Do Not Edit)}
What I need is to change the column in #2 so that If {Need Hotel?} = Yes, then Do {Estimated # Staff} * 250 * {Duration (D...
I need to create a formula that does this:
Attendee Count < 100 put in 1
Attendee Count > 201 < 1000 put in 2
Attendee Count > 1001 < 5000 put in 3
Attendee Count > 5001 put in 4
Thank you @JonathanBowen and @ScottWorld. I’m not sure either of these gets me to where I need to be.
This is our main table. (Podcasts Sponsoring)
share.getcloudapp.com – 25 May 20
Image 2020-05-25 at 7.50.28 AM.png
Sha...
