-
IF Function Due Date
I am attempting to create a project status column that is using the Harvey Balls (red, yellow, green and gray). I am wanting these to automatically change yellow when my due date column is 120 days with the due date, I would like it remain yellow until a date is entered in the completed column, then I would like it to…
-
Auto Sum last 6 columns
Hello ~ I'm calculating attendance and want to highlight inactive participants. Currently, I copy and paste =COUNTIF([20 1/6/18]3:[25 02/10/18]3, "P") each week as a new column is added. Is there a formula that will auto add new entires and also limit to the last six columns? Thanks!
-
Formulas Including New Rows
Hi, (Sorry if this has already been asked and resolved, I couldn't find anything). I currently use smartsheet for our team's training log. In doing so, there are several columns that require numerical data that I would like to keep track of. Right now I use SUM (manually) each time someone fills out a new form, but I…
-
Invalid Data Type error
Getting an Invalid Data Type error with this formula: =COUNTIF(AND(FacilityCount:FacilityCount, "TZ"),NOT(COUNTIF(Status:Status, "Green"))) The second "CountIf" is a symbols column. Looking to make a count of certain 2-letter codes if the status column does not have a "Green" ball. Thanks
-
Nested IF function - Ignore Blank Cells
I'm trying to count the number of late tasks in a project plan. The formula I'm using works as long as a row isn't blank. =IF(AND(TODAY() > Finish15, [% Complete]15 < 1), 1, ""). If I drag the formula all the way down the sheet, then the Late Tasks column populates with a 1. How do I write the formula to not include blank…
-
COUNTIF Formula for Only Showcasing What is Due to Upcoming Week Period
I'm trying to determine a COUNTIF formula to show what deliverables are due in the next 7 day period based upon a Due Date column. However, I'd like said formula to only showcase what deliverables are in the next 7 days and ALSO be able to EXCLUDE all projects that become overdue. So essentially I'd like a COUNTIF formula…
-
VLOOKUP #INVALID DATA TYPE
I'm trying to use VLOOKUP for the first time, and perhaps I just don't understand how it all works. I keep getting an "invalid data type" error. Here's my formula. =VLOOKUP(Workorder10, {Platform MPS Range 3}, {Platform MPS Range 4}, true) [Workorder]10 is the workorder number I'm attempting to search in the {Platform MPS}…
-
confused about VLOOKUP across sheets
I can't figure out how to make the function work or I'm trying to do something not supported. Basically, I want to pull the value of a cell from a row on sheet B and put it in a cell on the same row in sheet A. I'm not looking to perform any specific calculations on the data, just to grab a copy. What I'm trying to do is…
-
Determining Resource Allocation for Resource View
Hello! I am trying to find a way to determine resource allocation in project plans so that they more accurately reflect the availability of my team in the resource view. We have individual project plans for each project, which all feed into the main status sheet. Each project plan is broken down into tasks with…
-
VLookup Range Changing - UPDATED - RESOLVED
I have a sheet of VLookups which I get to be working perfectly then when I come back later (sometimes as little as 10-15 minutes) most cells have been changed to "No Match". To fix this I simply have to re-input the range to what it has been the entire time. If this is how it's going to be it makes this feature practically…
