Damn I am so lazy – Default Value Calculated Fields in a List

I know even as I was doing it that I was just being lazy. The issue was that each day I run a bitlocker script to update a chart of bitlockered machines on our intranet. The hard part (..right) was that I needed to manually create an Item in a Summary Graph so the numbers look pretty for my manager. In this list I had title, date, Bitlocker Yes, Bitlocker No. So basically I just needed to enter 4 things each morning. Being that I am a sys admin with the motto of work smarter and not harder 4 items to enter was WAY too much for me to bother with. So of course I set date to default to Today but needed a way to set the title to “MM-DD Report” (don’t judge me on originality, my manager liked it).

Simply added to the Title Column Default Setting Calculated with

=TEXT([TODAY],"MM-DD") & " Report"

So now I only have to enter 2 columns.
Now to figure out How to auto populate those other 2 fields and I might be able to sleep in an extra 5 minutes.

Leave a Reply

%d bloggers like this: