-
Hiding data in my project plan for specific users
Hi, I read related smartsheet discussions on this. Is there a solution for this other than hiding the columns which contains the info you do not want to share with other users? I have budget figures on my project plan, and only 3/8 users are allowed to see it. I know you can create a seperate sheet and insert links. But…
-
Can Smartsheet show a Gantt style bar that shows monthly RAG status trend?
I am new to Smartsheet and have a POC developed in Excel that allows us to have a gantt style timeline that is coloured by month according to the monthly RAG status. This RAG status is conditionally formatted based on whether we indicate 1, 2 or 0 in the cell but is not shown. We can also add activity descriptions in the…
-
Multiple Projects - all with interlocking critical paths
Hello community I don't know if anyone else has this issue. I have multiple projects, resources etc, that all overlap. I have a VP that wants to see the critical path over ALL of the projects. Is there a way to do this? I know we have critical path capabilities within one sheet, but i dont see it in a report when i put…
-
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
-
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…
-
:% 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?
-
Admin Control/Push Font Across Workspace/s
I would like to control and update the font for all sheets in every workspace. For example, I would like to change all data in workspaces/sheets to be Verdana 10. Right now we have different fonts across sheets. Then allow Contional Formatting be the only way for fonts to be altered. As admin can we have control over this…
-
Does anyone know what NaN% means?
Hi all, I'm getting NaN% appear on my sheets where that cell is linked to another sheet. The source cell appears OK, and I've tried remaking the link, but no affect. Is this the 2000 links I'm running up against? There are a lot on my sheet.... Regards - Roland
-
Reports - Dropdown Functionality not working
Hi, As many are experiencing report dropdown functionality is not working. This seems to be for RGYB balls, as well as other dropdown lists. I have tried turning the dropdown columns to normal text columns to solve this issue, but this does not seem to work either. It appears to be a deeprooted bug. An update ASAP would be…
-
Over booked resources?
Hello, I'm fairly new to Smartsheet, but have been using MS Project for a while and pretty comfortable with project management tools. I have a sheet that is over booking resources, I have no clue why! I have two tasks that have a duration of 3 days requiring the same resource, they are both dependent on an earlier task.…