-
API to apply conditional formatting
I am not able to find how to apply condiional formatting via API. I have various sheets that I want to update all at once and apply different conditional formatting without having to do it via the interface manually.
-
Column name/header
Feature request It would be great if I was able to format my column name/header. Specifically to wrap text so I can see the entire label for narrow columns.
-
iframe compatibility mode
Anyone got ideas on getting the published read-only iframes to work in IE's Compatibility mode? Using IE10 for an intranet site, but the Smartsheet in the iframe just continuously reloads
-
Capturing Row History Information
Is anyone capturing row history information via the API? I'm interested in knowing how best to do this in order to understand the "history of events/actions" for a row business item. Thanks, Rick
-
Live Data Connection enabled for GE account?
Is the live data connection enabled for the GE account? I've been trying to access it as described in the help guide without sucess. Regards Christopher
-
Sending notifications to a specific user for any row changes
Hi, I want to send email/mobile notifications to only the "Assigned To" person when anything (including attachments/discussions) changes for that particular row. Please think of this scenario where a particular task is assigned to a specific resource. Now any changes to that task need to be notified to only that resource…
-
duplicate values
HI I have a project for procurement products I want to make an highlight the row if the same data is available in some other sheet. Can some one help me.
-
Cell linking - finding the next empty row on another sheet
Hi, Looking for a way to link a cell in each new sheet to the 1st column of the next open row in a summary sheet. I have a template sheet and summary sheet. I would like to create a number of sheets from the template and then display some info from the sheet in one row on the summary sheet. It looks like this is commonly…
-
Dynamic hyperlink from cell to external URL stopped working
Hi guys, I have been successfully using a formula to enter a hyperlink in a cell, using, for example, syntax like this: ="http://ServerName/Default?queryStringParameter=" + [Column Name]rownum This approach enables you to use the [Column Name]rownum syntax to dynamically create the URL based on the contents of other cells.…
-
Website form integration using API
I am attempting to use the API to add comments into a new row created by a form submission. I am currently adding new rows to sheets through forms on our website that integrate with (amung other things) the Smartsheet API. Our website utilizes C# so I am using the following code (partial) to submit to a sheet. Cell[]…