Using Form for updating existing information

Options

Hi,

I have a requirement in my project to collect project information once in 2 weeks from every project. There are about 12 projects running in my program and I want to collect status once in 2 weeks for my status update to stakeholders.

As a first step I used a form to collect initial project details from all projects but I want this to be updated for every 2 weeks.

Is there any possibility to use the form to fill the last updated information from each project and share it with each project owner to collect additional/update info? If form is not the solution is there any other approach I can use to collect the info?

Any help would be really helpful!

Thanks in advance,

~Chitta

Answers

  • Mike L.
    Mike L. ✭✭✭
    Options

    Can you give a little more detail? What information are you collecting? Can you provide a few field names or just describe in general terms? I'd like to think you can have sheets for each project where updated information is entered and you can pull it all together using reports.

  • Chitta
    Chitta ✭✭✭✭
    Options

    Hi Mike,

    Thanks for your response and appreciate your help.

    I have below columns which I collect from various projects:

    Program name, Project Name, Business, Release details, owner, project coordinator, training plan, geography wise no of impacted users, uat dates, prod live date, end user launch dates and many more.

    For dashboard, I want interactive so I am not sure if reports helps in this regards. I am thinking I will pull data directly from sheet along with summary sheet for my dashboard.

    But any advice, suggestion would be really help.

    Kind Regards,

    Chitta

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!