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.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!