Jgorsich
Jgorsich
Reactions
-
Re: How can I make COUNTIF into a column formula?
I feel your pain - I'm a big fan of using the same technique in Excel and finding a work around was a big priority for me. Luckily, I've got one for you! First, you'll need to add some kind of counte…1 · -
Re: Function for Counting Children of Parent Rows
@JamesQ4 - Not knowing your sheets makes it impossible to give a specific answer, but I suspect you are going to need to incorporate a collect() function or a helper column to make this work. Countif…1 · -
Re: avg a column of days if they equal a value in another column
When you start typing the formula into Smartsheet, it will pop up a small text showing you how the formula is layed out. You've got yours setup backwards. The order is "range you are evaluating&…1 · -
Re: Formula to return a checkbox on Sheet B, if a % column in Sheet A = 100 + move rows
Your "Task Name" column has a space in it, so you have to put square brackets around it when using it in a formula (same if you have numbers in it, btw. No downside to ALWAYS using square b…1 · -
Re: Progressive totals working with column formulas.
A lot of stuff that SEEMS like it can't be done as a column formula (due to needing a reference to a fixed cell or a summary formula) CAN be - if you are willing to become a bit inefficient in digita…1 ·
