UPDATE: Answered.Form changing a number entry to a % in the Sheet

Angela Cooper
Angela Cooper ✭✭
edited 05/26/21 in Formulas and Functions

ANSWERED - Found it from another post where RossL told someone to make sure the % sign wasn't selected for that column.

Magic solution.

Thanks RossL.

I have a form with a question asking "What % of time will be allocated to this project?"

When the answer to that question is populated in the sheet, it's coming through as a percentage - even though I don't believe I set up anything to create that. So the value should be 50, for example, but it's coming through as 5,000%.

The column properties are set to number/text.

Any thoughts?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!