How do I make a form field's visibility dependent on 2 fields?

Hi,

I've been struggling with this with my favourite AI for over an hour now and I've hit a wall. I want to implement the following:

if [CheckboxA]

show field 1

if [CheckboxB]

show field 2

if [CheckboxA and CheckboxB]

show field 3

There is no way to do this within SmartSheet forms. You have to have a helper column in the sheet. However, once you implement the helper column as a (column) formula based on the values of CheckboxA & CheckboxB, SmartSheet prevents the inclusion of the helper field in the form. At least that's what I've found. Has anyone ever got around this (ludicrous) restriction?

Thanks,

GAM

Find more posts tagged with

Forms

Sheets

Formulas

functionality

Accepted answers

All comments

nicksnav

Good evening, @gamgc ! I cannot seem to find a way to have logic based on two separate cell conditions either.

Maybe not as pretty as you would like it, but instead of a formula-based helper column could you just create another checkbox column simply to be checked if A and B were both checked? That way

Or, you could make it a dropdown multiple selection cell with the Checkbox A and B questions spelled out on the forms cell {help text}. Then if multiple selections are made, display field number 3. There might be nicer ways of doing it, but maybe this will inspire other solutions if these don't work. Have a great night!

gamgc

Hi Nick ,

Thanks for your response, but that won't cut it, I'm afraid. The questions have to be asked in isolation from each other. I am astonished at the apparent lack of ability to implement this relatively simple conditional logic in SmartSheet forms.

I wish you a great day from Oz :)

Thanks,
GAM

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.