How can I nest multiple If statements in mapping? I want to assign IDs based on name, but have not been able to get this to work. Please see screenshot for current setup
Solved! Go to Solution.
Views
Replies
Total Likes
Hi Meghan -
In your second set of IFs you have the = sign setup wrong in the formula, it's preceding your "name" and it should come after.
Hi Meghan -
In your second set of IFs you have the = sign setup wrong in the formula, it's preceding your "name" and it should come after.
To add on to what KellieGardner said, I would also recommend to not use nested if statements like this, and instead use a switch statement, so it would look like this.
switch({3.name};Sam Smith;c3a09;Jon John;62e80;HIllary Jon;6123;"")
Good point Chris.
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies