-
Match all columns to complete
I have several columns with dropdown (Complete-Go, Incomplete, TM Approved-Go) and one column that says (Go/No Go). If all columns have "Complete-Go or TM Approved-Go" the column (Go/ No Go) should be "Go" If any column has "Incomplete" the column (Go/no Go) should be "No Go" I appreciate your help very much! Rob
-
How do you set a flag based on status and days within a due date?
I'm trying to create a formula with the following logic: Don't highlight the red flag if the status is N/A or Completed Highlight the red flag If the status is In Progress or Not Started and the due date is <= Today (-3 days) Below is what I'm using, but now none of the flags are turning red (and no error message appears):…
-
How to put a value for each item in dropdown list
I have a dropdown list and I want to put a value for each item (but not in the list): Not Ordered = 0% complete Ready to Order = 1% complete Order Process = 20% Shipped = 50% complete In Country Customs = 80% complete Delivered = 100% complete Cancelled = 100% complete This is to help me to calculate the task % complete…
-
How to include a newly inserted column in an existing formula?
I have a formula at the end of a row that adds everything to the left. I want to insert a new column and have it automatically included in the formula. Excel does this by default, can smartsheets do the same?
-
Need help with a formula to calculate accrued PTO based on # of pay periods
Hello, I am seeking help with a formula to calculate accrued PTO based on the # of pay periods per person each year and if they are full-time. Example 1: Nikki started on 7/1/22 and accrues 3.5 hours each pay period (twice a month) so I need a formula to let me know what she has accrued to date. Example 2: Laura started on…
-
INVALID OPERATION
Hi all, I am trying to do a very basic formula to create a Score of two columns but am receiving the error #INVALID OPERATION. Is this due to the source columns also being built of a formula? Kegan =IF(ISBLANK(Probability@row), "", IF(Probability@row = "Almost Certain", "5", IF(Probability@row = "Likely", "4",…
-
Metrics Sheet Help
Hi SS Community! I have an Onboarding Metrics Sheet that feeds into a dashboard to show the total amount of Current Week New Hire Starts. The way this is currently set up in my metrics sheet is below: The formulas are currently set up as: Current Week Starts: =COUNTIFS({Requested Start}, >=DATE(2022, 1, 1), {OB Status},…
-
Nested IF with IFERROR
I have an IF statment that is working fine. But in many cases it is returning '#INVALID DATA TYPE'. When it returns that I would like the cell to be empty. How do /where do I nest the IF with the IFERROR?
-
How do I count the entries from a column from another smartsheet?
I need to count total entries from another column from another smartsheet minus out scope criteria. i.e. 1st Smartsheet, column 1 Title “Total Sites in Scope” 2nd Smartsheet, Column 1 Title “Site IDs” that has entries. Column 2 Title “Order Status” dropdown option “out of scope” Solution: 1st Smartsheet, column 1, cell 1…
-
How do I make the cell to change data after other cell is populated?
I have sheet 1 with the rows below with formula in: LAN Migration Ready =COUNTIF({sheet 2 name Range 10}) LAN Migration Ready Approved =COUNTIF({sheet 2 name Range 11}) LAN Migration Scheduled =COUNTIF({sheet 2 name Range 12}) LAN Migration Complete =COUNTIF({sheet 2 name Range 13}) Sheet 2 I have: Each row represents a…
