Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Good Day All:
Is their a way to add a condition for summary task? For example, the condition would be to bold the Task Column if the Task is a Parent / Summary Task.
Thanks
You would have to mark the Parent Row somehow... In our workflow we have a template section of tasks for each project that includes content in the parent row that is distinguishable from the rest of the sub-rows. There is a lot of discussion how to accomplish this with a formula, but we do it manually. We add Project to a the parent row in a unique column to indicate the parent row. Then we apply conditional formatting to any row where Project is in that column. Not pretty and smart, but it gets the job done.
I use a helper column for that. I then shove it all the way over tho the right of the sheet, shrink the width to the minimum, set the background and font to white, and lock it. (Don't "Wrap Text" for this column). Then I enter the following:
=IF(COUNT(CHILDREN([Column Name]@row)) > 0, ".", "")
What this does is if the count of the children is greater than 0, it will put a . in the cell. Otherwise it leaves it blank. You can then set up your conditional formatting based on that row containing a .
Drag-fill the whole way down, and it should automatically fill in as new rows are added after the initial set up.
This allows you to have your Parent Row designation driving your conditional formatting with the helper column pretty well hidden.
Thanks! Both are great ideas
This got me to wondering, so I started exploring this in more detail. If you just use what I posted above then EVERY parent row will be the same format regardless of hierarchy.
What if I have multiple projects, each with their own tasks, with some tasks having sub-tasks?
=IF(COUNT(ANCESTORS([Primary Column]1)) < COUNT(ANCESTORS([Primary Column]2)), COUNT(ANCESTORS([Primary Column]1)))
In the above formula, "1" represents the row that you are in, and "2" represents the row below it. Drag fill will automatically update the row references, and of course you'll need to replace "Primary Column" with your own column name.
You can then set Conditional Formatting for each number that is in your support column. This will allow you to "automatically" apply a different formatting based on the row's level of hierarchy.
Is there a way to revert to the old dashboard look and feel. The new dashboards do not look good at all. There is no way of knowing if there are additional items in the widgets until you scroll over one to learn there is more to it since the vertical bar doesn't show. We have hundreds of dashboards and they will all need…
When i try to send or print the timeline view instead of showing the progression bars like they do on the screen it only send the data entered and not a graph type view to print. Is there a way to do this. I am using a mac platform if that helps.
Please assist me, I am having trouble with my smartsheet, I am on a paid pro plan, with 5 paid members, but neither I or my members can access or edit sheets. When I try to share the sheet, it says that I only have viewer access. My team members cant access the sheets at all. I renewed my subscription recently and it seems…
