It would be nice if the column type could be Text or Number. My Manager pulls data into PBI. Sometimes numbers show up as text when they are actually numbers.
If this is something I can do on my own, please let me know.
Thanks!
Sign in to see the current vote count, add your own vote, or leave a comment.
If the data is imported from a smartsheet, how is the data acquired in smartsheet?
It depends on exactly how the data is populated in Smartsheet.
My first thought without a deeper dive would be to insert a helper column that uses a VALUE function.
=VALUE([Column Name]@row)
to convert all rows into a numerical value.
I agree with this! Also, could allow limits on how many digits are entered into a column
As one of the system admins, it is absurd to me that I cannot view or have access to all of the items created in my organization. We have over 11,000 reports, sheets, and dashboards and I can't see them. I have no visibility to if people are using our plan for their own personal use, or what kind of work is going on unless…
Our sheets & workspaces require many people to have Admin level capabilities, which means that when someone requests access to a sheet or workspace, that email is sent to every Admin. This causes confusion and higher risk of no access granted (because people have learned to ignore the emails) or the wrong level of access…
Today you can create a form and add logic. If that logic requires that requests need to be made for X days in the future you can add logic to help. For instance is the date requirement is not met you can hide fields so that information cannot be submitted completely. You can display a banner if date requirements are not…
