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. :(
How can you get rid of the uncategorized land in a report timeline view?
Please help! I understand that we can't customize the gantt chart bars anymore if it is a parent row but why am I getting random colors on the bar view in my report? I would prefer it remain grey. The first picture is the Smartsheet and the second one is the report pulling from the sheet.
Trying to understand why we don't have the option to remove a status by automation. For example, when external customer approves a proof, it fills in "APPROVED BY CUSTOMER" which then triggers automation, but the existing status of "SENT TO CUSTOMER FOR APPROVAL" remains as I cannot set automation to do that.
