I have found other threads for this, and tried this formula
However, I get error #BOOLEAN EXPECTED
I have parent rows and grandparent that I would like to calculate
Hi @Randy Van Winkle ,
The column you place this formula in needs to be formated as text/number to prevent the error. Looks like it's probably a checkbox.
Move it to another row and use =COUNTIF(Descendants([original name]@row),1) where [original name] is the column name you want counted.
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Hi Mark, Thanks for answering. Unfortunately i have almost a hundred columns so that would be a bit cumbersome. I found another workaround in using +'' after the formula. However that prevents the "number" from being used in a chart on dashboard.
Don't know if it works for you but if you change the column from checkbox to symbol and use a symbol other than Flag or Star the formula will return a number.
I had the same issue with the checkbox returning a Boolean Error. I changed the checkbox to a symbol and the error went away.
Hi @Geoff Baker
I hope you're well and safe!
Another option would be to add +"" at the end of the formula.
I hope that helps!
Be safe and have a fantastic weekend!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I created a timesheet and a form to go along with it. When someone uses the form and flags that someone has called off, I want the flag to return zeros in the ST Hrs, OT Hrs, and DT Hrs cells. Using AI to generate the formula below, it returns a Circular Reference error when the formula is placed in the ST Hrs cell.
Hi there, I'm building out a new sheet where I utilizing the system's "Last Modified" date column. I tried to trigger a workflow off of this column that sends an update reminder if it hasn't been modified in 2 days, but the column is not showing up as an option (presumably because it's system generated). With that in mind,…
Hey All! Currently, I have a formula that if it is the Parent row (helper column shows 0) then Index multiple sheets using the SSI column. If it is a children row, use the parent SSI column to Index multiple sheets (pulling the same result). The only issue is if I have a child within a child, then the PARENT(SSI@row) no…
©2024. All Rights Reserved Smartsheet Inc.