tag:blogger.com,1999:blog-8859052.post114736952457140385..comments2023-10-29T07:40:12.047-04:00Comments on Joel Explains It All: Recently Updated documents in SharePointJoelsefhttp://www.blogger.com/profile/10695165187531657921noreply@blogger.comBlogger30125tag:blogger.com,1999:blog-8859052.post-33590386162228014332016-04-01T22:31:48.197-04:002016-04-01T22:31:48.197-04:00You need to edit the view or switch to another vie...You need to edit the view or switch to another view. I assume you're on a newer version of SharePoint than 2003? :-)Joelsefhttps://www.blogger.com/profile/10695165187531657921noreply@blogger.comtag:blogger.com,1999:blog-8859052.post-46020350541969221472016-04-01T14:04:24.397-04:002016-04-01T14:04:24.397-04:00When I set this up, the view contains no documents...When I set this up, the view contains no documents at all. How can I go back and modify the column View Until? In case that's the issue alemieux3https://www.blogger.com/profile/11215960381632229282noreply@blogger.comtag:blogger.com,1999:blog-8859052.post-49760146635225365542011-07-05T18:50:14.374-04:002011-07-05T18:50:14.374-04:00Anonymous: You could create a roll-up, using a Dat...Anonymous: You could create a roll-up, using a DataView or a 3rd party web part, then filter it by date and group it by type or site.Joelsefhttps://www.blogger.com/profile/10695165187531657921noreply@blogger.comtag:blogger.com,1999:blog-8859052.post-68362748206787487522011-06-20T13:01:34.330-04:002011-06-20T13:01:34.330-04:00Is there any way to show "Latest Documents&qu...Is there any way to show "Latest Documents" that are posted through out the entire Sharepoint instead of library by library?<br /><br />E.g. Top latest doucments in folder A, B, C, D, etc.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8859052.post-78716688617437774362010-01-15T16:47:49.088-05:002010-01-15T16:47:49.088-05:00I figured that might be the case. I might need to ...I figured that might be the case. I might need to talk with our IT people to see if there is a alternate method to get those results. <br /><br />I appreciate the reply!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8859052.post-4243790685194129672010-01-15T15:21:25.525-05:002010-01-15T15:21:25.525-05:00Yeah...this doesn't show version history which...Yeah...this doesn't show version history which is what you want. This only sorts by last modified date. Subsequent modifications are not listed, only the latest.<br /><br />Not sure how'd you'd do this out-of-the-box. Maybe require some coding to get a list of Recent Updated versions.Joelsefhttps://www.blogger.com/profile/10695165187531657921noreply@blogger.comtag:blogger.com,1999:blog-8859052.post-67660007050341573592010-01-15T14:15:55.487-05:002010-01-15T14:15:55.487-05:00Will your technique allow a single document that h...Will your technique allow a single document that has been updated multiple times to display a separate entry for each update? I'm trying to find a way to display it so that it lists recent changes, as opposed to just recently changed documents.<br /><br />The documents I work with update frequently concerning policy, and I keep a list of recently updated documents on the front page so that staff can read the version comments to see what has changed. <br /><br />Thus far, though, if I update a single document more than once, it simply moves that document to the top of the list and replaces the older update with the new one, and that is less helpful. <br /><br />Any tips?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8859052.post-14222459113860988752009-12-24T05:23:48.644-05:002009-12-24T05:23:48.644-05:00Joel - many thanks :)Joel - many thanks :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8859052.post-51165385463811160652009-12-24T05:06:38.217-05:002009-12-24T05:06:38.217-05:00In the view settings (either in the list or in the...In the view settings (either in the list or in the web part) you can turn off the display folder hierarchy and just show all documents in a flat structure (and use filtering of metadata to navigate). Check out the "Folders" section in the list view settings page. Expand the "Folders" section and choose "Show all documents without folders".Joelsefhttps://www.blogger.com/profile/10695165187531657921noreply@blogger.comtag:blogger.com,1999:blog-8859052.post-6255105716308770942009-12-24T04:55:08.432-05:002009-12-24T04:55:08.432-05:00Hi Joel
Your instructions on how to show "re...Hi Joel<br /><br />Your instructions on how to show "recently updated/added" documents have been very helpful. However, I still have a problem with the way Share Point ends up displaying this on my homepage:<br /><br />When uploading/modifying a single document (e.g. .ppt) that is located in a folder, Share Point shows the folder under instead of the actual document that has been modified. How can I program Share Point to only show me the document and not the folder where the document is located? <br /><br />Many thanks for your help<br />ElenaAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8859052.post-60069281199224039272009-01-03T10:28:00.000-05:002009-01-03T10:28:00.000-05:00Hi Jason,You can modify the view for a list or lib...Hi Jason,<BR/><BR/>You can modify the view for a list or library web part to do the same thing, if the list or library is part of the same "site."<BR/><BR/>I assume your issue is that you have a lot of subsites and want to aggregate the most update items on the home page. <BR/><BR/>I haven't done this myself, but it should be possible with the MOSS Content Query Web Part or the Data View web part (in SharePoint Designer). It's not as straightforward as editing a list web part, but they're actually more powerful if you know how to manipulate them.<BR/><BR/>JoelJoelsefhttps://www.blogger.com/profile/10695165187531657921noreply@blogger.comtag:blogger.com,1999:blog-8859052.post-63850574779988960562008-12-29T14:07:00.000-05:002008-12-29T14:07:00.000-05:00Joel,This is a great fix for document libraries.An...Joel,<BR/><BR/>This is a great fix for document libraries.<BR/><BR/>Any idea how to do this for the Sharepoint homepage? I would like to post a webpart that displays all recently updated (or uploaded) files, lists, discussions, etc.<BR/><BR/>Thanks,<BR/>JasonJasonFhttps://www.blogger.com/profile/05063034474984360323noreply@blogger.comtag:blogger.com,1999:blog-8859052.post-35828309848901094012008-11-22T13:49:00.000-05:002008-11-22T13:49:00.000-05:00Thanks, Ryan. :-)Thanks, Ryan. :-)Joelsefhttps://www.blogger.com/profile/10695165187531657921noreply@blogger.comtag:blogger.com,1999:blog-8859052.post-41037524947446936972008-11-22T08:53:00.000-05:002008-11-22T08:53:00.000-05:00I am trying to put the record straight that this D...I am trying to put the record straight that this DOES NOT WORK in WSSv3/MOSS. It will not update, see http://blog.pentalogic.net/2008/11/truth-about-using-today-in-calculated-columns/ for details and some workarounds.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8859052.post-21655763772895045192007-12-31T16:21:00.000-05:002007-12-31T16:21:00.000-05:00Fransesca,the easiest way to do it is make that "m...Fransesca,<BR/><BR/>the easiest way to do it is make that "meeting month" column a *choice collumn* and then have your options as you said before. as you enter data you can select...say January.<BR/><BR/>Then you make a view and for the filter put this:<BR/><BR/>if: [Meeting Month] is equal to *insert current month here* <BR/><BR/>so for example you could say:<BR/><BR/>if [meeting month] = January.<BR/><BR/>The only problem with doing it this way, is you would have to change the month each month. that isnt too bad tho :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8859052.post-37651277177728967452007-12-06T18:38:00.000-05:002007-12-06T18:38:00.000-05:00Oh, this looks good. Here's a variation. I want to...Oh, this looks good. Here's a variation. I want to create a view that will show all documents that have a "Meeting Date" of the current month - so if it's November, I'll see all documents for November meetings, if it's December, the December meeting doc set, etc.<BR/><BR/>I want to use the view with a web part on the site home page so that the docs for the current month's meetings display, then people can go to the library for the year's meeting docs.<BR/><BR/>I also have a column called "Meeting Month" that is a written out version of the month (January, February, March, etc.) which I use for grouping, if that gives you a handle.<BR/><BR/>Many thanks in advance,<BR/>FAWUnknownhttps://www.blogger.com/profile/14204246230569558906noreply@blogger.comtag:blogger.com,1999:blog-8859052.post-61038948144551025812007-11-30T12:19:00.000-05:002007-11-30T12:19:00.000-05:00Hey Joel, great little tutorial. i know its prett...Hey Joel, great little tutorial. i know its pretty old...lol but i have a question.<BR/><BR/>when you start making the view and you go:<BR/><BR/>Show the items when column<BR/>ViewUntil<BR/>is greater than or equal to<BR/>[Today]<BR/>*and*<BR/>Modified<BR/>Is greather than equal to<BR/>*date*<BR/><BR/>is there away for the *date* to be a formula? like<BR/><BR/>modified <BR/>is greather than or equal to<BR/>[Modified]+14 or something? (14 being 14 days)<BR/><BR/>should i make another column and have it as a date and time, then make it so that [today] is greater than or equal to *date entered*(i already have a column for that)+14<BR/><BR/>or something like that?<BR/><BR/>i almost have it. just need a little bit more help.<BR/><BR/>Thanks.<BR/>PaulAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8859052.post-31507636056492775222007-11-29T17:37:00.000-05:002007-11-29T17:37:00.000-05:00Works great. Of course had to modify to meet my re...Works great. Of course had to modify to meet my requirements, but was easy. Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8859052.post-33464209507276883462007-09-05T11:05:00.001-04:002007-09-05T11:05:00.001-04:00You might find this useful: http://www.sharepointb...You might find this useful: <A HREF="http://www.sharepointblogs.com/mkruger/archive/2007/06/26/using-today-in-a-calculated-formula-birthday-lists.aspx" REL="nofollow">http://www.sharepointblogs.com/mkruger/archive/2007/06/26/using-today-in-a-calculated-formula-birthday-lists.aspx</A><BR/><BR/>However, I did it and it's not working 100%. When the month changes over, the [Today] value doesn't change so it still thinks it's the month when you created the calculated column.Joelsefhttps://www.blogger.com/profile/10695165187531657921noreply@blogger.comtag:blogger.com,1999:blog-8859052.post-87101252106473919372007-09-01T22:46:00.000-04:002007-09-01T22:46:00.000-04:00I'm trying to create a View of at Task List that o...I'm trying to create a View of at Task List that only shows Tasks that have a [Due Date] in the [Current Month]. Can your technique be used for this, and is the coding any different in SP 2007?Cliffhttps://www.blogger.com/profile/07349410602168755852noreply@blogger.comtag:blogger.com,1999:blog-8859052.post-57159645363329863452007-07-30T08:48:00.000-04:002007-07-30T08:48:00.000-04:00That's quite a good question. I don't know the ans...That's quite a good question. I don't know the answer off the top of my head. Anyone else got an idea?Joelsefhttps://www.blogger.com/profile/10695165187531657921noreply@blogger.comtag:blogger.com,1999:blog-8859052.post-52975488651365083572007-07-19T10:13:00.000-04:002007-07-19T10:13:00.000-04:00In Sharepoint 2003 I have a issue list. I have a c...In Sharepoint 2003 I have a issue list. I have a column named "Contact Date", which has a Date & Time Format. The default value is set to Today's date. I would like to have another column called "Due Date" which shows the current date & time plus 1. (For example: If the current date and time was 7/19/07 10am 05 in the "Contact Date" column I would like the "Due Date" to be 7/20/07 10am 05. With putting "=[today]+1" in the calculated field of the "Due Date" I am able to have it show 7/20/07, but it doesn't show the present time. How do I do that?<BR/><BR/>please email me @ mitchell.gehle@emersonclimate.comAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8859052.post-35776161274902764642007-04-03T02:41:00.000-04:002007-04-03T02:41:00.000-04:00Joel, Thanks for this info. It's great for newbie...Joel,<BR/><BR/> Thanks for this info. It's great for newbies like me.<BR/> <BR/> What I am trying to do is create a view that filters tickets showing only the last hour or two. I've tried to modify your Date tip, but to no avail. <BR/><BR/> Any help you could give would be appreciated.<BR/><BR/>JettonAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8859052.post-27777714339415020572007-03-18T20:45:00.000-04:002007-03-18T20:45:00.000-04:00Hi Juha,You made a slight error in the syntax. Use...Hi Juha,<BR/><BR/>You made a slight error in the syntax. Use this instead:<BR/>=ID&"/"&TEXT([Created],"dd-mm-yyyy")<BR/><BR/>You had added an extra paren after [Created]. The closing paren should be after the yyyy".<BR/><BR/>JoelJoelsefhttps://www.blogger.com/profile/10695165187531657921noreply@blogger.comtag:blogger.com,1999:blog-8859052.post-64126291166266608522007-03-12T06:57:00.000-04:002007-03-12T06:57:00.000-04:00Hi,I try add formula ID & " / " & TEXT([Created]),...Hi,<BR/>I try add formula ID & " / " & TEXT([Created]),"dd-mm-yyyy") for my column as text. After pressing OK-button i get error:<BR/>The formula contains a syntax error or is not supported.<BR/><BR/>So i like to have in this column text like: 12345 / 12.3.2007.<BR/><BR/>What went wrong?<BR/><BR/>Thanks.<BR/>Juha.Anonymousnoreply@blogger.com