For example, if a cell contains the number 4500 and I want to count how many times 0 appears, I'd expect the formula to return a value of 2. Every formula I've tried simply checks if 0 is in the string at all and returns 1 for true and 0 for false.
=LEN(String@row) - LEN(SUBSTITUTE(String@row, "0", ""))
Hey @Logan Burke
Building on Paul's formula above, if the number(s) you are searching for are more than one digit long you might need this. The x represents the number(s) you are searching for.
(LEN(String@row) - LEN(SUBSTITUTE(String@row, "x", ""))) / LEN("x")
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.