-
Find all similar entry names and add their qty
Hello I have a sheet I made where I load in all my orders of items needed for a job. Each Item has a code assigned to it I'm calling the Entry Name. There will be times where the same Code/Entry Name will appear several times during the life of the project. For Example This week I might need 4 - BT01 (Entry Name) then as…
-
Flagging bad phone numbers
Hello! I've been reading around and I feel like I'm missing something with my formula: =IF(OR(NOT(ISNUMBER([Phone Number]@row))), [Phone Number]@row < 1000000000, [Phone Number]@row > 9999999999, 1, "") Basically, I want a checkbox to tick if any of the following happens: Any characters are added It has fewer than 10…
-
Auto formula Sum is generating a 0 when no data is present yet
I have a column with an autogenerated formula looking at turnaround time. Essential day completion minus day start. Somethings are finished the day of and have a turnaround time of 0 days which is great for us, however, for rows that do not have a finish date yet it is auto generating a 0 instead of what should be a blank.…
-
I want a blank cell to return a symbol in another cell
This is a pretty basic question that I'm sure has been asked before, but I'm having trouble finding an answer. I'm using the below formula, but I need to add an additional rule so that if the Loaded cell is blank, it would return the "Hold" symbol. I've tried some variations of ISBLANK, but haven't gotten any to work yet.…
-
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…
-
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…
-
Alternate way of pulling Countifs with WEEKNUMBER functions
Hi, I have a weekly report that needs to count all the leads per lead source and my source sheet is pulling the data from google sheets. To count the report automatically from the sheet source, I am using this formula below. [Select week] column dictates the week number that I need. As you I have heard, WEEKNUMBER pulls…
-
What is wrong with this =AVERAGEIF formula
Here is my formula - =AVERAGEIF({Week Number}, ={Current Week}, {Daily Cnt Comp}) Where Week number is a cross reference to Audit Report column Week number Current week is a cross reference to the Audit Report SS to the current week number based off the current date I cross reference the {Daily Cnt Comp} column in the…