-
Conditional Formatting - Filter odd/even numbers
Is there a way to filter and do conditional formatting for odd/even numbers used from auto-number? If not, I would like to pose this as an enhancement request.
-
Should I have a PM Lite Smartsheet? A One Pager?
This time last week, my CIO asked me to look into Smartsheet. One week later I have a beta version of a project template containing 6 sheets, 3 reports, and one dashboard. I was surprised how easy it was to develop a pretty solid solution in such short amount of time. The beta version of my project template should work for…
-
Conditional Formatting - Track Cost Fluctuation
I have a master list to track the cost of an item. Is there a way to format cells to change the font to Red or Green based on whether or not the value is higher than a previous cost? IE: In 2015 cost was $1 and in 2016 the cost rose to $2. I would want the 2016 cost to automatically turn Green to show that there was an…
-
Live Data Connector Discussions
I have been working with the Live Data Connector plugin for Tableau for a couple of weeks now and not sure if this is a bug or a new feature request. When connecting directly to a sheet I am able to pull in information about the discussion as well as the comment text itself like below: Any ideas?
-
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…
