-
IF/ OR
Hello, I am trying to create a formula that encompasses multiple dates. The current formula I have is as follows: =IF($[In Date]5 = ($[In Date]$4 + [03-OCT]$4), $[Day Type In]5, IF($[Out Date]5 = ($[In Date]$4 + [03-OCT]$4), $[Day Type Out]5, IF(AND($[In Date]5 < ($[In Date]$4 + [03-OCT]$4), $[Out Date]5 > ($[In Date]$4 +…
-
Developing a Portfolio Roadmap - Apostrophe being added to formula
I'm trying to develop a Portfolio Roadmap (Gantt View) that is driven by both the Start / Finish dates of Live project schedules and planned Start / Finish dates of future projects. Start / Finish columns = Linked to Live project schedule for approved projects Portfolio Plan Start / Finish columns = Manually entered for…
-
Why won't my multiplication formula work?
I am trying to enter a formula that will multiple the contents of two cells in a row in a third cell by using =[cell 1] * [cell 2]. This worked when I had manually entered the numbers into cells 1 and 2. I changed cell 2 contents to a formula so that I do not need to manually update that column. Although this formula works…
-
Moving DATA from source sheet into new sheet that has formulas that need to be applied to new data
Hi, I have developed a new sheet (NEW PROJECT SCHEDULE) for our PM's to use that has a lot of formulas in it, on almost every row (Parent and Child rows) as well as Summary formulas for a Dashboard. This prototype has tested and worked well for new Projects because the original data is being copied to the NEW PROJECT…
-
Current year streak and rolling unbroken streak formula help
I have a dashboard metric that I could use help with. I have a Consistency Club to recognize associates that achieve their monthly sales activity metrics, measured by individual month. Meaning if they have achieved their metrics for Jan, Feb, Mar, Apr, May and June their current year consistency streak would be 6. If the…
-
Is there a formula to calculate the overall state of a specific group of projects in a metadata?
Hi Smartsheet Community, I am trying to calculate the total number of green, yellow and red projects I have on a sheet based on different project groupings. My goal is to be able to have a chart in the dashboard that would report on the overall state of a group of projects based on their location or strategic initiative.…
-
Vlookup function
Hello all, I am looking for a formula that see's the week number, and therefore populates the period in the box above it Everything is listed on this sheet below, each week has a corresponding period, all the way to the end of 2022 I tried using, =VLOOKUP($[2]$3, {IN. Data Control (Dates) 2019-22 Range 2}, 4, false) But it…
-
#Invalid Operations
I have what I thought is a simple formula, but I get the #Invalid Operations
-
Symbols not Resulting from Formula
I am trying to do a three-way match of dollar amounts in 3 different cells. I have the formula set to a column using the Yes, Hold, No Decisions symbols. Here is the formula: =IF([Requisitioned Amount]@row <> [PO Amount]@row, "no", IF([PO Amount]@row <> [Invoice Amount]@row, "no", "yes")) Two Challenges 1) My symbols are…
-
index match not pulling correct column
=INDEX({MPP Range 2}, MATCH([System Number]@row, {MPP Range 1}, 0), 21) MPP file i have a total of 22 columns. i changed 21 to 20, 18, 17 (all Date config.) the dates pull fine. when i pull 21, date config, i get an errro (#Invalid Value) i copyied on the MPP file my date from column 20 and still same error. got any ideas.