-
IF cell matches criteria in one column, THEN return other columns from matching row
Help, please! I am trying to search a MASTER sheet for ALL ROWS that match two criteria (MASTER Author-Partner matches the value in [Project1], and MASTER Project category matches Project@row), and then return the contents of certain cells within each matching row (Title/Topic, Product type, Status, Due Date). I have had…
-
Conditional Logic Forms
We have a form that will have yes/no logic. If Yes(problem is resolved with the previous information provided in logic) is selected we want them to back out of the form or display a "thank you, please submit if you have any additional questions" It doesn't appear the functionality is there, but does anyone have work around?
-
Is it possible to combine vlookup, join and collect AND reference an external sheet?
I'm trying to group information together from a second smartsheet, but the information requires a vlookup so a typical join/collect won't work. In the first smartsheet I have a company ID in each row that I want to look up, and in the second smartsheet there are hundreds of rows that contain company IDs in the first column…
-
Need help with using a COUNTIFS with OR
Hi, I'm trying to create a nested formula used in a ticketing system that will total up active status (Open or In Progress) compared to location. Ticket Active Status for Location = Location <and> Status [Open <or> In Progress] My Status column is using RYG balls, so "Red"=Open and "Yellow"=In Progress. I keep getting…
-
Ref SUMIF example in Help
Hi, Referring the SUMIF example in the Help article https://help.smartsheet.com/function/sumif, it is not clear to me why =SUMIF([Price Per Unit]1:[Price Per Unit]3, >20, [Transaction Total]1:[Transaction Total]3) has the result 3,115.00, and not 2,303.00, that is 1,491.00 + 812.00 Thank you, Elena
-
SUMIF for Contact Column Properties
My formula comes back as #No Match but when I filter, I see the results I need. I am hoping you can assist! I am trying to calculate the amount of time spent for a contact person. Here is the formula I have so far: =SUMIF([Contract Phase Assigned to]:[Contract Phase Assigned to], "Stephanie Bauder", [Total Time Spent…
-
RYG Ball Formula
Can you change formulas to make "Not Started" be the same as if it was blank? If I deleted the Not Started lines then my parent row would match my child/ children rows. (See snip # 2). I'm not sure if it's possible since you can't paste "Not Started" into a cell; it just changes to "Not Started". My current formula:…
-
Using CHILDREN for ranges in VLOOKUP or INDEX MATCH
Hoping someone can help with this as it seems possible... I have a sheet for contacts at individual centers across a state. There are roles assigned to the contacts, so for example there may be a director, a supervisor and a coordinator. In the sheet, each parent row is a row with general center information and (the part…
-
Counting # of Employees working this week
Hello, I am wanting to count the number of employees that are working this week. However my current formula does not take into account the number of unique names within a weeknumber. Any help would be apreciated.
-
SUMIFS function with Auto/Number system column
Hi all! I'm trying to summarize deliverables using the date stamp of when a form was submitted. Unfortunately the way our form is set up, we have employees fill out a form and enter the month and the year separately so our sheet does not have a normal date column. Is this possible to use the Auto/Number system column as a…