Comments
-
@Paul Newcome YES! Thank you, this was the issue! How do I add multiple cell values? This is the formula that works: =AVG(COLLECT({MonthsEmp}, {TermYear}, "CURRENTLY EMPLOYED", {DivAtTerm}, "ADMIN")) Instead of TermYear, I want to use my {SeparationType} column with the values "Voluntary" and "Nonvoluntary".
-
I just double checked the sheet being referenced and all requested columns are column type text/number...
-
@L_123你是正确的!我的{MonthsEmp}reference was calling the wrong column. With the join and the comma delimiter, it now returns a list of all of the # of months employed for current employees in the Admin Division. For Example: 12, 2, 6, 54, etc. My original formula below (with the reference corrected) still returns…
-
@L_123 Using your 1st Join example results in: ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN, ADMIN So, it's not collecting…
-
@L_123 I am still very new to Smartsheet, can you give me an example of what the formula you suggested should look like?
-
@Paul H Yes, this works! Thank you so much!
-
Thank you! This partially works. It works for employees who have a Term Date but for employees with no Term Date (AKA currently employed) I get an #INVALID DATA TYPE error. I need to display the number of months employed between Hire Date and Today if there is no Term Date and I think that's the piece missing from the…
