ContributionsMost RecentMost LikesSolutionsRe: Formula Help - Average Productivity Per Day Thank you! ------------------------------ Sheila Allas ------------------------------ Formula Help - Average Productivity Per Day I'm trying to figure out a formula to calculate average productivity per day and nothing I do seems to work. I have a table with call reviews. Not every person who completes reviews works every single day of the month. I would like to determine their average daily productivity by taking the number of reviews they complete per month and dividing that by the number of days they actually worked. I can't seem to get the piece for the number of days that have productivity. I could use either the Monitor Stop Date/Time field or the Date Created field to establish the days that have reviews completed. Any assistance is greatly appreciated. Thanks, ------------------------------ Sheila Allas ------------------------------ Re: Formula Help Request Thank you! ------------------------------ Sheila Allas ------------------------------ Formula Help Request I have 3 different fields that I need to incorporate into a formula to determine if the record qualifies to be on a variance report. # of Reviews for the Month - must be 5 or more Score - Prior Month - must not be null Score - Current Month - must not be null Nothing I try seems to work for this scenario. I'd appreciate any advise. ------------------------------ Thanks, Sheila Allas ------------------------------ Re: Formula Help Request Thank you that was very helpful. ------------------------------ Sheila Allas ------------------------------ Formula Help Request I'm trying to create a formula that will read 6 different numeric fields and then decide which field to populate as a results. If Numeric field 6 is empty, populate Number field 5 If Numeric field 5 is empty, populate Numeric field 4 If Numeric field 4 is empty, populate Numeric field 3, If Numeric field 3 is empty, populate Numeric field 2, If Numeric field 2 is empty, populate Numeric field 1 At minimum, Numeric field 1 will always have a value. Any help you can provide is greatly appreciated. I've tried many things and nothing is working. Thanks Sheila Allas ------------------------------ Sheila Allas ------------------------------ Question on Merge Field for Import On one of my tables I have records that have fields that are not necessarily unique but the combination of 2 fields is unique. I have a field Requisition # and a field called Candidate Ref Num. Neither is unique on their own, but the 2 values combined create a unique value. I created a formula text field to combine these and marked it Unique. I hoped to use it as the Merge Field to import additional data to the record. Unfortunately it's not listed as a merge field (probably because it's a formula field). Does anyone have any insight into how I handle this particular problem? ------------------------------ Thanks, Sheila Allas ------------------------------ Re: Formula Help NeededThank you! Works perfectly! ------------------------------ Sheila Allas ------------------------------ Formula Help NeededI currently have 3 formula text fields to track status of 3 separate events. I want to create 1 formula fields that will give me an overall status of the 3. Text Field 1 Text Field 2 Text Field 3 If Text Field 3 is populated I want to capture that entry, if it is blank then I want to read Text Field 2 and populate that entry. If Text Field 2 is blank then I want to read Text Field 1 and populate the entry. Everything I've tried so far only gives me the info if Text Field 3 has data. Does anyone have insight? Thanks Sheila ------------------------------ Sheila Allas ------------------------------ Re: Formula Checkbox and DurationThat works!! Thanks,!! ------------------------------ Sheila Allas ------------------------------