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

Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
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…
Sheet Icon Color Consistency
The 'Sheet' icon appears purple in the left navigation but blue within the sheet, creating inconsistency. Aligning icon colors across the platform would improve clarity and simplify user training. Please standardize the icon color to enhance user experience and reduce confusion during onboarding.