I am using the switch formula to have Airtable populate a numerical value into a cell based upon the input chosen from a multiple select option. Prior to this I was typing the amounts in and it was working properly. Now I have set up the switch to populate the cell and it works and puts the correct number into the cell that the formula was pulling data from, But now I receive an error message in the end cells.
Why is this?
The cell the formula was pulling from previous has the same numerical values showing in the cells, it is just being generated by the switch formula instead of me inputting it into the cell.
Thank you for any guidance.
Solved
Using Switch formula
Best answer by Kamille_Parks11
Can you post a screenshot of your data and actually include the formula?
Also check to make sure you didn’t write numerical outputs in quotes. Wrapping numbers in quotes turns them into strings.
+27Can you post a screenshot of your data and actually include the formula?
Also check to make sure you didn’t write numerical outputs in quotes. Wrapping numbers in quotes turns them into strings.
Can you post a screenshot of your data and actually include the formula?
Also check to make sure you didn’t write numerical outputs in quotes. Wrapping numbers in quotes turns them into strings.
The quotes around the numbers was the fix. As soon as I deleted them, it pulled up the data. Thank you so much!!! You are amazing!
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.