cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DCTMK
New Member

Smartsheet Insert Row - Floats changing to Strings?

I'm struggling to figure out how to write a float into Smartsheet using the Insert Row connector.  When the value being input is a float, it always outputs as a string.

 

Input:

DCTMK_0-1659119205317.png

Output:

DCTMK_1-1659119273090.png

 

I've searched for a way to do this for several months, so any guidance would be greatly appreciated!

1 REPLY 1
Rhiassuring
Super User
Super User

Did you happen to review this thread? https://powerusers.microsoft.com/t5/Using-Flows/Adding-numbers-to-a-row-in-SmartSheets/td-p/733864  - it seems like SmartSheet tries to copy it across while adding an apostrophe, so the solution here was to use a formula to substitute the added '.

______________________________________________________________


Did this answer your question? Please mark it as the solution.
Did it contribute positively towards finding the final solution? Please give it a thumbs up.

I answer questions on the forum for 2-3 hours every Thursday!



Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,347)