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
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.
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