Formulas
Discussion List
- Hi, so obviously if I want to have a given cell in one sheet reference another cell in a different sheet, this is easily achieved. But let's say I want cell A1 in one sheet to reference A1 in a differ…
- I think I am off my game. I cannot for the life of me figure out how to use NOT in a cross reference formula... I have a sheet with tons of data and am referencing a status column that has four option…
- 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…
- 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), potentia…
- 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 follo…
- 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 b…
- 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 ne…
- 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 ano…
- 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 wor…
