-
SUMIF Formula Not Working for column with #'s but working with text..
My sumif formula is not working with a numeric value but it is working on a text value.. Here is my formula that is not working: Sheet Referencing: SAP WBSE is the same as Proj. Def. column. I'm asking it to return the Ovr Commit column, essentially 64,345.03 but it's returning 0 but when I sum it on the description column…
-
Pulling data from one sheet to another
I am currently in the process of creating a dashboard. I was originally planning to use cellular formulas to pull this data. The original formula I was using is: =COUNTIFS({JBO Type}, "Overhead", {Date}, IFERROR(MONTH(@cell), "") = 11) However, this formula is returning an improper total, it reads "24" when it should be…
-
Countif "Incorrect Argument Set"
I can't understand why this formula doesn't work... =COUNTIF([2022]1:[2022]11, [Deal Prob]1:[Deal Prob]11, "Green")
-
Get MAX date from 1 to many possible other dates that meet a criteria
I can't get my head around a solution for this formula, but I believe there's one in Smartsheet somewhere for it! Can you help? I want to put the MAX date into the Actual Implementation Due Date column from a choice of 1 to 4 dates. In this example, the formula should return 22-Nov-2021. Implementation Due contains a date,…
-
Formula to Indent blank cells in column
Is there a formula or existing function to indent only blank cells in a column? Thanks for any information! Best, John Stanik RN, BSN
-
VLOOKUP or INDEX,MATCH - how to deal with situation when source will change?
I have a MASTER contact list, which has every contact that we ever have. Primary key is email address. Then i have a template where a person picks a user from a Contact List and a bunch of columns get populated with phone, city, etc when the email address for the user is matched against the Master. So that template has…
-
Conditional Formatting using a custom formula?
Hi there, So I'm trying to set up conditional formatting to visually alert us if 3 days go by and we haven't followed up with someone. My idea is to make an "Estimate Sent" cell which records the date we sent an estimate and turn it red if we haven't checked the "Estimate Approved" column after 3 days go by from the date…
-
Dependencies choking date formulas
Is there any work around to keep date dependencies and still run calculations using those columns? Before dependencies were enabled my formulas worked fine to support my dashboard. Do we need additional helper columns? =COUNTIFS({IMPACT}, Metric@row, {END} >=(2021, 10, 1), {END} <=(2021, 12,31), {STAT}, "In process")
-
Formula with two column dates and show the higher
Hi good day. I have a sheet with 2 column dates. "Mitigations date 1" and "Mitigation date 2", i need a formula in a third column that shows me the higher in these 2 columns. If Mit 1 is higher then show that if Mit 2 is higher then show Mit 2. That column will be my column to show in an dashboard items with past due…
-
#Invalid Data Type with VLOOKUP
Good day everyone, I'm trying to use the formula VLOOKUP to pull some information from another sheets, but it shows me #Invalid Data Type. I have this sheet named "2020 vs 2021 P/Month" and I need the formula to look for revenue on sheet "Rev By Month P/BTC 2020", so when I fill this last one, fills up the information to…