-
CountIf Help
Is there a formula that would count the number of cells where a Done check is not completed but only when another columns due date is in the past? The goal is to count how many past due tasks I have. Does anyone know the best way to accomplish this?
-
SUMIF Trouble
I am trying to use SUMIF to add the dollar amount for jobs that have 100% probability. I wrote this formula: =SUMIF(Probability:Probability, "100%", [Quoted Amount]:[Quoted Amount]) and it returns a 0 but no error. Also all of the data in this sheet is linked from another sheet. Is the problem because the data is linked?
-
Help on Formula: automate status based on dates
Hi all, I'm pretty new with formulas and I wanted to automate the status of each projects based on dates. I have columns Status and Progress. The status column have a selection of: Completed, Active and Not Started and the progress column have: On-time, Delayed and Not Due. On the screenshot below, the columns Status and…
-
Formula driven by date
Hi All: I only want this formula to activate only if it is greater than or equally to today's date, but having trouble adding TODAY part of the formula: =IF([% Complete (Actual)]3 > [% Complete (Planned)]3, "Up", IF([% Complete (Planned)]3 > [% Complete (Actual)]3, "Down", IF([% Complete (Planned)]3 = [% Complete…
-
COUNTIFS Formula Help
As one of the pieces of logic in a formula I'm attempting, I want a count within a range (column) if the date (formatted as MM/DD/YY) falls within the year 2017. What do I need to change in the formula as shown in my screen shot?
-
VLOOKUP Calculation Lag
Hi, I am having problem with a VLOOKUP process. Our current process flow is as follows Import data into a "DataDump" sheet through API, at this point each row of data is assigned a number, matching that of the row number (we do this so we can use an index match formula to pull data through to the secondary sheet we call…
-
Conditional Alert enhancement status and issue with work around for alerts on incomplete tasks only
Any update on the functionality for the "Reminders" in "Alerts and Actions" to be conditional to eliminate for example tasks based on a completion condition? I used the work around proposed previously in this forum (see below suggested by @Mike Wilday) , but found this to have following limitation: Since you are using a…
-
Count Dates / Checkbox Formulas
I am in process of transferring a large excel document into Smartsheet (over 2000 lines). The excel version is tracking 2007 projects, some of which are complete, some no longer active, and some active. I need to count how many active projects will be completed in year 2018, year 2019, and year 2020. Currently, our excel…
-
Calculate Win/Loss on a quote log
Hello I have a quote log that has a win/loss column. I want to populate a cell that takes the $ amount of the won bids, adds them up to show a total $ amount of won bids. Same for lost bids. I also want this result to auto update if the win/loss value is changed. Having trouble with the formula to make this work. Any help…
-
Formula with two conditions met turning a ball green
Hello, I am trying to build a formula that will do the following: * Yes/no drop down column = Yes * Verification check mark column = checked * Health symbol column turns green If either column is blank the health stays blank.