-
Downloading multiple files shows wrong file timestamp (7 hours in the future)
Downloading a single attachment from Smartsheet shows the correct file timestamp. But, downloading multiple files shows the File Modified date of 7 hours in the FUTURE. Another time, it was 5 hours in the future. The attachments were PDF's. This is on a Win7 environment. The data itself looks fine (inside the documents).…
-
Prepopulate a webform - Automatic Submit
I'm able to populate all the fields in my Webform by including the field details in the URL, Is there a way I can automatically submit this webform ? I'm trying to get data from a 3rd party package across to smartsheets without having to dig too deep into the API side of things. Thanks in advance.
-
Add formula to column without changing last modified date
I would like to calculate the number of days an item has aged. We don't currently use a "closed" date field, but rely on last modified. =IF(Responsible1 = "Closed", NETDAYS(Created1, Modified1), NETDAYS(Created1, TODAY())) Is there any way to add a formula to a column without triggering the last modified system field to…
-
Adding the business tools
Why couldn't I add business tools? Do we have to buy each? Or do I have to work with my administrator?
-
Refresh automatically expands collapsed rows
Has anyone noticed a recent change that automatically expands collapsed rows when a sheet is refreshed? Thanks, Joe
-
Create an Entry on a worksheet based on the value of another worksheet
Problem Statement: We have one sheet (we will call it, Sheet A) which records the joiners/leavers for our company. In order to track whether the leaver employee returns his/her equipment, I wanted to create an entry with data from Sheet A on another sheet (Sheet B) based on two sets of criteria from Sheet A, Type (leaver)…
-
How to show the actual person who added information to a sheet
In smartsheet, you have the Created By and Modified By autonumber system properties. If you have created a web form, any responses provided via the web form reflect "web-form@smartsheet.com" in those columns. Is it possible to get the actual persons email who submitted the information via the web form reflected there…
-
background colors in Sights
IS there a way to change the background color for a widget in Sights. Currently is only changes the background on the text and not the entire cell.
-
When will the API get some attention?
I'm using the smartsheet library, and it works pretty well, except that checkboxes always return None, no matter the value. I submitted a bug to the repo on github, and linked it to some other folks that noted the same problem on StackOverflow. For the tool I'm trying to build, I really need that feature to work, or at…
-
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.
