Looking for a formula to convert text to a number.

dennis.goudy72296

I know this is a basic formula in Smartsheet but I am making it harder than it needs to be.

Here is what I want to complete:

If a name is inserted into a cell I want it to add the number "1" in a helper column. So, not sure if it is a CountIf or an IF Formula. I am close, just not sure what I am missing.

The formula I am putting in the helper column is: =COUNTIF([Instructors from Dropdown]@row, "1") It places a "0" in the helper column instead of "1". I do want it to put a zero in the Helper column if no name is inserted in instructors from Dropdown.

So there is obviously some missing parts to my formula.

Thanks Team for any advice or help with this.

Dennis

Carson Penticuff

So you want 1 if there is an entry and 0 if there is not? Try this:

=IF(ISBLANK([Instructors from Dropdown]@row), 0, 1)

Carson Penticuff

So you want 1 if there is an entry and 0 if there is not? Try this:

=IF(ISBLANK([Instructors from Dropdown]@row), 0, 1)

dennis.goudy72296

Fantastic! Once again the SS Community comes through. Works perfectly. I was researching the Formula Handbook and drilling down to some other ideas but, a BIG DUH! the IF(ISBLANK formula is a great solution.

Thanks again so much.

Dennis

Carson Penticuff

Glad to help. This same formula will also work if you set your helper column to a checkbox.... 1 = checked, 0 = unchecked.

dennis.goudy72296

Thanks again. Works great!