-
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…
-
Link Reference Sheet Dropdown
Is it possible to reference a list on a separate sheet for the user to select as they input data into rows?For example; activity type, client name? I have created a time sheet and would like users to reference the data in another sheet. Thank you, Rachel
-
How to build an IF formula based on a date field
Hello, I am looking for help in building an IF formula that will return a number value, based on how far in the past a date is (using a date field). Where a date field is populated and depending on the date, a number will be chosen : 1 = a date that falls in the last 2 months from today 2 = a date that falls between 2 and…
-
column date depending on symbol column
Hey, I couldnt find an answer to my question here, therefore I hope you can help I have columns: 1) star symbols 2) last date ( I enter manually) I want to calculate "next date" f.e. if star is "1" or "2" = last date + 90 days if star is "3" or "4" = last date + 60 days if star is "5" = last date + 30 days if star is "6" =…
-
How do I fix a VLOOKUP problem?
Hi there I'm using a form to capture COVID RA Test results, scheduled for different departments on different days. The schedule uses a VLOOKUP to populate the 'test result' column from the form results and allows us to report on anyone who was scheduled to submit a test by a certain time but hasn't (report if blank &…
-
Formula to return boolean looking at multiple date columns
Hi I need a formula that will look at three date columns and if any of them are date that isn't in the last 5 days, I want a boolean '1' returned. This is what I've used: =IF([Project Health RAG Last Updated]@row <TODAY(-5) OR(IF([Current Position Last Updated]@row <TODAY(-5), OR(IF([Next Actions Last Updated]@row…