-
COUNTIFS Referencing Other Sheets
Needing help with the COUNTIFS and referencing other sheets. It keeps coming back #unparseable I am trying to find the number of projects in a certain phase based on who the project is assigned to. Active Leads Range 11: Assigned to Active Leads range 10: Phase . =COUNTIFS({Active Leads Range 11}:{Active Leads Range 11},…
-
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…
-
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…
-
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…
-
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.
-
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…
-
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…
-
Is it possible to format numbers in K (thousands) or M (millions)?
Hi all, Is there a way to format numbers is thousands or millions to just K or M? Or any formula to do it? Kind regards, Grace
-
Help on Formula: if function
Hi all, Please need your help. I'm new to formulas and I've been trying to figure out the right formula for my project status and progress report but I kept getting errors. I have tried the below formula in excel and it worked but not in smartsheet (the smartsheet formula below is another trial I did that did not work).…
-
At Risk Flag
Good Day All: I am trying to add to the following formula below. If my Due Date (Planned) is within 1 day (i.e. due 04/12/18) and % Complete (Actual) is less than 50%, it should be Flagged. =IF(Duration3 > 0, IF(OR(AND(TODAY() > [Due Date (Planned)]3, [% Complete (Actual)]3 < 1), AND(TODAY() > [Start Date (Planned)]3,…