-
How to add multiple status criteria when counting tasks
I am looking to create two summary sheet fields. Formula 1. Count the number of tasks that are due within the next 14 days Constraints: Status must be "Not Started, In Progress, OR Scheduled Due Date must be within the next 14 days Formula 2. Count the number of tasks that are due within the next 14 days but also return…
-
How to Use IF with Multiple Criteria and then to plug in a date - Cross Sheet Reference
I am trying to write a formula that is referencing another sheet. If a row on 2023 Training Request matches the Location Tracker (where im inputting the formula - the studio code is the identifier) AND the Role dropdown on 2023 Training Request is "General Manager" then show the date in the Location Tracker that is in the…
-
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…
