-
Derive status based on status selected for child rows on multi level
Hi All, I have a testing sheet which has Test Scenarios (Level 0 -> Grandparent), test cases (Level 1 -> Parent) and test steps (Level 2 -> children). I am trying to formulate the status for test scenarios and test cases based on the status of all the test steps. My current formula is stated below. It is working perfectly…
-
Formula not working on one data base but does on others
Hi I am using the following formula to count the number of people who have declined a training invitation: =COUNTIFS({Training Sessions Registration and RSVPs Range 5}, "Training Session", {Training Sessions Registration and RSVPs Range 4}, "Organisation", {Training Sessions Registration and RSVPs Range 3}, >=DATE(2023, 3,…
-
Vlookup & IF
Hi team, I am trying to refer to another sheet which has active and inactive employees on it, some are returned employees so their name is twice on the sheet. However I only want the Vlookup to refer to Active employees. I've tried these options with no success - =IF({HRMS Current & Ex Employees Range 1} = "Active",…
-
Nested IF and percents
This discussion was created from comments split from: How to use multiple IF and AND functions for symbol formula.
-
Formula for Smartsheet PMO Template Project Plan Schedule Health
I have set up a Schedule Health Formula in the Project Plan where it calculates the Schedule Health based on the Health of the Children Rows. For Example, if 1 of the 6 Children Rows(Level 2) is Red then the Parent Row(Level 1) is Yellow and if there are 2 or more Children row(Level 2) are Red then the Parent Row(Level 1)…
-
Formula to count # of certain status symbol
Hello, I have created a column/dropdown with Symbols Green, Red, Yellow, Gray. I'd like to count the number of cells that have Green status in Status column. (in other words, count the # of Green(s) symbol. In searching Smartsheet community, I saw a reply from 2017 regarding a similar question. The suggestion was to use…
-
Sheet Summary - Not Equal to a value "On Hold" as well as any records where [Status] is blank
How can i capture the counts on a sheet for rows with a status that is BLANK and <>"On Hold"? I can do one or the other but cant seem to get both combined.
-
Current Week Formula Question
Hi all! I have a current week formula on a sheet =IF(Week@row = WEEKNUMBER(TODAY()), 1) For the week we are currently in, it is counting Monday as the beginning of the week and I need the week to start on Sunday. Is there a way to adjust this with my forumla?
-
Nesting SUMIFS in IF
Hello, is it possible to nest a SUMIFS within an IF statement to say If the value of this sumifs is greater zero display the sumifs, but display nothing if the value is not greater than 0?
-
Countifs but leaving blank spaces if criteria is not met.
Hello I am trying to find a formula that would provide me with the correct total count of weekly items, but leave the cell empty of future weeks. Here's the formula that I have used so far and it works but I provide me with 0s for future weeks. The intent is to leave those week blank. =COUNTIFS({Weekly Snapshot 3 Range 1},…