-
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…
-
Overthinking nesting Formulas
I'm sure I am over thinking it, but I can't get these two to nest together to save some space... =[2]2 * [2]3 =IF([2]4 > 9.1, SUM([2]4 - 9), IF([2]4 < 9.1, [2]4)) Basically I want to multiply 2 rows together, then if it is greater than 9.1, I want it to subtract 9 and reflect that value, but if it is less than 9.1 I want…
-
Is there a keyboard shortcut to jump to last filed row or column (like Excel and Google Sheets)?
In both Excel and Google Sheets it is possilbe to do [Ctrl] [Arrow key] to jump to the last filled non-blank row or column in series of rows/columns which allows quick navigation around a spreadsheet. I am a frequest user of these keyboard shortcuts in both Execl and Google Sheets. Is there a keyboard shortcut that allows…