-
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.
-
Formula Help
Hi, I am trying to combine two formulas into one, both, are correct on their own but I am unsure on how to combine them. Formula1: =IF([% Complete]7 < ABS(0.6), "High", "Low") Formula2: =IF(Blocked7 = 1, "High", "Low") So, if either of the "BOLD" conditions above are satisfied, then I would want the true/false values to…
-
vlookup error
Hello, I have created a vlookup that works but cannot seem to create a second one. Working: =VLOOKUP([Currency Code]55, {Customer FY18 FX Rates Range 2}, 4, false) Not working: =VLOOKUP(Country55, {Region List Range 2}, 4, false) I cannot see why one is working and the other is not. Any help or advice appreciated.
-
If multiple cells are blank or a one specific cell has data
I am trying to achieve this - If the action required by and the data processed is blank or the action required by = "DAT", then "DAT" is the correct response. This what I have come up with =IF(OR(AND(ISBLANK([Action Required by]1), ISBLANK([Data Processed]1)), ([Action Required by]1=DAT)), "DAT") Am not sure how to fix…
