-
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…
-
Can I use a formula for this date feature?
I'm working on transferring my excel system into smartsheet. I am creating a newsletter regarding events that happen during a certain period. In excel I can use a forumula based on a date. For example if the publish date is 23/5/2018, it will relate to events happening between 24/5/2018 and 3/6/2018. In excel , the event…
-
Tracking Financials on a weekly basis appose to monthly
Hi, We currently track our financials on a monthly basis project by project. We would like to track the resources on a weekly basis to calculate how much they cost weekly. Is there anybody that currently does this and could help us change our financials sheet from monthly to weekly? Kind regards PMO
