-
'Most Common' Formula
Hello, I am trying to create metrics on tracking the versions of an applications we are developing, currently I am attempting to find which version is most successful after it has been run through a series of criteria. Example: Build 30 - Success Build 31- Success Build 31 - Failure Build 32 - Success The Application…
-
See Row Update Requests
Can you see a row update request someone else sent? I would like to be able to monitor requests from my team if possible, so they aren't duplicated. I've looked in the activity summary, but they don't live there. Thanks in advance, Regina
-
Conditional formatting in Gantt not working with dependencies
For some reason it seems like my conditional formatting rules aren't being applied to certain rows in the Gantt chart side of this sheet. The problem is resolved if I disable dependencies, but I need those and don't understand why this should matter since I don't have any rules related to status or % complete in the…
-
Function like UNIQUE in Excel?
Does Smartsheet have a function similar to the UNIQUE function available in Excel? The function allows you to select a range, and then provides a unique list from that list. In Excel Combining: SORT, UNIQUE & FILTER will provide a unique list excluding blanks that is alphabetized. I am constantly using that function within…
-
Automatically Update Numbers in Countdown Formula
Currently, I have to refresh every day I need to see the most up-to-date number of days remaining for an event. I'm surprised this doesn't exist already considering how many tools there are for event and project launch coordination.
-
Hidden or Blind Comment Feature
I would love the ability to have a hidden or blind comment feature for end-users to provide comments or feedback without being able to see the comments posted by other people. This would be especially important for intake sheets so the committee members can have conversations about the request in the comments section and…
-
Merged: A cohesive/real-time ability to work with multiple people within a sheet at the same time.
This discussion has been merged.
-
How do I use percentage formulas to breakdown responses
I am currently tracking a project and have 4 columns that use the following values - pass, fail - see notes, n/a, not tested. How can I break this down % wise to see which line items have passed, failed, n/a or not tested per column? The goal would be to roll the information up to a report then up to a dashboard.
-
Keyboard Shortcut to Hide Column/Row
Instead of having to right click and navigate the cursor to hide a column/row it would be ideal to have a keyboard shortcut to assist. i.e. right click on a column that is to be hidden and hit the letter H on the keyboard to hide the column. Same concept can be applied to a row.
-
Combine: IF AND CONTAINS, And SUMIF
Hi, I got a question about how to use all the above statements in one formula, _______ I have the following columns; A regular text column "Client ID", A multiple dropdown column "Shared IDs", A regular text column "Hours worked" A regular text column "Shared Hours Approved" _______ I have each client and their Client ID…