Looking for a formula to convert text to a number.
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
Best Answer

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)
Answers

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)

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

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

Thanks again. Works great!
Help Article Resources
Categories
Check out the Formula Handbook template!