Multiple Checkboxes give different Text values

Hi, ok I have 3 columns with Check boxes, each one with a separate word, "Pre-Screen, Development, Test. I want have these word values show up on the same row in a different column when I choose the Checkbox.

I can get it to work for just 1 word on the row, how do I add the others in the formula so what ever checkbox is chosen in that row it will display that value?

=IF([Phase 1 - Pre-Screen]1, "Pre-Screen", "")

checkbox for Value.PNG

Find more posts tagged with

Product Development

Comments

Mike Wilday

You could use the following formula but it doesn't account for if someone clicks 1 and 3. It assumes that someone would click them all in order.

=IF(AND([Phase 1 - Pre-Screen]1 = 1, [Phase 2 - Development]1=1, [Phase 3 - Testing]1 =1), "Pre-screen, Development, Testing", IF(AND([Phase 1 - Pre-Screen]1 = 1, [Phase 2 - Development]1=1), "Pre-screen, Development", IF([Phase 1 - Pre-Screen]1 = 1, "Pre-Screen")))

You could also assume that if someone clicked off on Development that Pre-screen was completed too... or if they clicked off on testing, then the others were completed as well... and make the formula simpler.

=IF([Phase 3 - Testing]1 =1, "Pre-screen, Development, Testing", IF([Phase 2 - Development]1 =1, "Pre-screen, Development", IF([Phase 1 - Pre-Screen]1, "Pre-screen")))

mark.gipson27746

Hi Mike, Thanks for the information, I added 2 more columns and then did the formula like this

=IF([Phase 5 - Product Launched]1 = 1, "Product Launched", IF([Phase 4 - Review & Approval]1 = 1, "Review & Approval", IF([Phase 3 - Testing]1 = 1, "Testing", IF([Phase 2 - Development]1 = 1, "Development", IF([Phase 1 - Pre-Screen]1, "Pre-screen")))))

it works great. when nothing is checked the staus cell is blank, then whatever the last check box is checked it shows its status. and at the end when product is Launched, I setup a conditional format to show it 100% complete and the Strikethrough the entire row so we can move on to the next product.

See the attached. hopefully this can help out someone else.

Product DEV.PNG

Mike Wilday

Awesome. Glad I could help you out. Looks great!

Sign in to join the conversation!

Quick Links

Trending discussions

Contacts
I created a new project in my PMO, when I tried to pick a contact there were very few listed 7 versus the 165 people in my org. I checked My Contacts and all of the contacts were listed. Do I need to link that somehow to my sheet? How would I do that? Second question, what is the best strategy to keep My Contacts updated…
Viewer Vs Paid Membership?
Do you have to have a paid Membership on Smartsheet's to access a link in a worksheet? Or Can you just be a Viewer and still have access or open a link on a smartsheet?
Can workflows attach a document to an Update Request?
This discussion was created from comments split from: How do I set SmartSheet to include attachments on the emails that it sends from automation?.