Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Linking checkbox to another column

Hailey Loutsch
Hailey Loutsch ✭
edited 12/09/19 in Archived 2017 Posts

We have a checkbox in our sheet titled "Use Existing". When that box is checked we would like for another column to be added so the person can provide that existing information. If the box is not marked then we don't want that extra column to appear. Is there a way to make this happen? Not sure if there is a formula for this ?

· Share on FacebookShare on Twitter

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    No, there is no way to accomplish this feat... you might consider using conditional formatting and black out the column. Then when the checkbox is checked have the background color of the cell turn white and the text turn black. This would allow the user to type in the column. it would have to always appear, but it would be untypeable with black type and black background until they check it off. 

    · Share on FacebookShare on Twitter
  • Hailey Loutsch
    Hailey Loutsch ✭

    Okay thanks for your help!

    · Share on FacebookShare on Twitter
  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    edited 05/18/17

    You're welcome. You do need to know that if they are working on a report, that the conditional formatting will not apply until after the check, save and refresh the sheet. If they are working on the sheet themselves, then it should instantly turn white. Reports are "almost live." But not quite. 

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories