-
I cannot get my IF statement to automate Harvey Balls.
Hello. I have used RYG balls before to show statuses for dates. But I am wanting to use them based on the value of a single cell. I have tried various formulas but they are not working. Would anyone have advice on this? I have included a screenshot with the formula.
-
Nested "IF" Formula Help
Hi all, I feel like I'm close but continue to get #UNPARSEABLE or #SYNTAX errors. The Formula: =IF(OR([Project Status]66 = "Training", [Project Status]66 = "Doc Control Released"), "Released", "Development"), IF([Project Status]66 = "Not Started", "Not Started", "") The Project Status column is a single select drop down…
-
How can you capture the date stamp of a status change?
I am trying to capture the date stamp for when a row changes from one status to another. Is there any workaround to get this information, for example from using an integration to another software or through a report? I know you can look at an individual cell's history, but I will need to do this for hundreds of rows, so…
-
VLookup crossreference "#INCORRECT ARGUMENT SET"
Hi, I have been having trouble with VLOOKUP function in Smartsheet's. I have a sheet that I want to reference the Store# to pull over data such as the address from the other sheet. I have tried a number of things but the formula I am trying to use currently is: =VLOOKUP([Store#]@row, {ALL Store Openings (Master) Range 3},…
-
Counting Multi-Select Column value, based on another Column value
Given the following Grid - I am trying to count all instances of 'Apple' in a Multi-Select Column ('Fruit'), but only when another column ('Market') has a value of 'Market A' So in the above example, the answer would be 1, as whilst 'Market A' appears twice in the 'Market' column, 'Apple' only appears in the first instance…
-
Select Distinct Cars By Max Inpsection Date
Need to count the number of distinct Cars by Max Inspection Date and report on their Inspection Due Date. On my Metric sheet I have a below metric defined but realized the counts were off because the Cars being counted needed to be distinct : Current Formula:=COUNTIFS({STATS}, "In Service", {Due Date}, MONTH(@cell) =…
-
SUM of a column between two dates
Hello. I am trying to write a formula that cross-references a sheet to calculate the sum of a column if the rows in the date column fall within a date range. Here's a snapshot of the sheet I'm cross-referencing. I am trying to get the sum of "enrollment 1" if the "first visit" is within a certain date range or month (e.g.…
-
Parent/Child formula depending on status
Hi, I am setting up a status column on a project plan. The statuses we are using are: Not Started, In Progress, Overdue & Complete. I want to use a formula on the parent rows to look at the statuses of the children rows and return a status based on the following: If any of the children are overdue then parent status is…
-
Counting # of rows under a parent row that meets a certain criteria
Hi! I am trying to figure out what formula to use in the below situation: My sheet has parent rows that determine various phases of a project. Each child row has a status (in progress, complete, etc.) for each step (step 1, step 2, etc.). I am trying to figure out what formula would count how many "in progress" child rows…
-
IF Function Resulting in Specific Symbol Given Specific Inputs from other Columns
Hi all, Wondering if I could get some help on writing out a function. I know that it will probably be some sort of advanced and lengthy IF function but am confused on how to write it out. I have a Smartsheet that is used to track data inputs from a form. This data is related to a specific order coming in. I would like to…
