-
Roundup
I am looking for a formula that if a number in the "adders" column is negative, round to zero and if the number is positive, roundup to the nearest 1. Example: -7.03 need this to round to 0 7.89 need this to round to 8 7.05 need this to round to 8 Thanks!
-
Counting cells with numer of %
Hi i want to count the number of cells with 100% i.e i have 20 projects that have reached 100%. i tried =COUNTIF([% Complete]1:[% Complete]118, (100)) and also tried =COUNTIF([% Complete]1:[% Complete]118, "100") but it doesnt return the correct number. Thanks Paul
-
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…
