Include "Date Submitted" as a column when exporting data
When exporting data from a process, the date an application, LOI, etc was submitted is not included...though the date it was created is. I think the more relevant information is when an application was submitted.
I recognize that date submitted is available via the dashboard; however, it adds several steps of trying to harmonize the dashboard copy paste to the data exported from GLM to achieve the same result. I might add that the dashboard date does not include the actual time an application was submitted...useful for those who have 5 pm cut offs for grant applciations and want to abandon those that slipped through.
Having the Submitted date as an export column would also be useful to help keep track of new applications as they come...allowing you to simply concatinate the new apps with the old ones in an existing Excel, etc. list. For instance, I have a process with lots (175+) applications that required a quick turnaround to send to reviewers. I often would export data from that process before it closed so that I could stay ahead of assigning appropriate subject matter experts to each application. Having the date submitted in the export column would have simplified things a bit for me.
Idea posted January 27, 2012 by Jim Beck, Parkinson's Disease Organization
Ideas
shared this idea
-
Ideas
commented
This is what we've been looking for too! Thanks for adding it in with the latest updates!
posted February 20, 2013 by Dana Jeffery, Ben & Jerry's Foundation
-
Grant Elliott
commented
Hi Jim,
This is a Great suggestion and one I've heard before so you're not alone! I'm going to keep a list of things to add to Export Data and hopefully we can get Submitted Date added in the near future. I know we have "Application Submitted Date" as a column when you export Grants but not Applications. I understand this isn't nearly as important as having it at the Application level so we need to do this. Let me know if you have anymore suggestions on things you'd like to add and thanks for the input!
posted April 3, 2012 by Grant Elliott, Foundant Technologies