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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!