-
Dynamic view comments
Hi All, I have noticed that there is no way of seeing if there are new comments, or any comments at all in dynamic view ( the main view display). In fact, come to think of it an "unread comment" marker against a row in normal sheets would also be helpful. When setting up the dynamic view, " display comments" is an option,…
-
IF condition statement from multiple columns & properties
Need help populating the right color in my status column, which uses Red, Yellow, Green circle symbols depending on what other columns are reporting. I assume the below could be written with a formula. IF column B is blank, then RED. IF column B is not blank, then Yellow. IF column C is checked, then Green.
-
General Dashboard and Widget Question - Moving Groups of Widgets
Is there a way to move multiple Dashboard elements or widgets all at once? I'm finding that I have several "metric" widgets on my dashboard and currently I haven't found a way to "select all" and move them as a group. Instead I am currently having to move all of these widgets manually one at a time which can be tedious -…
-
RYG Milestone AND All Other Tasks
Hello - I have a team project plan that consists of 1) milestone tasks, and 2) all other tasks. There is a column ("Milestone') that is a checkbox that denotes if it is a milestone task if checked. At the bottom of the Smartsheet, I want to have a milestone summary that reports the following: Milestone task - If at least,…
-
Is there a way to automate updating one field in Smartsheet when I update another field?
I am building a headcount tracker that has Employee Name, Employee ID, Manager Name, Manager ID as some of the fields. The Manager Name is a dropdown where I can select the Manager. Is there a way to tie the Manager Name and Manager ID fields together so that it automatically updates and populates the Manager ID when I…
-
Possibly a Match/Index or a Vlookup Question. Conditional formatting for a lookup table.
Hi everyone, I'm currently having an issue trying to pull the names of the team members with the highest score in each team. I am able to pull the highest score on each team with a formula that looks something like: =MAX(COLLECT({Smartsheet Range 2}, {Smartsheet Range 1}, "Team 1")) =MAX(COLLECT({Smartsheet Range 2},…
-
Best way to look up multiple values in a multi-select cell?
I have a schedule that contains tasks, and each task has one or more cost codes associated with it. These cost codes are in Dropdown (multi select) cells. For each cost code in a cell, I would like to look up the associated value and add the values together if there are more than one. I am not sure the best way to do this.…
-
Contact Cells that match
Morning Pulling my hair out! I have two fields, lets call them Manager 1 and Manager 2. Both are vlookups from a central approval names sheet. Works fine and no problems. I have a situation, because both fields are used in an approval flow, where I want the approval to only go to Manager 2 if that person is the same as…
-
Automatic date update in a cell when another cell's value changes (as calculated by a formula)
Hello I would like to have a field set up that updates the date every time the 'status' changes in another column. Is this possible? For example, when a new line item is added and the status column changes to 'on hold' I would like the date the status changed to show in another column. This date will stay the date since…
-
How to Return Many Values to Track Status Changes
We are trying to track the dates that tickets change from status to status. Using workflow, I created a new line added for each status change. But now need to return the dates on each of those lines entered. Below are screen shots of the two sheets I am trying to do this. Tried Vlookup, Match and Index but cant get them to…