Is there a way to increment the value of a cell by one using ‘switch if’? I’m trying to make a table that automatically assigns a score to each row depending on multiple factors across columns. Here are the specifics:
The purpose of the table is to track the value of SEO keywords based on multiple factors (inspired by Ubersuggest’s ranking system)
Each keyword gets its own row
The fields for each column are: keyword, search volume, cost per click, paid difficulty, SEO difficulty usage, notes, and score
Every time a value of ‘true’ is returned on one of the following conditions, I want to add 1 to the value of that row’s ‘score’:
Switchif() is not going to work in this situation - it stops executing when it gets to the first expression that results in true.
I would suggest to use runActions() to evaluate each of those expression in series. If the If() expression is true, add one to a column that you use as a counter.
The formula in “score” is very simple: thisRow.[SEO Difficulty <40]+thisRow.[Paid Difficulty <40]+thisRow.[Cost per Click >0]+thisRow.[Cost per Click > 5]
This is probably not how I would organize my data, but with the limited knowledge of your project this might work for you.
Greetings, Joost