-
Pre Configure Report (Task list) for each Resource that will work on Project
Hi, This is probably a Feature request rather than a discussion as I do not feel that there is a way to do it at the moment, but I may be wrong. I would like to create individual reports for each of the resources U am going to use on the project. The Criteria being Assigned to (Contact Column) that resource. Problem,…
-
Using smartsheet for grant writing
I am a grant writer at a nonprofit and my development team uses smartsheet. I am at the beginning stages of using smartsheet and want to use it for EVERYTHING related to my grant writing (calendar, deadline tracker/notifier, links to emails, links to webpages, task list, grant applications, anything else you can think…
-
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.…