-
Retention Rate and Tenure Rate for employees for current year
I am needing help. I want to create a dashboard to see the current years tenure rate and retention rate by tracking month to month. I have a column for retention status (active vs terminated rate), active status count. Termination month, termination year, termination date, hire date. I have a formula for total employee…
-
Average with criteria
Hi I need some help regarding making an average. There is multiple rows with the text "Mekanisk" in it at "System" column, and a corresponding "%" at the "Fullført" colum. How do I make an average of all these uniqe % values? Thank's! :)
-
Unique codes
Hey all, I am trying to create a system that will check a unique code that is entered through a form and display if this code has been used already or not. I have a formula in the summary sheet that will asses if the code has been used or not: =VLOOKUP($Code$1, {Z Codes Trial Database Range 1}, 3, 0) The problem is that I…
-
Purchase Order creation and management
Hi, we are a small residential building company based in Australia. We have a workspace that we use to manage all of our projects that includes pretty much everything expcept for purchase orders. We currently have a BOQ with pricing, but i am looking to turn this sheet into individual orders. Wondering if anyone uses…
-
How to combine these?
Need the formula to say: If Completed - Green If Canceled - Gray If In Progress - Yellow If Not Started - Red If On Hold - Yellow If In Progress, Not Started, or On Hold and and today is greater than End@row - Red Here is what I have.... Works fine. Now need to add in the last bullet and I'm stumped. =IF(Status@row =…
-
Join formula of two sheets
Hello - Shown is one sheet but two sources separate data . Can I combine the two counts anyway they have the same Primary column. I don't want to make a summary count of the two because I can't get rid of this in reporting. Can you assist me with the formula? Thanks.
-
COUNTIF across multiple sheets
How do I use the following formula to pull information from the "place holder" field from multiple sheets? =COUNTIF([Assigned To]:[Assigned To], "place holder")
-
Count frequency of a specific word after a specific date on reference sheet
I am trying to count the occurrence of specific words within another sheet that were made after a specific date. For example, where the word I want to count is Range 1 ("Word") and the date is found in Range 2). =COUNTIFS({Intake Sheet Range 1}, "WORD" {Intake Sheet Range 2}, ">" & DATE(2023, 5, 1) Thanks in advance for…
-
Using avg formula across multiple sheets
how would i write a formula to pull the avg number of something in the same field across different sheets, or better yet how could i write an avg formula to pull the data from a report into a sheet instead?
-
Vehicle mileage: pre-trip and post-trip mileage, auto calculating multiple rows
I've created a new system to help out the finance department at my workplace to be able to pull in multiple types of information. The part I am hung up on involves vehicle mileage. The user will enter all the required information via a smartsheet form to replace the paper forms. This is what info I need for every trip:…
