Autofill cells when new line is created

Options

Hello,

I'm trying to figure out if, when a new line is getting filled out on my SS, can a workflow be created that will autofill a certain cell within that row to a particular choice within that dropdown list? In other words, someone enters a new row and starts filling out the required info. As soon as that info is starting to be filled out, I'd like that "Status" cell to show "Pending" right away. As certain things get filled out, we can change the "Status" to other choices in the drop down.


Thanks

Answers

  • Frank S.
    Frank S. ✭✭✭✭✭✭
    Options

    Greetings @Walt L,

    The short answer to your question is yes.

    To start, the initial trigger should be set to When rows are added; if you want this to occur when rows are changed, select When rows are added or changed.

    Now you can add your conditions based on the criteria you want. If you want more conditional paths, select add condition path using the blue +.

    For example, Where the Column name is one of the criteria and the action you want.

    You can add additional conditions with and/or.

    I hope this helps and gets you started in the right direction.

    Frank Smith, PMP

    Assistant Director | IT Special Projects Mgr.

    Oregon Parks & Recreation Department

    If my response helps, please mark it as an accepted answer. 😎

  • Walt L
    Walt L ✭✭✭
    Options

    Thank you for responding. Shortly after posting, I realized that I pretty much had this set up p/ your notes, but bc there was already data in the rows previously, the autofill was not working. So, I scrolled down many lines and entered some data and the autofill worked.


    Much appreciated.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!