Sign in to join the conversation:
how can I count specific open ports that are separated by a comma?
Try something like this...
=LEN([Open Ports]@row) - LEN(SUBSTITUTE([Open Ports]@row, ", ", "")) + 1
Basically you are finding the total number of characters (including spaces) and subtracting from it the number of characters once all of the comma/space's are removed. You then add one to account for the final entry, and there you have it.
Hi Paul,
I tried this and the "@row" was giving me an error, once I removed it, then the formulat worked. thanks.
In my case it works, I just need to figure out now when the cell is blank to return a 0 because it is returning a 1.
thanks again for posting this.
Jm
You may have already figured this out.
You can wrap Paul's formula in an if-isblank handler to get the 0. =IF(ISBLANK([OPEN PORTS]@row), 0, LEN([OPEN PORTS]@row) - LEN(SUBSTITUTE([OPEN PORTS]@row, ",", "")) + 1)
@Paul Newcome is the SmartSheet guru!
Tried to use this for names (first and last, first and last) and it's not working. :(
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
I have a picture below for an example of this. I want to create a formula to get counts of items in "Column2", but if "Column4" states "change" I want the "Column2" count to not work and instead count what is it "Column3" in that given row. Column4 can also have several different things in it besides "good" that I want it…
I've done this a million times - create a report, separated by campus with a total $$. Then add it to a dashboard and make a graph. NOTHING is working right now when I try to do this. I get an error that the data cannot be charted. What the what? Help anyone? Is this a issue since they apparently changed something in the…
