Any help with this one please
I am seeing the same behavior. Since Smartsheet believes that's a number value, it's going to treat the space like a typo, like it doesn't exist, and enter the value as a number. To get it to not do this, you would need to make Smartsheet understand that this is text. Your options for doing that are:
Enter the value in the form with a leading apostrophe (this is the most straightforward.) Alternatively, you could try these other things.
Use a helper column to collect this number value, and:
Add a leading zero to the first number; or
Add a placeholder like an underscore or alpha character between the numbers.
On the sheet, in the GL1 column, use a SUBSTITUTE formula to replace the underscore or alpha character with a space:
=SUBSTITUTE([Helper Column]@row, "_", " ")
Or, if you went with the leading zero, modify the SUBSTITITE formula as follows:
=SUBSTITUTE([Helper Column]@row, "0", "", 1)
This tells it to replace the 0 with nothing, but only the first instance of 0 it finds, going from left to right.
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Is it also happening for the General Comments field or just GL1?
@Paul Newcome Hi Paul, just the GL1 field
thanks Jeff, is there a formula I can use to enter the leading zero or placeholder Or will I need to instruct the Form User to input these values?
Unfortunately there's not yet the ability to specify leading characters or validate that specific of a format. You can add a description under the field header on the form telling them what to do.
Use the code "%20"
=[Form Link]@row + "?" + "Name"+SUBSTITUTE(Description@row, " ", "%20")
This solution helped me by the Pro-desk.
Hello! I created two sheets with separate forms and when I checked to see if anyone had submitted the forms yet, I didn't see anything on either sheet but when I click on "manage forms" it says that there are 62 submissions for one and 18 for the other. How can I fix this so I can see what people are submitting?! Thank…
I have a Smartsheet tracker that has been tied to one report. I recently created a second report that pulls similar information from the same Smartsheet tracker and that is working fine. However, the other report no longer shows any data in it for me or others. I have verified that we have admin access on the original…
we are looking to migrate out of smartsheet and are needing to export all of our sheets out and store them in onedrive. what is the best way to preform this?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.