Improved integration with SQL

Hi!

I have some grumpy developers with a HUGE ask, likely impossible, but at the very least difficult. If it is easy then roll it out!

Have better cel controls where only Text is allowed, or only a real Number, or only an Advanced Number. These are things that MS-Excel cannot do, and if Smartsheet can do there would be much joy and singing and a rush to use it by the coders of the world.

Sign in to vote!

Find more posts tagged with

API and Developers

functionality

Idea Submitted

Enhancement Request

Comments

smartsheetdev.io

Hi @Seth Morth ,

I'm not sure if I understand your request correctly, but if you're pushing in the data via API to the Smartsheet than you're controlling which data goes where and in which format.

For example, if you want to push text only to the specific column than before pushing the data to the Smartsheet you can check if data type is string or integer or float. Simple IF statement solves the issue.

Also, when you get the data back from Smartsheet it actually returns displayValue and value from the cell, please see below where displayValue is a string and value will be float.

Etienne Mermillod

Hi,

currently you cannot enforce type within smartsheet, such as int, float, or only text, only char...

One possible option would be to create a helper column next to it that enfore the value , such as for int:

=IF(INT([Column6]@row) = [Column6]@row, [Column6]@row, 0)

for number :

IF(ISNUMBER([Column6]@row), [Column6]@row, 0)

and so on..

Quick Links

Trending ideas

Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
Form Upgrade to Pull In Data from Another Smartsheet Source
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…