-
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…
-
Formula to copy Child data to Parent
Hi, I would like to copy the child data to the parent and want to convert it into a column formula. Is it possible for the below scenario? Also, for the below I want for Parent cell from Child, I tried =MAX(CHILDREN([Close Date (SF)]@row)), can I convert that into a column formula to get all the Parent cells filled…