-
COUNTIF in the same sheet
I have two columns "Associate Name" which contains a list of names, and a corresponding list of birthdates "Date of Birth", both ever expanding. I would like to have a column that counts the number of times which that associate name and birthday appear in the sheet. So if I enter "John Doe" and "1-1-24", the first time,…
-
CountIF with multiple Criteria
I'm trying to count the number of rows in a column with a certain criteria only for dates in 2024. This is my formula: =COUNTIFS([Request Type]:[Request Type], "Payroll") AND([Date]:[Date], IFERROR(YEAR(@cell), 0) = 2024) But I'm getting an unparseable message.
-
Automation - Moving Grouped (parent/child) Rows
Hello Smartsheet Community! We have automations set up to move "completed" rows when they meet certain criteria (status is complete, row is invoiced, etc). If we have rows that are "grouped" as parent/child rows, and only one of the rows meets the criteria to be moved, will both rows be moved regardless, or will the…
-
Summary Report Formula
I have a sheet with the following columns I need to create a quarterly dashboard finding the total of each channel by quarter. I am currently doing this formula in summaries: =COUNTIFS(Quarter:Quarter, "Qtr 1", Channel:Channel, "Search") My question is, is there a better way to get values? There are a lot of channels and I…
-
Multiple IF Statement giving an #UNPARSEABLE error.
=IF([QTY 1]@row = "", "0"), IF([QTY 1]@row = "1", "1246"), IF([QTY 1]@row = "2", "2492") This formula is currently returning as #UNPARSEABLE I have a helper column that is my "QTY 1" column, as this increases I would like the "Price per" column to double in price. Prices stay pretty static and change very rarely. I feel…
-
Contains Function cannot find value for contact list data type
Hello, I'm trying to use the COUNTIF and CONTAINS functions to count the values in the percent column based off the values in the Names column with the contact list column type. Here is the formula I have so far: =SUMIF(Names1:Names3, CONTAINS("Anthony", @cell), Percent1:Percent3) And here is the data: When I change the…
-
Look at a date and return a value
I have been struggling to look at a date, write a formula to determine of the date falls between 2 dates and return a value. Date = 03/03/25 If date is greater than 03/31/23 and less than 04/01/24, return 23 This works for just the greater than date but as soon as I try to add the less than date, I get an incorrect…
-
I'm creating a stock tracker in smartsheet and need help implementing functions to count quantities
I have around 20ish food and drink items we want to keep track of. I have figured the easiest way to do it is making a column have a dropdown list of the items you can choose from, next column being the added stock of inventory that gets delivered, next column is removing the stock when it gets used. the added stock…
-
Adding in "Overdue" in formula using one date value vs. Today
I am trying to create a formula to flag something is overdue, when comparing it to Today's Date Only. What is the formula? I have been trying this one: =IF(AND(TODAY() > [Tactical Due for Approval]@row, "OVERDUE")) But it will not work
-
Record a date when specified criteria are met
I have a column available for users to choose from eight different build statuses. The goal is to automatically capture the date when the Publish status is selected. However, not all eight status options are available in the automatic workflow. I assumed it was a scrolling issue, but that is not the case. What am I doing…