-
Health Formula
Please can you assist. I am currently using the SS Standard template Schedule Health Formula : Project Heath Formula =IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", "Green")) My issue - Milestones which should not be are showing green because the Duration is Zero (see schedule formulas…
-
Project Health Calculation
Please can you assist. I am currently using the SS Standard template Schedule Health Formula : Project Heath Formula =IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", "Green")) My issue - Milestones which should not be are showing green because the Duration is Zero (see schedule formulas…
-
Keyboard shortcut to delete a row
Hi Everyone, I am used to working in excel and using keyboard shortcuts to navigate my sheets without having to use a mouse. Is there a keyboard shortcut to delete a row? if not can how do I let the product team know to add this to the development queue? thanks!
-
#INVALID DATA TYPE for some functions using DATE
Hi: I am trying to generate a sum (cumulative) of all effort "points" for projects started in the current year. CASE 1: My reference columns are: "Project Start" (date) and "Effort Count (Est. Total)" (text/number). I used the formula: =SUMIF([Project Start]:[Project Start], YEAR(@cell) = 2020, [Effort Count (Est.…
-
At Risk Column - How do I count this in my Summary Sheet
Hi Smartsheet Community, I am in Summary Sheet for my Project Grid. I want to count the number of "At Risks" that are Flagged. I have tried =COUNTIF({At Risk}, "Criterion"). I have tried "Flagged", "Flag", "On" and "True", but none of these are working. Can someone help me with this please? I'm sure it's something simple.…
-
COUNTIFS Referencing another sheet and pulling data from a specific time period
Hello, I am trying to create a formula that will pull the number of times an entry was submitted for a specific location from another sheet, but I want to set the date it should start counting from and no end date. The data that the formula will compute I will then use as a reference cell for a chart I created on a…
-
Project stage and date in the Future
Hello Smartsheet super formula humans! I need some assistance! We are trying to create a formula where a checkbox is checked if the project meets the below criteria. Recurring On hold Pending approval + In Progress with a Go-Live date of after 3/31/21 The Recurring is its own checkbox without a formula, the On Hold,…
-
Totals and Sub Totals
Sorry if this is an obvious question but I am new to Smartsheet and I am trying to get my head around Totals and Sub Totals. In our Project Plans we have 3 columns relating to Effort: Planned Effort Time Spent Effort Remaining What I need is to be able to get a Total for each column in say Row 1 and Sub Totals for each…
-
CountIF Symbol & Between 2 Dates
Can someone help me with a formula that would count all the "Flags" in the "Work Related Exposure" if the "Created" date is between two dates ("Encounter Date" and "Date Resulted")?
-
Sumifs with multiple criteria and cross-sheet referencing
Good day, I am struggling to get the formula for sumifs. I have used both options below but it does not work. SUMIFS({Description} = Description2_{Stock Request} > 0; [{Sub-warehouse}; "Brandon"]) SUMIFS({Description} = Description2; {Stock Request} > 0; {Sub-warehouse}; "Brandon") I need the quantity to be summed if the…