-
Using dates in sheet summary formulas
Hello, I have a sheet that is pulling data from Microsoft Dynamics CRM using the connector where the date data is not coming across correctly if the column is setup as a date format. I have therefore setup the column in the sheet as a text field. I have a summary formula which uses this column to summarize data by quarter…
-
Column Formulas not appearing on Gantt Chart
Hi everyone, I have a column consisting of "expiration dates" and another set of dates called "extension dates" if an extension has been made. I have put the formula "=IF([Extension Approval Status]@row = "ENABLED", [Extension Date]@row)" in the "expiration date" column, If an extension has been made and has been approved,…
-
Formula for counting rows that are past Planned Finish date
I am trying to create a formula that will count the number of row items in my Planned Finish column that are past the date in the cell. I need a summary item so that I can use it on a dashboard to show how many projects are overdue or should be closed. I have been trying to use a COUNTIF formulas that I saw other people…
-
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.…
