-
Match and Index functions to create a table referencing another sheet
Hello, I need help creating a formula which will work. Sheet 1 - contains my data Sheet 2 - Contains the tracking matrix I am trying to create I need a formula which will look at sheet 1, determine if an inspection has taken place within a certain month, and then return the date of that inspection into sheet 2. I've beenโฆ
-
Incorrect Argument Set: Nested IF Formula with 3 Logic Statements
I have the following formula that works and I would like to add one more criteria, if Bid? = "Bid" then return 100% in %Complete Column This is the original working formula: =IF([Include in Estimate]@row = 0, 1, IF(OR(NOT(ISBLANK(Units@row)), NOT(ISBLANK([Fixed Cost]@row))), 0.25, 0)) This is my edit which returns theโฆ
-
How do I get a formula cell to return to blank when the corresponding cells don't have any values?
I am using the formula below to calculate the number of yearsย between today's date and a persons start date in another column. =(TODAY() - [Start Date at TDG]1) / 365 If the start date has not been entered, the Years @ Company cell is showing "0". How can I get the cell to show as blank until data is entered in the startโฆ
-
How can I count the amount of actions in one specific month?
Hi, I'm trying to set up a counter for a number of actions in the month of may, for example if I have 5 actions this month (May), I want the counter to return "5". I've been trying to use the formula below but all I get in return is a zero: =COUNTIFS([Target Due Date]:[Target Due Date], IFERROR(MONTH([Target Due Date]1),โฆ
-
Formula If & AND referencing form another sheet
Is there a formula for the following scenario referencing from another sheet? if "checkbox = ticked under Unique column" AND "Fruit = Apple" Then display [color]@row Refer to below, result I want to get is "Green" =IF(AND({SheetA Range 3}=1, {SheetA Range 2}=Apple), {SheetA Range 4}) I tried with above formula, but didntโฆ
-
Is it possible to count if a cell changes?
Hello! I am trying to calculate the amount of times a cell dropdown is changed per day. Is this even possible or would it need some magic workaround? In any given day the "current stage" column changes possibly many times. An example question would be: how many times did a cells in "current stage" column change from "Artโฆ
-
Updating a Date Column after another cell is updated.
I am trying to have a Date Column update with today's date when a single select option is chosen. I don't want to use the system update date column because that will get updated whenever any cell is selected. For example: I have a single selection column with several options: Estimating Complete, Quote Sent, and Sale. Iโฆ
-
COUNTIF on FLAGS at PARENTS level not returning any value (number)
Hi Smart Community, I am trying to Sum my CHILDREN() Countif but it is not giving any value. All my sub-children is indicated as flag (1 or 0) Example When there is a delay release in a category Bug Fix : it will flagged out RED. On Bug Fix, I did =COUNTIF(CHILDREN()),1)+"" This seems to work fine and return with 2 (whichโฆ
-
Average formula
I am sure this is rather obvious, however I am not seeing where my mistake is. All I am trying to do is return the average cost of a product cost column but I need to not include any $0.00 dollar amounts that are populating (which will happen when there is no inventory at the moment). Can someone please advise where myโฆ
-
Create a table referencing another sheet
Hello Smartsheet experts I am looking for some guidance. I have one sheet "H&S Inspections" and now I'm trying to create an "H&S - Inspection Matrix" sheet. My monthly inspections log is set up: "H&S - Inspections with Form" What I want to do is create a table which shows that each location has completed a monthlyโฆ