-
Parent / Child Join(Collect) Statement to summarize Child Rows
Hello! First time poster here! I have found this community so helpful I can usually find enough examples to write the formulas I need but I'm stuck. I have a sheet that is tracking decisions across multiple groups. I am using a parent row with child rows underneath for each separate group. See below. I am going to generate…
-
Contains, Find, or Has with Countifs
A team enters their consultations into a Smartsheet input sheet. This includes the type of consultation in the Type column. The Type column is a multiple select dropdown column so there can be more than one consultation type listed. On the calculation sheet are the formulas to calculate the number of consultation types by…
-
Adding the amount of specific contacts across 3 different sheets and averaging based on network days
I am wondering if it is possible to combine a VLOOKUP formula with a COUNTIF in order add unique contacts in a single select contact column used in 3 different sheets and then find the average within the given network days. For example, I have 3 columns on 3 sheets that are named "Quality Inspector", "QC Inspector", and…
-
Help with Lookup Formula using IF CONTAINS Status In Progress/Not Started/Watch
Hello, We run a weekly Sales report of any new Yellow or Red risk customers, that gets added into an Escalation Master Tracker in Smartsheet. Master Tracker may contain matching "Customer Code" entries more than once (past entries marked "Completed" or "Terminated") and new entry status = "Not Started", "In Progress", or…
-
Creating a chart with a multiple dropdown field
Hello, I have tried a few options, but no success. Trying to get a report in a pie or bar chart format that will be reporting off of a field in a sheet with multiple options. The sheet is a list of company projects and the field is a strategic category (Go to Market, Client Service, People & Culture). Some projects are…
-
Dates not copying over correctly when copying to another sheet
Hello, Hoping someone can help me figure this out. I have a calendar template that I am copying over to a project plan via the Copy to another sheet function. When reviewing the template, the start dates are on a Sunday. When I copy over to the other sheet, the set date changes and the start dates move to a Thursday. I…
-
How to know the order of tasks in card view for use in table view
Hi all, i need to do some calculation in table view depending on the order of the tasks in card view. Which formula or function returns the order number of the task in card view? Thank you, Joachim
-
I am new to Smartsheet and finding some of the formulas a challenge
"I am working on a sheet that I need to sum Line amount column if the dates are between a range of 12/15/21 and 5/31/22... This is my formula =SUMIF([Request Date1]:[Request Date]775, {Date Range},> DATE(2021, 12, 15), {Date Range}, <= DATE(2022, 5, 31), [Line Amount]1:[Line Amount]775) what is wrong with my formula that…
-
Using =IF(AND(OR Statement to search-select values to label
I have 2 columns: 1) MONTH# (number of a Month , ex. JAN=1 etc) 2) Quarter# (Q1 Q2 Q3 Q4) I want to parse out the month numbers so 1-2-3 = Q1 and 4-5-6=Q2 ....etc I'm trying a short test to verify the IF(AND(OR formula but consistently in INCORRECT ARGUMENT or CANNOT PARSE. Formula in Quarter# column:…
-
Current Week Formula
I use the formula listed below quite often but sometimes different variations. I am having trouble with this specific one because it is pulling the previous year's entries as well when I only want the current year. I have tried a couple of things but can't seem to get the syntax right. I think I need to use something like…
