Sharepoint 2007 - Adding a Display Until column

In this example, I have an events calendar. I created a view on the team's page to this calendar where I want to display an event until the date passes. When the date passes, the event will no longer be displayed. So, in order to have a filter on this event, I need a special calculated field/column.

Steps to create a calculated column:
1. Navigate to the view where you want to add your column.
2. Add column
3. Enter a name for the column (here, Display_Until)
4. Enter formula (here, =[Start Time])
5. Select Category from Insert Column box
6. Select data type (here, I selected Date and Time) which displays additional fields, select "Date Only"
7. Select "Ok" to save.

Now, you can add this newly created field to your filter.

Sharepoint 2007 - Import Excel Spreadsheet into a List

Here are the steps to import a spreadsheet into a Sharepoint site:

1. Click on "Site Actions" and then select "Modify All Site Settings" from the "Site Settings" sub-menu.
2. Select "Site Libraries and Lists" under "Site Administration" column
3. Select "Create New Content"
4. Choose "Import Spreadsheet" from "Custom Lists" column
5. Enter the Name, Description (optional), and Import your excel file. Click "Import" button to continue.
6. A popup opens asking for the Ranges. Select "Table Range" (which is the whole table).
7. Once you import, your new list is saved under the site's Lists.

Now, want to add a view of this data to your page?

8. Create a view (select "Create View" from the List's view drop-down menu) and save.
9. On the site page you want to add this view, Edit the page to enable adding Web Parts.
10. Select the Web Part to add Lists. Select the View you created. Save.

Welcome!

What is this blog all about, you ask?
I wanted a place to put my notes as I discovered new ways of doing things, neat tricks, and interesting tidbits without having to dig through all my bookmarks and yellow stick notes.

Geek Speak?
Browsing through other websites and blogs, I noticed the information is often very confusing - if you don't have the technical background. I hope to make this site a little more useful for those who don't grasp "geek speak" (ie, technical language/concepts).

So please feel free to follow this blog as I plan to upload bits and pieces of a variety of topics - Excel, Word, VBA, Javascript, Sharepoint, etc.