-
How to show time delays on a Gantt Chart?
We are a construction company using Smartsheet to follow the progress of the construction on site. Sometimes delays occur due to weather, power, etc.. but not all trades are affected. We need to be able to visually show to the clients (via a Gantt Chart) the reason (weather, power,etc..), the length of time (Start Date,…
-
Nested IF , logical operator (AND)
Hi All, I am trying to build a formula with IF, AND conditions but i am unsuccessful, can any one help me to sort out this please. Here is the forumula =IF(AND([Position at Practice]227 = "Receptionist", [Current MECA Step]227 = "Step 1"), "19.63", IF ([Position at Practice]227 = “Receptionist”, [Current MECA Step]227 =…
-
% Complete range in If statement how best to describe
I'm trying to have a conditional format occur in a status column, when the % Complete column hits a certain condition, for example: 1. If % Complete = 100%, place "Complete" in the Status Column, and conditional format will change to blue 2. If % Complete is less than 99% and greater than 1%, then place "In Progress" in…
-
Dynamic Future Date based on Condition
Hello, Issue: I need to create a date column that will produce a forecasted date, based on a manually entered date plus X amount of days, based on a certain value (phase). Example: If Phase is "SOW Draft/Negotiations", add 60 days to the "Phase Modified Date" (60 days that will dynamically update everyday, so today will be…
-
Completed Row Drops To Bottom
Hi everyone, While at Engage18, I heard there would be a way to have a row drop to the bottom of the sheet, once completed. Does anyone know if it's at all possible right now, or is this something they are still working on?
-
Formula help or advice if possible
Hi, i am hoping some can help or confirm if this is possible. The background: We are capturing data from employees working at 400+ locations. this is being done by a form. the data captured on the form is then being pushed out to individual sheets using a cross sheet formual: =INDEX({Employee Communications for Tupe Range…
-
MAXIFs Alternative?
I have a google form that updates the prices of materials. On google sheets to display the most updated price of the material I have a Newest Entry Column =MAXIFS(Timestamp:range, Material cell) then in the material price columns I have an Index/Match formula to display the most recent entry for that material. I would like…
-
How to use "Countif" with reference to CHILDREN in another sheet
Hello - I need some help with the children formula. I am trying to reference another sheet and only pull info from the children of specific hierarchies. The only way that I can do it, as of now and with my current skill set, is if I select all of the actual children. I realize this will be out of formula as soon as more…
-
Formula Between Date
Can someone tell me what I am doing wrong in this formula? =COUNTIFS({HITRUST CAP Milestone Plan v2 - EIS & Sec Range 3}"remediated") AND({HITRUST CAP Milestone Plan v2 - EIS & Sec Range 4}<=(2018,6,30),>=(2018,4,1)) I am trying to count if Range 3 (Status) is remediated and Range 4 (date completed ) is between 2 dates.…
-
Having Trouble with SUMIFS
I'm trying to create a condition based upon user submitted data for over budget flight requests. If the flight type is a One-Way, then whatever the pre-tax amount should be subtracted by the budget amount to give me the over budget amount. This formula is =SUMIFS([Flight Cost (Pre-Tax)]1 - 350, [Flight Type]1, "One-Way")…
