7 fantastic time-saving Airtable substitution formulas - 0 views
-
IF({Collaborator},LEN({Collaborator})-LEN(SUBSTITUTE({Collaborator},",",""))+1)
-
Vernon Fowler on 13 Jul 19This can also be used to perform a word count by using a space character instead of a comma in the SUBSTITUTE({FieldName}," ","") part of the formula.
-
-
If the {Name} field contained both a first name and last name, you would replace WORD_N with 2 and the formula would return only the last name.
-
how many collaborators are assigned
-
"When you think of a substitution formula, the concept of "find and replace" likely comes to mind. In Airtable, however, you can use substitutions to perform powerful workflows. Here are seven time-saving substitution formulas that demonstrate simple and creative ways to solve many common problems."