Fomula Help please

Hello, reaching out to ask help on what formula can I use to pull the number for a certain category that is in a dropdown list in the spreadsheet?

Or do I need to create a separate column for each category that I want to show in a graph in the app?

Thank you!

Would probably need to see screenshots to have a better understanding, but if you have a table that lists each category in one column, and it’s associated number in another column, then you can create a relation and lookup column to retrieve that number.

Or another solution could be to use an IF column to return the correct number for each category.

1 Like