-
Gnatt View print
Dear All, I have a quite a large program plan. To have a level one plan, I have a column with a check box to indicate what needs to be shown in the Level 1 plan. On filtering the Checkbox the Gnatt Chart view shows the dependency links, however when I export the same to PDF view the dependency links disappear? I have tired…
-
Making a Date Column N/A unless needed to for a specific row
I was wondering if there is a way to make a date column go N/A unless needed for a specific row or rows. For Example: I only want the Delivery Date Column to be active when it comes to Deliveries. Is there a way to do this or no? Please Help Thank You.
-
New tabbing organization for many summary levels
When I have 5+ levels of hierarchy in the tabbing, the tabbing doesn't seem to suffice to show organization and I cannot understand the hierarchy from just viewing the tabs I have tried using highlights but I have too many sections and subsections to have distinct highlight colors. My solution is to make brackets on the…
-
Finding a SmartSheet
I'm trying to find a SmartSheet, that I know exists, but isn't shared with me so I can ask the owner to share it. How do I find it?
-
Change size of text in Reminder/Alert email
Is there any way to make the text of the custom message included with a Reminder or Alert notification bigger? The text of the actual message ("Please do something based on a Smartsheet condition") is so small compared to the information pulled in from Smartsheet that my users are missing the reason they received the email…
-
Notification & Alert Emails
We have notifications set up for when our name is mentioned in a specific column. However, even after we've addressed that line item, we continually get notifications for it. Is there a way to program it so that we get notifications for as long as the line item is live, but no longer after it's checked complete or grayed…
-
Portfolio Reporting
I am new to Smartsheet and my goal is to have a dashboard for our PMO with links to the various projects. Each project may be led by different people in the company. Do you have suggestions on how to set up the Dashboard for automatic roll up of information? I have found some helpful articles here, but I would love to know…
-
Dashboard metric widget - size of the status RYG ball
I successfully created a dashboard with a widget that displays an overall project status from a sheet. I can manipulate the title of the widget to reflect this is a key metric but the status ball doesn't appear to be sizable and looks tiny compared to my title. Is there a way to increase the size of the ball to match the…
-
Using predecessors to dictate duration
Hello, I have a line in a sheet that I would like to start when another line starts and end when a different line ends. For example, I have 4 lines in a sheet: Line A, Line B, Line C, Line D. I want Line A to begin when Line B begins and end when Line D ends. I want the duration to be malleable and change automatically if…
-
IF AND trouble
I am trying to create a formula that assigns "Yes" to a cell if a result is within range and "No" if it is not. This formula worked for only one of the columns in the range: =IF([High Control Result]1 > [High Control Range Minimum]1, "Yes", "No") I tried to use AND without success: These formulas didn’t work =IF(AND([High…
