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.
