When designing Smartsheet dashboards, accessibility should be a top priority. This is when Smartsheet Dashboard Color Themes come to action! No more picking random colors or spending painstaking amounts of time making sure the colors you want to use actually work together. Now you can access 9 different color themes…
Share, comment, bookmark or report
Welcome to the Smartsheet Forum Archives The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Share, comment, bookmark or report
Pre-Populate a form. 11/22/20. Morning. I've got a simple form that we send to a manager to complete details for their new employee. The form is started by me in that I add the new employee basic details onto the Smartsheet. I want to then send a form to the manager, with 3-4 pre-set fields already completed (Name, location, etc.)
Share, comment, bookmark or report
Here is the situation: I need to get a list of distinct/unique values in a column using a formula on Smartsheet. I know how to create this formula on excel, but when i convert to Smartsheet, it simply doesn't work. The formula that I used in Excel is the following:
Share, comment, bookmark or report
You can also use the combination of ISBLANK () and NOT () to evaluate if"any value" is in the cell. For example, ISBLANK ([Column 2]@row) will check to see if the cell is blank. Enclosing that statement within NOT (), e.g, NOT (ISBLANK ([Column 2]@row)), essentially means" [Column 2]@row is not blank".
Share, comment, bookmark or report
If you don't want your users to see"completed" rows anymore, I would recommend using a Move Row workflow to move those rows into an Archive sheet. That way they're cleared from the sheet and"hidden" from view, but still stored in Smartsheet if you ever need to access them in the future. See: Automatically move or copy rows between sheets. Cheers,
Share, comment, bookmark or report
Smartsheet Dashboard Accessibility Color Themes. When designing Smartsheet dashboards, accessibility should be a top priority. This is when Smartsheet Dashboard Color Themes come to action! No more picking random colors or spending painstaking amounts of time making sure the colors you want to use actually work together.
Share, comment, bookmark or report
You can actually cell link multiple cells all at once so long as the size and shape of the ranges match. For example, go to a column in the destination sheet and highlight 10 cells going down that column. Right click, select the option to link to another cell, select your source sheet, then select any 10 cells that are right next to each other ...
Share, comment, bookmark or report
So someone submits a form in Smartsheet and powerautomate takes the data from the form and sends it in an email. When I use the smartsheet dynamic content in the"send email" action via powerautomate, powerautomate automatically places that send email action. That creates a loop so powerautomate will send multiple emails.
Share, comment, bookmark or report
For this question, I'm able to construct formulas that Smartsheet accepts, but the current version is long and more difficult to understand/manage from other users. This involves using IF, FUNCTIONS, and OR (for the different searched fields). I'm looking for a more elegant/simple solution. Current Setup
Share, comment, bookmark or report
Comments