-
Compare text in two different columns
I have a large SS that includes two rows of columns...one is the listing of the latest print revision, and I want to compare it to another column reporting which revision the part was actually built to. Both of these columns are populated with a letter (NC, A, B....AZ). My goal is a Conditional format color if the two…
-
Is there a way to view a map created using Smartsheet labs in the Sight view?
I created a map from one of my sheets and I want to display it on my sight/dashboard but not sure I can do this. I know I could add an image and then edit the interaction to view the map but thought I would ask. Thanks!
-
Excel rows
how do you get around this limitation??
-
Sort order affected by other users
Hello team - I am one of many users that updated this sheet on a minute by minute basis. Every time I do anything, I update the sheet. Problem is that even thought I've set up a filter so that I only see the items is want to see, whenever another user sorts the columns, my view get's sorted too. It makes it very difficult…
-
Reference Entire Column in Function
Hello Team, I wish to reference an entire column in a function, for example: Current Function: =SUMIF([Task Owner]1:[Task Owner]82, "Text", [Resource Sum Column]1:[Resource Sum Column]82) / 100 Desired Function: =SUMIF([Task Owner]:[Task Owner], "Text", [Resource Sum Column]:[Resource Sum Column]) / 100 Is this possible? I…
-
Automation RYG Balls
Hello I am working on formula which give me following: When I change Column B to (InProgress, Complete, or Risk) My Column A will change to (Red, Yellow, or Green). Also If there are any Red in the children, I want to show Red in the parent, If there are no Red but there are Yellow in the children, Show Yellow in the…
-
Change a row "owner" using a contact list and notify only them
Hi, I have tried to search before posting, though didn't find a specific answer within a sensible time - so hopefully I'm not repeating a request /question. If I have a task sheet with a field set to a contact list that's used to denote the row owner, is it possible to set an alert that when this field changes from user…
-
Update Request trigger
Hi, i need to create a trigger (with "Date" or "Assigned to") in order to sent automatily a update request to the person i have "Assigned to". Is this possible?
-
ISERROR or IFERROR .....Please help
Hi Team, Starting to expand my SUMIF formula which is great. The only issue is that it returns #INVALID DATA TYPE, when the [Sold Date] cell is left blank. I need to add a (ERROR formula in there somewhere im guessing. Im not sure excatly how ???? =SUMIFS(IFERROR([Value of Jobs]2........ How should it look please ? Thank…
-
Percent Complete not adding up
I need some help figuring out how to make my "% Complete" column reflect the actual percentage using my "Hours" column and not "SLA" (days). The sample below is clearly incorrect. It should be more like 64% complete. I'm totally stumped.