-
Sight - Report Widget
Hi All, I have a report with list of names in one of the column, I have linked the names to their respective sheets, the link shows in the report and works fine but when I pull this report in Sight thru Report Widget, link disappears. Edit Interaction in Configure Report Widget can link to only a single sheet , multiple…
-
Is there a way to build a template containing multiple sheets
What I'm trying to do (maybe there is a better way) is to build a project template with contains the project sheet, a requirements sheet, and a budget sheet. When we "use" the template, it then creates all three sheets. Similar to the "Solutions" on the Smartsheet website. Thanks in advance for any help.
-
Feature Request - Pattern Overlay on Gantt bars
It'd be handy to be able to add a pattern overlay to Gantt bars. Like these: http://www.webdesigndev.com/wp-content/uploads/2015/02/20-Repeatable-Pixel-Patterns.jpg The use case for us is that we want to color code our bars for who the'yre assigned to, but be able to label some of those bars as having a "fuzzy" deliverable…
-
[SOLVED]How to count the amount of children of a parent?
Greetings, and thank you in advance for helping a beginner at Smartsheet out. so thanks to the formel ="<PARENTNAME> [" + (COUNT(CHILDREN())) + "]" I managed to count the amount of children a parent has in the parent row. However now I would like to use that number(the amount of children) in a summary, but I just don't…
-
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