-
Viewing team capacity over time
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 mind the demands of each phase for a given project. This is quickly becoming unsustainable as we grow. I have a task list for…
-
Help with Index Formula
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 data I need for this one item. I want to calculate how many strategic projects vs. KTLO projects a team has for the…
-
Automate RYG Balls based on Status and then date
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 would need to turn green regardless of the date while not started and in progress would look at the date parameters. Thanks…
-
Formula to generate a weighted average score
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 where we can select a score (from 1 - 10). Each column will have a different weight: Enterprise Priority: 35%; HR Priority…
-
Can Smartsheet auto save immediately instead of after 1 min of inactivity?
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 auto save instead of saving after 1min of inactivity, that way everyone can see what is being worked on in real time?
-
Sum total days in date range which fall on certain days of the week
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 Leave'. This is the sum of, where manager type is Company annual leave, the number of days in a date ranges between…
-
Vacation Days Formula - calculating half days
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 days out (minus public holidays). From this total I then want to include any 0.5 days from this when 'half day requested'…
-
COUNTA alternative in Smartsheet
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 in Smartsheet (COUNTA). When I've tried to replicate it I get an error message (UNPARSEABLE) The formulas are:…
-
Data doesn't match the data from Excel when replicating formulas
Hello, I'm trying to recreate/transfer a salary/reward solution in Excel over to Smartsheet and I've been able to recreate a good portion of the columns that have complex formulas, but there seems to be a number of discrepencies with some of the data where it is out by a few thousand pounds or a couple of percentage…
-
INVALID DATA TYPE Error in single cell of column formula
Hello, I am getting one cell returning the "INVALID DATA TYPE" error in a column formula. I have 159 rows in this sheet, and only one cell has the error, so I am very confused. The formulas is: =COUNTIFS({Site Visits Range 1}, Type@row, {Site Visits Range 3}, [Primary Column]@row, {Site Visits Range 2}, <>"", {Site Visits…