-
Date format issue
Hello, Currently we get format like ",,,,,,,,,,,,,,,,1" for date column type. How can we get actual date format like "yyyy-mm-dd"? Or if there is any way to convert format string ",,,,,,,,,,,,,,,,1" to datetime format?
-
Used in formula on: <unknown sheet>
Is there a way to see who the owner of the <unknown sheet> is? I'm have multiple sheets with data that is used for various metrics. I am currently looking at revamping those sheets but I have several columns that show: Used in formula on: <unknown sheet> I'd like to see who the owner of the unknown sheet is to notify them…
-
Remove ' character
Hi, I'm using make.com to make an API call to update some of our sheets, everything is working fine except for updating the Progress. I'm trying to mark it as 100% but when I send 100% via the API it goes into Smartsheet as '100% How can I get the API to not add the ' Thanks :)
-
How to import an MS EXcel sheet, with embedded links in cells?
How to import an MS EXcel sheet, with embedded links in cells?
-
directly script the Code and run in SmartSheet
This discussion was created from comments split from: Loading data from excel into Smartsheet API to an existing sheet.
-
ScriptIncl:SmartsheetIntegrationHelper-Failed
We are using ServiceNow to Smartsheet Integration and for one record is throw out an error and error code is : " ScriptIncl:SmartsheetIntegrationHelper-Failed to insert issue table record to the smartsheet sheet " What could be the reason , how I can integrate that record to smartsheet?
-
404 Error - Event data - Smartsheet API
Hi, I am attempting to get event data from the smartsheet api. First, I tried the new api documentation method which suggests a request to the event api url. Traditionally, you don't pass both a parameters variable AND parameters in the url which is being suggested in the documentation. I tried a few different ways and…
-
Timestamps only match selected date format when clicked on
Hello, I am sending data to a Smartsheet via the API. I have been following the requirements for dates to be in isoformat 8601 per the documentation without any issue for over a year. Recently however, the dates are coming in as their raw format instead of the format prescribed for the date column in the sheet itself. Only…
-
How to add Developer Tools to GOV account?
Hi, I want to add Develope Tools to a GOV account so I can than Create New App which will help me in generating a ClientID and ClientSecret. I need those to give users a log in page. I am able to create developers account for non gov account, but not for gov. Please help with steps for developers gov account. Thanks
-
Automation emails to Microsoft Teams channel are not working
We are testing sending automated Smartsheet tips and tricks email to a Teams channel, however, running into a few problems which make this functionality not useable. any hyperlinks within the texts are not clickable once posted in Teams. I have read the various communities posts and put the URL into it's own field and…