-
COUNTIF USING OR
How do I add an OR to the expression and logic: ="Resource: " + COUNTIF(CHILDREN(Status1:Status17), "Terminal Updated") + " of " + COUNT(CHILDREN(Status1:Status17)) I want to add both Terminal Updated and Terminal Replacement to the count. Any help greatly appreciated!
-
Functions for predecessors
Are there Smartsheet functions for enumerating the predecessors of a row? I've been prototyping SmartSheets for managing a pretty sizeable research project (multiple FTEs over several years), potentially replacing Asana for group project management. The reporting is nice, as is the combination of spreadsheet, gantt, card,…
-
Formulas for counting number of types of rows for different months/ financial years
Hi, I currently have a sheet where we follow up leads / quotes and am wanting to create some formulas, either on the same sheet or in another sheet (so user doesn't see all formulas). I have the following columns (just a few of what i have): Status (which has quotation won, quotation abandoned, quotation lost) etc. Date…
-
COUNTIF between Dates (Children) || Summary
I have a formula that is troubling me. I am trying count between two date ranges so I can count the number of shows due (between a set date ranges or set to count only the next 14 days). The forumla below is returning zero. Is it the forumnla or a setting? The screen cap below is the from the sheet I am using, hopfully it…
-
Determine RYG ball color based on rows below
Hello, I'm trying to write a formula that'll allow me to look at the color of the RYG balls in some rows, find the lowest color and set that as the main color for the overall project. So, Project A needs a status. I'd like to look at tasks 1-5; if any of them are red, the entire project status needs to be red. If any of…
-
Restricting dropdown lists using VLOOKUP
Depending on values in one column I want to restrict the dropdown list in another column Example: I have a sheet: Employees Role Name ------ ------------- PM Jane PM John Dev Mark Dev Stephanie In another sheet where Tasks I have these same two columns Role and Name Once I enter the Role (say PM) it should automatically…
-
Rule (Formula) to Check a box if the create date is past 90 days
Thanks for checking this out as my formula game is pretty weak. I am looking to have a formula that will check a box if the create date is 90 days in the past provided another box was checked.Real world I want to call out all statements of work that are older than 90 and we have not received a purchase order (PO received…
-
Sum Children If other cells are Checked
Hello Community, I'm trying to get a sum of children cells if a checkbox in another column is checked. For instance, if Column A has row 1 checked, I want the Column 10 row 1 counted as part of the sum.
