Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Form drop down selection query

Hi,

Is it possible to create a form based off a sheet where you can select an entry already in the primary column which would then allow you to update specific other columns?

image.png

I would like to have a form where I can select an entry in T Number column, then update Cal Due, In Cal checkbox and comments columns.

Is this possible?

TIA!

Tags:

Best Answer

  • Community Champion
    Answer ✓

    @WillH This is not possible using Smartsheet forms. You can:

    1. Send an update request for a specific row, which is form-like in appearance
    2. Use another solution such as Appsheet (it is really easy to do this in Appsheet by the way). The video below shows selecting an existing row based on a value in the row encoded in an NFC tag. Much more than you are looking to do, but my point is that you can use Appsheet to select the row you want to edit from a dropdown :)


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions