-
Sum of all descendants
Hi I am trying to add a formula to get the sum of all descendants. I have used =SUM(CHILDREN()) but that only adds in direct children. I need to also be able to add in the grandchildren, greatgrandchildren, etc. Any way to do this? thanks
-
Update request to mailer doesn't work?
Is there an accepted practice for sending an update request to multiple people? A contact column can only accept one contact rather than a list. I tried sending an update to a pre-defined mailer list, but when I send these requests, no-one on the mailer receives the email?! I can see the email being sent because I am on cc…
-
Custom formatting - individual cells
Excel has the functionality to define custom formats by cell - for example, you can say that for each cell in a range, if the cell value is negative, then the font colour will be red, otherwise it will be black. Does smartsheet have this functionality? So far I can only see fuctionality to format an entire row based on a…
-
Wish list for Smartsheet
Hi, I am new to Smartsheet, and I have been using it this last month to manage one of my projects. One of the area I wish there was some improvements and changes, would be the Update Request area: 1. Be able as Admin to change manually the status of the request, reason being, that I send request to my team over in India,…
-
Prevent column name from showing up in Sight
Hi, Has anyone found a way (or is there a way) to prevent a column name from showing up in a Sight? For example, I have a report on my Sight and a row in the report is actually the column name which is different than the Smartsheet column name (Smartsheet column name is "First Name" but the row showing the name is only…
-
I need a better way to print/share Gantt charts
Hi, I frequently need to share Gantt charts - in project reports, presentations, proposals, etc. I find capturing the Gantts a real challenge. I know how to print them, but it often spans several pages and is essentially unreadable. I know how to make it fit to one page, but with the grid lines, it's pretty hard on the…
-
:% Completion Drop Down freeze
We are unable to use the drop-down option to update the % completion of our projects but it allows us to manually update it. It has being like this for about a week. How do I fix it?
-
Report - sum a column
Hi all, I have multiple budget spreadsheets and a related report which I point to one budget sheet at a time. I can then report on just one month at a time (example: project A, October totals). Is there any way to sum the cost column for the items returned in the report?
-
SMARTSHEET FREEZE
We're experiencing "freezing" of open sheets for a few seconds when you cannot click on anything. This has been going on for a few days. Anyone else experiencing this? Thanks
-
Lags and Leads - Proposed Enhancements
There are two elements to Lags and leads that I believe are greatly needed in Smartsheet Projects: 1 - Being able to use elapsed time in Predecessors i.e. +e6h for Paint drying time or +e5d for waiting for approval from external agency etc. 2 - The ability to use percentage % in Leads so that the overlap is based on the…