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. :(
We had a licensed user delete several files before leaving our organization. All of the sheets he owned have been transferred to someone else. However, there was one form we could not retrieve - Themed/Research Session Submission Form. Is there a way to recover that form? Any help is appreciated. Beverly Vance AMATYC…
Is there a way to save as a backup all sheets and workspaces? I am able to create a backup for all of the files shared with me. As the account's admin, can I back up all of the sheets and workspaces by all of our licensed users - even if they are not shared with me. We recently had a licensed use delete sheets and…
Hello all, I have a weekly report that I'm building and would like to be able to only expose two weeks worth of status. The report has a status and a commit date column and I'd like to remove anything that is "Done" and more than 2 weeks old. I'm trying to avoid having a report that has 100 rows of tasks that have been…
