Hello- I watched this video but it's not clear to me what happens between minute 1:00 and 1;07. https://youtu.be/ES1RyNPv_KgI am looking to create a sign-up sheet for one day in 5 minute increments between the hours of 12:00 pm - 5:00 pm, and have 4...
Hello Formula Gurus- I am trying to convert some excel formulas to airtable and struggling a bit. This is the formula in excel:=IF(J2>=8.5,"A",IF(J2>=7.5,"A-",IF(J2>=6.5,"B+",IF(J2>=5.5,"B",IF(J2>=4.5,"B-",IF(J2>=3.5,"C+",IF(J2>=2.5,"C",IF(J2>=1.5,"...
I have 5 free form data fields, none of them are required. I need to display only the ones that receive data, and exclude the blank ones. How would I create that formula?
I started from scratch (new cell and all) and it now works! Thank you so much for introducing me to the new "switch" formula.This is outside my wheelhouse, so I appreciate all your help.
This is amazing, but it is not working. It comes back with errors. Any thoughts? I reached out to someone at airtable that I worked with, but haven't heard back. ???
I must had been off a parenthesis or somehting, because I got an error earlier. THank you!BUT...now I am being asked for something slightly different.We want to grade one department under the rubic above and all others under a different rubicIf depar...
This is so helpful, Brian! One more question (possibly). I need to add a break ('\n\n') when two or more fields are returned. I can't seem to figure out where to put it without returning an error:IF( {Italian (1)}, {Italian (1)}, BLANK() )&IF( {...
