Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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,
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.
Another vote for Dynamic lists?
