Help

Using Switch formula

Topic Labels: Formulas
Solved
Jump to Solution
747 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Chattanooga_Fun
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

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.

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus

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!