Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Hi all,
I've tried a few different formulas but can't figure out how to count the # of checked boxes in a column. My column is labeled "Approved" and has 131 cells, so I tried:
=COUNTIF(approved1:approved131, 1)
But I'm getting #BOOLEAN EXPECTED
That particular error means the formula is in a specific type of column (Date, Number, Symbol) and the returned value is of a different type.
You can either move the formula to a different column, or convert the result to the appropriate type.
Formula results may be converted to text values by adding an empty string. For example =TODAY() + "" will allow you to enter today's date into a text column.
What column type are you entering the formula into? That particular one needs to go into a text/number type column.
I have a Parent row that is showing this =MAX(CHILDREN()) Which I definitely need. The intent is to show if an institution needs to change hours if there's a positive number. However if there's 0 or a negative, the institution is on track. However, the formula is also showing the highest negative number if the institution…
Not sure what to title this, because it's not really Cell Linking the way we talk about it with Smartsheet… I have two sheets, Project Sheet has project rows and a column that lists animal species impacted (currently text, but could be multi-dropdown if that helps?). The second sheet (Species Sheet) has "more info" on…
I need the Date of Sample Shipment to start within 20 days of the Date of Manufacturing Start Date. However, the predecessor I have there isn't working properly. What should it be? Thank you so much
