I am trying to take a list of all employees that includes their info like department, name, and age and then create a age range (like 16-24, 25-34, etc...) so I can then count how many employees fall …
I have googled and cannot find any company that has automated the 9-box talent assessment outside of excel. I feel like this is a huge miss as all large corporations do talent reviews and succession p…
I am trying to see my team's capacity over multiple projects for each week to see who will have capacity to take on new projects. In the past I've done it by hand to look like this and I know in my mi…
Hello! I am creating one master sheet for a variety of portfolio metrics (we currently don't have control center - working on that!) and am having trouble figuring out the best formula to populate the…
Does anyone have a formula that looks at a line status (Not Started, In Progress, Complete) and then determines whether it is after the due date (red), <7 days (yellow) , or >7 days (green)? Complete …
Hello! I'm trying to create a formula that will generate a weighted sum total across a couple of criteria columns after each column has been assigned a score. Each of the columns will have a drop down…
Hi, My company is currently using Smartsheet for Onboarding tracking and workload. There are 10+ people working on the sheet and I wanted to know if there is a more immediate process to have the sheet…
Where the first instance of 'Days Not Worked' for a member of staff occurs (the first date of that person's annual leave), I want to input a distinct value (only once) in the column 'Deduct N/A Annual…
Hi, I am trying to incorporate 0.5 days of annual leave into my vacation tracker. I have the forumla =NETWORKDAYS([Start Date]@row, [End Date]@row, {Bank Holiday Lookp}) to calculate overall number of…
Hello, I'm trying to recreate/transfer a salary/reward solution in Excel over to Smartsheet and two of the columns have a rather complicated formula, which has a function I don't believe is available …
