-
VLOOKUP on a reference sheet gives me a "no match" headache
I've been trying to do a simple VLOOKUP, and I read lots of help and community articles. Nothing helps. Anything I'm doing wrong here? (BTW: if I am using "75100" instead of ID35, it works fine).
-
If Cell is Empty or Blank
Hi, I have created the following formula =IF(COUNTIF([New Case Checklist Status]@row:[PCORI Reports]@row, "Pending") > 0, "Pending", IF(COUNTIF([New Case Checklist Status]@row:[PCORI Reports]@row, "Created") > 0, "Pending", IF(COUNTIF([PCORI Reports]@row, "Requested"), "Pending", "Done"))) which is working efficiently, but…
-
Automatically move a sheet within a sheet?
Hi. So I have created a production sheet that displays all my projects and where they're at in its state (Phase 1 through Phase 5). For example: Phase 1 Projects: Project 1 Project 2 Phase 2 Projects Project 3 Project 4 Phase 3 Projects Project 5 Each "project" is a hyperlink. When clicked on, it sends the user to the…
-
Formula for to change cell value if all checkboxes ticked
Hello, Request assistance with a formula for the below scenario. Eleven of the columns in the Smartsheet have a Checkbox. I am looking for a formula that if all the Checkboxes are ticked then the value on the adjacent cell changes from 'Initiated' to 'Completed'. I'm new to Smartsheet and Formulas 😃. Your help is greatly…
-
Help me to create a formula with 3 condition, So that I can pull data from another sheet
The formula should include these 3 below condition. Job status is complete Brand name is Ganesh Fathima Total savings The result of these formula should satisfy all these above condition. Many thanks in Advance!!
-
Permantly update cell with IF function
Hey all, Im trying to update a cell based on another cell and so far i have this =IF(Status1 = "Laser", "1") This works great but the cell doesn't stay updated when I change status, which makes sense, but I need it too. Ive tried =IF(Status1 = "Laser", [Laser-Meta]1 + "1") as to append to the cell and this =IF(Status1 =…
-
How do I create a COUNTIF formula that counts a status as "closed", but only if within 90 days?
Appreciate any help you can provide. Thanks!
-
Update requests for Sheet Summary Fields
Hi Community, hope you are well. Does anyone know how and if it is possible to set an automation that triggers update requests for fields in the sheet summary? The update request function generates an handy form which would be perfect to capture the weekly project status update which as per current set up is located in…
-
Help with IF(AND(ISBLANK statement
Hey there, looking for help with this formula: =IF(AND(ISBLANK([Orientation Appointment]3)), [HR RedCarpet Green Light]3=0), "Red", "Green") Trying to get it to read a Red ball if "Orientation Appointment" cell is blank AND if "HR RedCarpet Green Light" cell is not checked, but I seem to be doing something wrong. Thanks!
-
Updating Status column based on two different columns
I am looking for a way to have a column state "Cancelled", Submitted, or "Completed" based on two different columns in Smartsheet. If SAP1 column = "No" I want the "Status" column to say "Cancelled". If SAP1 is "Yes" and another column that states who completed the request is filled in with any name (is not blank), then I…