-
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.
-
Formulas to calculate data received from web form
This is a screenshot of my page that I want to try and get the formulars for. The cells that are in yellow, the data in those cells will come from my staff that I have complete the web form that i have attached to this sheet. The red cells are the ones that I require the formulas for to calculate the different times that I…
-
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
-
Earned Value Management
Please how do you calculate earned value with smartsheet? I have been looking at the videos but yet to find an answer.
-
Grammar/Spell Check Request
Can I request for spell check? This hasn't been an issue (or at least not raised) and I would like to keep it that way. The Chrome browser option isn't so user-friendly; no 1-click scan or doesn't automatically show misspelled words.