Column in Main Sheet: Ultimately meaning there are T-X days until resolution action is needed (helper column). I have thrown the ranges that I am wanting to report in to another sheet, for calculating…
I am building a safety event submission sheet and I wanted to add some metrics to a dashboard. If an event is submitted, that day is considered a "Red" day and if no events were submitted it is a "Gre…
Hello, I have a question about creating a specific formula. What I want to know is: how many columns has a value? From the columns Dgn_Funct, Dgn_DEV, Dgn_Int, Dgn_ BI. What is the best way to set up …
Hello, I am trying to set up a formula that would count a contract number that is in a cell that allows multiple drop downs. I have looked up "Has" and "Contains" and I am pretty sure I am just follow…
I've tried a couple different formulas and can't get it to work, probably something small I am missing. Can anyone help? =IF({MY25 CTM Detail Report Range 1} = 0, " ", COUNTIFS ({MY25 CTM Detail Repor…
I have a formula I need help with for the top level of my project checklist hierarchy. Overall Project Status - this is looking only at the highest level rows which are indicated by the helper column …
I have a formula I need help with for the top level of my project checklist hierarchy. Overall Project Status - this is looking only at the highest level rows which are indicated by the helper column …
Hey Guys I wonder could i pick your brains to iron out the kinks in my formula I would like to calculate a % based upon the following references Sheet Reference {EPIC} Value "GBT-xxxx" Sheet reference…
Hello! Got a problem that's confusing me because I'm used to Excel and can't find a way to do this on SmartSheets. Context: I have a CSV that I export from a database that contains info about design i…
I am using the Sheet Summary to input formulas helping me to track the COUNT of installs that took place in a given month/year. But now I want to SUM how many assets were installed at that location us…
