-
Formula that updates a cell in another column
Does anyone knowif there is a way to have a formula in one cell update a cell in another column? Currently I have a formula for a check box column (Task Complete Column) that checks the % Complete and if the task is 100% complete the check box is checked automatically. eg: (=if ([% Complete]4,1,1,0) This updates the check…
-
Is it possible to freeze and unfreeze rows like you can with columns?
Is it possible to freeze and unfreeze rows like you can with columns?
-
Sheet row display error / mismatch?
Hi, I have noticed a strange formatting / display error caused I believe when text sizes other than "auto" are used. I have a sheet with conditional formatting that depending on a date in relation to today changes the font size (from auto to 14pt) to indicate that a critical date is approaching. I have noticed that the row…
-
Construction template
Has anyone created a template for construction comparing %completed, %programed and %paid vs the date? to be able to graph it something like this
-
how to count rows under a parent and sub parent(s)
I have a sheet that is grouped by product categories. Underneath that category are products, and within/under a product are projects that are active and/or planned. So imagine the structure of the sheet is: Product category Product A Project A Project B Project C Product B Project A Project B I would like to display a…
-
Limit View within a Sheet (using Web Forms)
Hello, New to Smartsheet. We would like to utilize a web form to allow customers to place orders/requests whereby the web form would populate the smartsheet for ONLY OUR INTERNAL visibilty/tracking of all requests combined. Currently, when I test this I am brought back into the sheet where I can see ALL requests. Does…
-
Max cell limits for all customers
Are the following limits the same for all customers: * Max rows: 5000 * Max columns: 200 * Max cells: 200,000 Thanks, Rod
-
Conditional formatting for past dates dependent on other past dates
Hello, Is there a way to condtionally format dates in the past based on other dates in the past? For example, we are transitioning our project schedule from excel to smartsheet. We have dates in the past as shown below. In excel they are conditionally formatted to turn red if the Actual happened after the Current Target.…
-
Counting Characters for Twitter
Hello! I'm using a sheet to track my social media (Twitter only at this point) posts prior to adding them to Hootsuite. I'm trying to figure out a way to have a column that will incidate wheather or not a text column has too many characters (140) or not. Is this possible?? Thanks, Claire
-
Conditional Formatting Question
We use a Project Timeline Template that tracks the progress of each individual project. There are a number of parent rows with child rows beneath. I've created a status column so that each task can reflect the current progress via a harvey ball. I would like the parent rows to reflect the overall current status based on…
