-
Formula Assistance
Hello, I have a formula that works but need to add more variables to it. So when certain criteria are met then it produces a certain response. However, for the heart failure, I need to also include regular or bariatric scale, so I think i need to add and AND to the formula but cant figure it out. =IF([CareKit Type…
-
Updating New Row Status to Mirror Existing Row Status Using Common Identifier
I have an end to end program that the last process is assigning and working through List Manager assignment, creating the list, approving the list, etc. The input sheet for the List Managers is only updated using rules in data shuttle and some of the rows added are associated with existing rows in the sheet and do not need…
-
VLOOKUP Not matching with Cell Reference but with String
I am doing a cross sheet VLOOKUP using this formula: =VLOOKUP(Region@row, {GC Consulting Approver}, 2, false). This returns a No Match error even though there is a match. If I use this version of the formula, =VLOOKUP("Americas Latin America", {GC Consulting Approver}, 2, false), it makes the match. The search value is in…
-
Help Extracting data sets that meet criteria to new sheet.
Hello, I am new to smart sheets. I have spent the last week trying to find a solution with no luck. I am sorry if I am asking a question that has been, probably, answered a slew of times. I have a form built that collects data on visits to one of four locations. "Activity Tracker" is the name of the sheet where the…
-
How can numbers only be extracted from a cell which may have text, numbers and symbols?
I have a column of ID's extracted from a larger string. I need to extract the numbers ONLY. The column looks like this: The numbers will not always be exactly in the same starting position, nor will they always be the same length. There can be anywhere from 3-5 numbers. The preceding text may be between 5-6 characters. I…
-
Inactivate a task
Is there a way to make a task or group of tasks inactive in a project plan? In Microsoft Project there's a function called Inactivate that's used after you select tasks that you want to make inactive. Doing this does not affect resource availability, the project schedule, or how other tasks are scheduled. I know this…
-
How can I copy cells from another sheet with multiple instances of the Matched cell reference
I'm new to the community, hello! Scenario: I have a source sheet with time entries for all resources and all projects. Project ID appears in all rows. I want to copy rows with the same Project ID’s into individual sheets, by sheet reference. I am familiar with “Index/Match”, but I do not know how to capture multiple…
-
Past due formula keeps providing #INVALID DATA TYPE error
Hello, After much research and experimenting, I am still stuck on a formula for my status log. I am trying to create a formula that counts how many business days a task is past due. Therefore, the formula must check the due date, closed date, and status columns. The formula currently reads as this: =IF(ISBLANK([Due…
-
Cross Reference and Multiple Columns
Hello Smartsheets! Trying to find a solution when matching rows across sheets. Is it possible to say, if multiple criteria in columns match criteria in multiple columns on another sheet to check a box? For example, if I have identical rows on two sheets (sheet A and sheet B) of matching information, check a box on sheet A.…
-
Index collect from
I have 2 sheets I am working on with; Sheet #1 (POD Archive) - this is where the entries are logged. A single entry could have multiple PO's in column "PO Number". PO numbers were separated by space. Sheet #2 (POV) - contains data imported from an external application using Excel - it contains one PO number per record…