Search results for query: *

My co-worker is trying to do a VLookup between two spreadsheets. When she does step 2 of the formula, table array, she clicks over to the other worksheet to try to select the range of cells. However - nothing happens! She doesn't get the blinking "Selected" indicator. I emailed myself the same...

I'm trying to run a report of all employees with certain deduction codes. The PS_Genl_Deduction table is not pulling all employees. I look in Enterprise and I can clearly see that a certain employee has a certain deduction, but they will not pull in on my reportsmith report! Any ideas?

Hello everyone, I'm trying to write a report that pulls an employee's most recent pay change only. The problem is, some of our data entry folks don't always use an action of PAY - I had one example this morning where they used "Promotion" with a reason of "Normal Step Progression". So, I...

I have an excel document with data in time format. For example, 8:44. When I click on the cell, Excel shows it as 8:44:00 AM I'm merging into a Word document. I cannot find a good switch to format the time correctly. I just want it to show "8:44". Right now I am trying: { MERGEFIELD "Distance"...

Hi, I need help writing a nested IF statement with a formula within the statement...if that makes sense. Here is what I'm trying to do, in english: If cell = 0, then calculate =INT((Date2-Date1)/7), if the formula result is greater than 25, then 1, else 0. Is this even possible? Thanks in...

I'm not sure if this is an HTML issue, or just an issue with the portal website I'm using. Long story short - I'm trying to link to some files on another server. The files have the "getdocument.axd" type links. Here is a censored version of my link...

I'm trying to pull a list of new hires, and some have a future hire date (3/24/08). The future dated employees are not showing up on my report. Any suggestions? I'm using some very simple simple selection variables: Job.Action = HIR Job.EffDt >= 2/29/08 Here is my SQL: SELECT DISTINCT...

I have an unofficial "form" in excel. I have a group of five statements under a category, like "Motivation". I have a checkbox next to each statement. I only want to allow one checkbox to be checked per category. How can I do this?? To clarify, I haven't done anything to make this an official...

Hello again, I have to design a performance review form and I want to try to use Microsoft Word. However, I have a sticky situation: I have a category: Appearance. Then I have descriptions like: A. Carless about appearance B. Acceptable appearance C. Neat and tidy The manager would check a...

The font in my data validation list/dropdown menu is too small. Can I change the font somehow? To clarify, I want to change the font of the actual list values, when you are looking at the dropdown list...not after you tab off of the cell.

After pouring through threads about Sumproduct, all of the examples seem to only have two conditions. Can you have three? Because I'm having a doozy of a time trying to get this formula to work: '=SUMPRODUCT(('Turnover - Terms'!H2:H1249<=DATEVALUE("01/31/07"))*('Turnover -...

I have learned how to use the SUMPRODUCT formula, thanks to the lovely FAQ section. However, I am trying to add one more step to my formula. I want to say: If ANY of the cells in the range H1:H10 are greater than or equal to 01/31/2007, then move on to the SUMPRODUCT formula. If not, 0. I'm...

I have a list of department numbers. I have a pivot table where the dropdown menu/pivot function is based on the department number. After making the original pivot table, I went back to my department and added a new one to the list. I refreshed my pivot table. Now the new department number...

I have a data validation list of employees and a spreadsheet that "vlookups" and calculates several factors based on the employee ID number that is in the list. I have over 5,000 employees in the list. My question is: Can I create a macro that will select an employee from the list, print the...

I have a database of employees listed by their manager name, then employee name, and their next review date. I want to send each manager a report of only their employees with their review dates. Is there a way to get Access (or another MS program) to separate the report files by manager name...

I use Enterprise v4d. When in Reportsmith 411E if I go to Help(F1), I get the following error: "Cannot find the RSMITH32.HLP file" Does anyone have a way to send me the help file (pdf, etc)? I realize this is probably a long-shot, but I thought I'd ask. Thanks.

Is there a way in Reportsmith to change the report variables that you selected when you first opened the report? Example: Report asks me to type in an employee id. Report runs, I see the information. Now, I need to run the exact same report for a different employee ID. Up until now I've just...

I'm going crazy trying to find this field in ADP. We have several terminated managers that are showing up in ReportSmith when I pull an employee report and list their manager's id #. However, when I go into ADP to correct the manager info, I can't find where to enter the manager ID. I found...

I am trying to create a report to show the employees next review date. However, it pulls multiple lines for each employee because they have more than one "next review date" entered. For example, Jane Doe has three lines because she has 5-1-05, 5-1-06, and 5-1-07 all listed in the Employee_review...