-
Count with multiple criterias (one or the other criteria)
Hi all, I am trying to count based on two criterias (if it's one or the other, they don't need to be both meet) Thank you.
-
lookup with multi select dropdown contact list
Hi All We are very new to smart sheet tool and we are currently in process of setting up our projects and creating a list in it. the problem we are facing is for example we have a project that is running in several countries as we speak and we want to look up the responsible persons email addresses for all those countries…
-
Automations and Cell Linking
Hello, I've read in a few past threads that automations will not work with Cell Linking. For example, I have a column that uses VLOOKUP to pull a Status from another sheet that is imported via Data Shuttle on a daily basis. I wanted to have the rows moved to my completed sheet anytime the Status changes to Closed. It would…
-
Update Status formula - late versus complete
Howdy, Question. I am using a status formula: =IF(Finish@row < TODAY(), "Late", IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row = 1, "Complete", "In Progress"))) This formula populates the status based on the % complete and due date. It works well, with one exception. If the % complete is marked 100% after the…
-
IF with 2 sets of criteria -
Hey I'm trying to get a tickbox to show at checked if : The ticket ID matches from another sheet The tickbox is also checked in that same sheet =IF(AND({TicketID} = [Ticket ID]@row, {Completed} = true), true, false) I have also tried replacing true/ false with 1/0 Thanks!
-
Rolling up RYG status by workstream
Hello, I'm looking to write a formula that averages my health status, but by the workstream column. For example, in the screenshot below, I'm looking at the "Equipment and Technology" workstream. I am using a separate metrics sheet to write the formula, as there will be one roll up status for each of my workstreams…
-
Use Index Collect to Pull in Formula?
I'm creating a project plan that uses index collect to pull information from another sheet into my project plan. Everything works great but on a couple cells I'd like to pull in a formula. Is there a way to do this? In my other sheet I've inputted the formula which shows #UNPARSEABLE (because I don't have the references…
-
How to link specific fields from one sheet to another sheet?
Sheet #1 has two Columns, let's say they are titled "Name" and "Fruit". Under "Name", is a list of names i.e. Mitch, Sarah, Elizabeth, Pete etc. Under "Fruit" says apple, orange, kiwi, etc. I want to create a new sheet (Sheet #2) that could reference Sheet #1. For instance, if column "Fruit" in the first sheet says…
-
Dropdown list Default value
Hello, I have a dropdown list of 10 values, simply a Right First Time stat tracker. So they choose "yes" if the action on the line was done correctly, or choose one of the other 9 reasons on why it was not done correctly. Is there a way i can set the dropdown list to select "yes" as the default value? Thanks Andrew
-
IF Formulas and multiple contact list
I am creating a workflow for a group of people and I want to assign roles when a specific cell (i.e. Doc Type) has been selected. However, I use the formula: =IF([Doc Type]@row = "ABC", "Sahand", IF([Doc Type]@row = "ABCD", "Jamie")) However when the results only show my name within a text format instead of a contact. Is…
