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.

Using "Created by" as "Assigned to" for Resource Management


I'm using a web form to collect vacation request, etc. and added a System-generated column to automatically add the Created by. The form is only available to registered Smartsheet users.

Now I want to see these absences in the Resource View and to do so I need an Assigned to column. Is it possible to somehow connect the two columns? I assume if I ask the users to fill the Assigned to column with their name manually, it wouldn't work either, correct?

Or is there another way to get information collected by a web form into the resource view without manual processing of each row of data?



  • Corinne Flanagan
    Corinne Flanagan Employee
    edited 09/12/18


    Currently, there isn't a way to link the "Created By" and "Assigned To" columns or use a system column in Resource Management. You could include "Assigned To" on the form, which would populate the row so there would be no need to manually edit the sheet data.

    Check out this article on Resource View from our Help Center: https://help.smartsheet.com/articles/1346971-resource-views

    When you have a moment, please submit a product enhancement request to let our Product team know that you'd like the ability to automatically populate the “Assigned To” column on a sheet. The product enhancement request form is located in the Quick Links section to the right of this discussion.

This discussion has been closed.