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.

Auto fill gaps

Roberto Simões
Roberto Simões ✭
edited 12/09/19 in Archived 2016 Posts

Good afternoon, 

 

I would like to know if it is possible to autofill a gap by using a code in a formulary. For example: 

Code number 5678 - WALLMART STORE 

When the code is entered automatically a gap is filled.

Is it possible ? 

 

Regards,

Tags:
· Share on FacebookShare on Twitter

Comments

  • Christian Wells
    Christian Wells ✭✭

    If you are talking about entering 5768 in one field and then having Wallmart Store in another. this will only be possible with up to a few entries using an If Calculation.

     

    =IF(Cell = "5768", "Wallmart Store",     IF(cell = "numbers", "Text",      ..........) )

     

    For anything more than a few (7 I think)  there is no solution (i know of) in smartsheet.

     

    There is no List validation or lookup like this in smartsheet.

    .....You could export to excel  do what you need to and reupload.

     

     

    · Share on FacebookShare on Twitter
  • Atus Bartal
    Atus Bartal ✭✭✭✭✭✭

    Another vote for Dynamic lists? Surprised

     

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

Categories