I have a List of Street names and a Checkbox on a Source sheet! I like to copy the street names and the R-count to a summary sheet, but only if the checkbox is checked. I guess it will be best to have…
I have been working on the following problem for a couple of days, but I have not been able to get anything even remotely correct to work as desired. I can only get anything to execute if I tie the tw…
We are trying to move some Excel sheets into Smartsheet! In Excel, we have an address list in a sheet named “Main” and another sheet named “Street“. We extract the unique street names from “Main” and …
Calculate different % based on value in Column A The concept: Column A is either 0 or 1 Column B is the base value Column C is the Result If Column A = 1 Then Column C= Column B *0.86 Else Column C= C…
I was planning to have this Formular incorporated in our sheets, however I can’t find a way to accomplish this: The basic Formular is used to set a cell to either "1" or "0": IF(AND([Contract Date]7 -…