Monday 'Minder 2022.03


Today’s Topic: How to reset WorkFlows properties to the default. 
Excel Tip: How to get diagonal cell values

Oops! You clicked "Yes" to Save Properties. Now what?  Or maybe you don't know if you (or whoever was last at that station) clicked save at some point and are wondering how to tell.  Here's the solution...

Start by closing Workflows.

1) Go to the lower left corner of your computer's desktop and find the Search Bar:

2) Type in "property."   Case doesn't matter.

You'll get something like the image below. You might have one thing that says "Property", you might have more if multiple people sign into the same computer with different accounts. The important thing is to check and make sure you find the right one(s).

3) Click on the ">" to see details about the various options you have.  You want the one(s) that is/are a File folder, and the location should be: C:\Users\username\Sirsi\Workflows. Where "username" is the account name that logs into Windows on that computer. In my case I log in as myself, "Smith."  At a service desk there might be a username for "XXPLSTAFF" (or something similar) as well as the name of any individual staff who have logged in.

4) Click on "Open file location." You should get someting like this:

IF the property file Size is NOT zero, properties have been saved to your workstation at some point.

The simplest way to restore the defaults is to delete the property file. Simply click once on the file and hit the delete key.  The next time you open WorkFlows it will download an empty, default, properties file from the server. 

The proper <groan> settings for your library are actually contained in the "site" file.

Remember, if multiple people sign into the same computer, you will need to check each property file for each C:\Users\username\Sirsi\Workflowsi

...and...since this is a 'Minder, and since you've all probably heard Melissa & I repeat ad nauseum "Never save Properties!!" but some may have missed the why not...Here is the reason: Clicking "yes" to save properties saves them locally to your computer. That local property file trumps all others. When there is an upgrade with a new property feature or if your library decides they need a different property setting for something, if you have saved any of those properties locally, you won't see the update!!

Excel Tip: Have you ever needed to get cell values diagonally instead of straight down or across? I use this for reports like the Netborrower-Netlender report.

Here's the basic formula: =@INDEX(A1:E1,,ROWS($1:1))  where "A1:E1" is the initial range of cells that you want to extract the diagonal cell value from, and "($1:1)" is the range of rows always starting at 1 and going 'til the row you're on(in this case 1).  In my example above, I changed it to =@INDEX(B2:AE2,,ROWS($2:2)) so that it started with the intersection of Berlin and Berlin in B2 (54,668) and went all the way across the rest of the libraries to cell AE2 (Winneconne, hidden in the above snip) in row 2.  I pasted my formula in the ToOwnLib column in row 2. Then I click-n-dragged the formula down that column.  The formula updates as you drag, so the formula in row 5 (Coloma) is =@INDEX(B5:AE5,,ROWS($2:5))  

Share & Enjoy!


Blog Type: