Hi everyone! I'm trying to tackle an issue that I'm not sure I can solve with Airtable, but hoping to alongside Zapier integrations. I want to randomize monthly meetings across our staff, volunteers, and board. Not everyone is willing to use Slack, w...
I have an automated email set up, using Gmail, for informing someone when their video is scheduled to be published. This is trigged once the publish date date field is set. I have changed the publish date date format from ISO to friendly format, but ...
Hi again! One more question from me for this base. I want to combine multiple IF statements from data in two columns. I’m working with the ‘points length’ field and the ‘total rating’ field.
I’m attaching screenshots of what I’m talking about and the...
I have a table with multiple single select columns. Each single select column generates a numerical value, through a switch formula. I want to average the numerical values for each switch formula column. When I average the columns out now, I get back...
Here’s the breakdown:
<=3, Unsatisfactory
3 and <=7, Passing
7 and <=8 and points length <40, Needs longer video
=8 and points length 30, Well documented
I read through the nested IF statements page again and tried this IF({Total rating} <=3, "Unsa...
Kristen_Tcherneshoff:
This is the formula I used to get the screenshot above: IF({Total rating} <=3, “Unsatisfactory”, IF({Total rating} <=7, “Passing”, IF({Total rating} <=9, “Well documented” ) ) )
It should receive “Needs longer video”. Sor...
