-
How to check is a cell is blank is multiple columns?
Hello! I am trying to create a formula on column X that checks if any cells on the row are empty. If one of them is, then show the "X" value, if all are not empty then, show the "O" value. I used this =IF(ISBLANK([ICP Deliverables]3), "X", "O") to do it with just a column but I need it to check all columns, not just one.…
-
formulas to reference sheet in multiple lines
Is it possible to bring information to a sheet from a reference sheet column but have it list the returned information out in separate rows? I have a source sheet with many rows that are sorted by status. I want to list out the job numbers AND the job name in another sheet, ideally side by side one on each row. I would use…
-
Formula IF/CONTAINS/COUNTIF showing UNPARSABLE error.
I have a sheet collecting answers from a survey. I have 5 columns showing Agree or Disagree questions, one for Team/Role. I want to know the percentage of the level of agreement for each of these 5 questions for each Team/Role. Meaning I want to know the percentage of agreement for Operations, DSIT PMO, etc. I'm trying to…
-
INDEX MATCH with IF function
Hello smartsheet community, I am stuck! The below shows SHEET 1. There is an automation on this sheet that copies all rows on the 27th of the month to SHEET 2. I then want to pull the data from the load column back from SHEET 2, to SHEET 1. As the 'Date Added' column has a new month every month, the data will be pulled…
-
Nested IF Function using Harvey Balls
Hi SS Community, I have the following nested IF column formula . The formula works properly through the "Red" part, but once I attempt to type DECLINED in the "Revised Final Date" column, the formula returns #invalidoperation. What can I change in my formula to show a Gray Harvey ball when I type DECLINED in the "Revised…
-
How to Write IF Statement for a Symbol Column
I have a Symbol column that I'd like to auto-change to Green, Yellow, or Red depending on the date values in my Start, Finish, and Project Status columns. For instance: If Start is in the past and Finish is in the future and Project Status is not "Complete" or "In Progress", Symbol changes to Yellow. I really wish…
-
JOIN IF formula help!
I'm looking to Join 2 contact columns into 1 text column* with something to space the 2 values out so the names in the formula column do not run together w/out spaces. The problem with this is that if there is a missing value in 1 or both reference columns, the character I'm using to space (" | ") appears for no reason.…
-
Countifs: Help with syntax in Countifs Formula with multiple conditions
Hello All, I am trying to return a count when 2 conditions are present from a referenced smartsheet. This is the formula I created according to the guides I can find, but smartsheet says it is unparsable. Can someone let me know what the error is? =COUNTIFS({Range 3}, "Current", {Range 2}, "Critical")
-
Date formula working for half of rows
I have a columns for expiration date, 6 months prior to exp date, and 3 months prior to exp date. Formula for 6 months prior is: =IFERROR(IFERROR(DATE(YEAR([Expiration Date]@row), MONTH([Expiration Date]@row) - 6, DAY([Expiration Date]@row)), DATE(YEAR([Expiration Date]@row) - 1, MONTH([Expiration Date]@row) + 6,…
-
Nesting Formulas
Thanks in advance for any help! Doing a gantt with dependencies turned off and want my % complete column to calculate the percentage along with an IF statement so that start dates in the future return a 0% complete answer and finish dates in the past return a 100% complete answer. I know how to do each of them individually…