-
Count if on two columns
I have a sheet that pulls from another, I need to do a count if for two different columns. I use this formula for one, how do I add another? =COUNTIF({Date 2}, [Start Date]@row) I need something like: =COUNTIF({Date 2}, [Start Date]@row), =COUNTIF({Review Board}, [ReviewBoard]@row=XX) It is an agenda sheet that has a set…
-
#INVALID DATA TYPE, when trying to Column count Quantity of Rows with a Date by Month.
I believe I am close, but no cigar yet... I have a request sheet that records a completed date in a Date Column (ie. '01/07/22'). I am trying to count the # of requests that are completed by Month type for a report. Ideally would like to report how many requests completed in January, February, March, etc... I realize the…
-
Sheet set up
I want to have a column that has a yes/no option. Which I have set up. I'd like that answer to be triggered based off of the values in two other columns macthing (or not). Please help!
-
Import Specific Entire Columns from one sheet to another
It seems something this simple is overly complicated. I can copy, move, manipulate rows...but columns? Why is this so difficult? I have tried VLOOKUP and INDEX. Both I feel I am getting nowhere. Sheet 1 (Master, holds all data) I need to pull specific columns only to Sheet 2. As rows and data are added to Sheet…
-
Is there a way to easily/quickly hyperlink 100's of sheets.
I am running into an issue where it is desired that 100's of sheets in a workspace have an individual hyperlink on a separate sheet. The desire is that in card view, they can click on the hyperlink and go directly to that person's individual sheet. I understand that the desired effect can be obtained by running a report…
-
How to extract matching records
Hi, I need help with the sample data below. I want to extract records for the "Team name, Location and ID" into another sheet, using the the "Date column" to match "Drink type" that is alike. For example: I want to retrieve "Team name, Location and ID" of all "soda" sold on Jan 7, 2021 I want to retrieve "Team name,…
-
Variance on task list
I have a sheet that is a running list of tasks that gets added to weekly. I am looking to figure out how to show how early, or late, a task is completed in relation to the due date. If the task is on time, I want to show 0. I have been trying to use this formula =NETWORKDAYS([Due Date]@row, [Actual Finish]@row) - 1 This…
-
Index and Match Used in Branching Formulas
I have a column using an index and match formula to index the cost based on a match of client name. In the same sheet, I have a Total Sample Cost column that sums the Normal Sample Cost with a couple of other fee columns. I did not build the sheet originally and when I went to change the pricing structure to index and…
-
How to get top 5 most caused services from countifs roll-up by month
I work for a bath remodeling company and we want to track the top 5 reasons we have services from our service calendar in Smartsheet. I created a COUNTIFS roll-up formula that is below and located in the children rows below Top # 1 Service from pic: =COUNTIFS({Nature}, $Label@row, {Month}, INDEX(ANCESTORS(), 1), {year},…
-
Automate the copying of rows and deleting previous versions
I'd like to automate the copying of a row into a secondary sheet when a cell is updated. Then delete any older versions, on the secondary sheet. I have already created a system column to create project ID's. I can find previous versions of the copied data, but I'd like to automate it so that when the new information is…