-
TotalFloat with multiple phases
Hello, are there recommended best practices for handling dependencies when calculating TotalFloat, =TOTALFLOAT([Primary Column]@row)? In this example, Milestone 0 requires that Tasks 1-3 be completed and is a predecessor for beginning the next project phase. TotalFloat calculates values for tasks 5 & 6, but it does not…
-
Incomplate Online Formula Example - MONTH
Hi Support, MONTH Function | Smartsheet Learning Center Unsure where to post this, but the example is missing an end bracket. See below. =COUNTIF([Sold Date]:[Sold Date], (MONTH(@cell) = 2) When the MONTH function contains a blank cell within the range of dates it is reviewing, it will produce the #INVALID DATA TYPE error.…
-
Formula Help Please - Sheet Summary
Hi everyone - I have a GIANT sheet I'm working with that contains our project portfolio. I need to add summary fields to capture Project Status (from a dop down field in a column) across 10 different Sponsor Divisions (also in a drop down field within a column). I can't seem to crack this one. Can someone help? I'm sure…
-
Can Only reference a total of 100000 cells (combined) from other sheets. Please select fewer cells a
Hi All I am a newbie to Smartsheet, been working on it for a few months only. I am getting this error. Google is not helping me much. Please can a good samaritan assist me in this forum? Thank you so much. Existing formula that I am trying to update =COUNTIFS({Archive Sales Stage}, [Primary Column]@row, {Archive BU},…
-
Formula for project health
I have the following formula and I want to add: Turn task health Blue for START DATE column if today's date is before the start date. Leave Task Health blank if there is not Start Date or Target End Date =IF(OR(AND([Target End Date]@row <= TODAY(7), [% Complete]@row < 0.5), AND([Target End Date]@row < TODAY(), [%…
-
Can a value in a column be returned if that column is not blank?
Hello, I need a formula that looks at one entire column. If column is not blank, return the value in that column. There will always only be one value in the column but it may not always be in a specific row. I started with the formula below, but I'm getting invalid operation. I thought [Last Name]:[Last Name] would look at…
-
Project Health calculation with parent/child rows
Hoping to get some help with calculating health of a project. Here are my parameters: Green: Status column is "Complete" or "In Process" or the Finish date is 7 days out or further. Yellow: Status column is not "Complete", "On Hold" or "Cancelled", and the Finish is up to 1 day in the past. Red: Status column is not…
-
Using Index Match to Reference 2 separate sheets
Trying to write a formula that uses one distinct number and references multiple sheets to bring back information
-
Formula if a certain cell is blank otherwise display the date in that cell.
What's wrong with his formula? I have also tried wrapping it in an if error. I am essentially trying to create a manual override for a date by formula. For example the formula inputs a start date of 1/23/24. If I manually enter a date into another Column I'd like it to show that date instead. Here is the original formula…
-
Count If with Start and End Date
I need to count the number of projects going on in each quarter. I currently am using this formula: =COUNTIFS({Start Date}, <=DATE(2023, 7, 1), {End Date}, >=DATE(2023, 9, 30), {Helper}, 1) However, I need to include my Start and End dates to get an accurate count. This is my roll-up sheet: