-
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…
-
Conditional Formatting Help
See Screenshot Example Please Goal: to compare cells in 2 rows across columns. All numbers in both these rows are based off formulas. I want the cell in row "needed machine hrs" (column 1) to turn RED, IF the number is greater than the number in the cell directly below it, in row "Current Machine/Labor Hrs" (column 1). Is…
-
Automating RYG balls
Presently I have a RYG IF formula to do the following. =IF([Commitment Expiration Date]11 < TODAY(), "Red", IF([Commitment Expiration Date]11 = TODAY(), "Yellow", IF([Commitment Expiration Date]11 > TODAY(), "Green"))) I would like to change the automated RYG balls in my sheet to turn “Green” if the Due Date is in the…
-
Countif formula if a row doesn't have any children
Is there a way to write a COUNTIF formula to count the rows that do not have any children? I would like to write a COUNTIFS formula that counts: 1. % Complete is < 1 2. Finish is in the past 3. Row doesn't have any children I know how to write the first two. I'm struggling to write the 3rd one about children. Below is a…