Hi! In a previous role, I create a Google form for people to complete and it populated a Google worksheet. We also used this to ensure staff were appropriately assigned to their portfolios and could ask for help from other grant managers if needed. You could manually update the sheet if a proposal is awarded.

> On Sep 19, 2024, at 3:51 PM, xxxxxx@gmail.com wrote:
>
> Hello All!
>
> I was wondering if any of you had a Proposal Tracking Spreadsheet that you really love.  We’re trying to track our awards from idea, through PreAward, IRB Approval, potential entering on clinicaltrials.gov, potential PI Conflict of Interest submission, Grants and Contracts, through to PostAward Invoicing, Payment Applying, Closeout, etc. etc. :)
>
> I work for the UVA School of Medicine, and while different departments manage different aspects of this process in various systems, our Docs would like us to keep up with where exactly each study is currently sitting. I’ll be working on ideas for this next week, and thought I would pick your brains if you’re willing!
>
> I appreciate your time and this community so much, and hope your week is going well so far!
>
> Emily Rolen
>
> - = - = - = - = - = - = -
> This email was sent to xxxxxx@gmail.com via the Research Administrator's mailing list.
> To unsubscribe from RESADM-L, go to https://lists.healthresearch.org and enter your subscribed email address into the "My account and unsubscriptions" area at the bottom of the page.  This also allows you to switch to Digest Mode or to temporarily suspend emails.  You will be emailed a link to change all these settings.
> List archives are available at:  https://lists.healthresearch.org/resadm-l