-
Toggle Hyperlinks
I have a need for a cell to hyperlink to different URL's based on whether or not the logged in SmartSheet user's email address (i.e., SmartSheet ID) is internal (i.e., works for our company - e.g., tim@ourcompany.com) or external (i.e., one of our customers - e.g., bill@clientcompany.com). Is there a way to do that via a…
-
Move row API not working
We use move row API since 12 hours ago it has stopped working
-
Auto fill information in sheet when a check box is checked in a different sheet
Hello All! I am trying to figure out how to auto fill information into my sheet, when I check a box in a different sheet. I am keeping track of different invoices and sponsorships in the original sheet. When I check a box in the column "Ad" then I want the "Organization", "Event", "Start", and "Due" columns to auto fill in…
-
cell.format currency settings
I'm able to successfully format a cell through the API and the compact format string, cell.format (https://smartsheet-platform.github.io/api-docs/#formatting,) except for cells with currency formats. I would like to see an example of the cell.format that works for submitting 123456 as the value/display value and a…
-
cut and paste / drag and drop images
When will cut and paste / drag and drop images be available (such as excel)? for quick user testing documentation and screen capture, this is very important. the need to save off every pic, name it, reload it, is not user friendly.
-
Zapier and Formulas
I'm trying to use Zapier to input formulas into a Text/Number column (which does support formulas) and it comes over as a text string: '=INDEX(PARENT(), 1) I'm using Control Center which creates new rows on a sheet via cell links, but the auto-fill function doesn't seem to work when the new rows are added here; hence…
-
How can we update multiple columns in a smartsheet at a time using smartsheet C# SDK?
How can we update multiple columns in a smartsheet at a time using smartsheet C# SDK? We can update one column using UpdateColumn() API. How to update multiple column by one method?
-
Smartsheet token - expiration time
Hi, How to expand expiration time for token without using of SDK (no APPLICATION)? - I just needed it for simple csv download & then process it via Informatica Power Center. Just execution of script/cmd like this one: curl https://api.smartsheet.com/2.0/users/me -H "Authorization: Bearer xxx" -o…
-
Webhook "Error Code: 1151 - Scope 'sheet', object id <id> was not found"
Working on implementing a basic webhook based smartsheet connector to fetch usage data for users under one organization. During the Oauth2.0 flow, requested for following scopes "READ_USERS, ADMIN_USERS, ADMIN_WEBHOOKS". I am making the following javascript-sdk api calls : - - smartsheetClient.users.listAllUsers…
-
Python Script For Refresh Sheet
Hello Smartsheet Community, I need to write a script in Python to refresh a sheet. In my sheet I am using the Today function to calculate the total net days from one specific date. I take that data and use it as a widget on my dashboard. Problem is, the widget doesn't update unless the I physically open the sheet. Is there…