-
Summary by name and date range
I will try to explain the best I can. I don't have the Pivot app, so wondering if there are any other "tricks" that might work besides exporting to Excel. We are using Smartsheet to log everything that goes through our final testing department. So, assembler, qty inspected, qty rejected, date, etc. Is there a way to…
-
AverageIf Statement Not Right
Hello, I am trying to get the average of a column based on the owner. The range is a column with a formula resulting in a number (=[Planned % Complete]@row- [Actual Complete]@row). The criteria is a contact column. My formula is as follows: =AVERAGEIF({What The Frog 1}, CONTAINS("Big Bird", {What The Frog 2})) I have tried…
-
Adding all task participants to parent cell
WHAT I WANT TO DO: I need to add all participants of tasks to the tasks' parent cell (one time each, in case that's an issue). If there is a way to automate this, I would love to hear it. That's the long and short of it. WHY I WANT TO DO THIS: Why do I want to do this? Well, in an attempt to add parent rows to reports, but…
-
INDEX/MATCH Formula
Hello! I'm creating a document where I would like to index a column of dates, and return a specific date from that list. I need one of two things to occur: 1) If a date occurs in the upcoming week, I would like to return the latest date of the week 2) If no date occurs in the upcoming week, I would like to return the…
-
RYGGrey ball formulas for multiple columns (beginner)
I am trying to automate the RYGGrey ball status column, based on two date columns ([Start] and [Finish]) and 2 check columns ([Task Started] and [Task Completed]). Having trouble getting started and follow the right syntax. Here are my conditions I am trying to meet. TIA for your help. Grey * If TODAY < [Start] and [Task…
-
Combining COUNTIF and IF statements
I am ultimately trying to add KPI data to a dashboard, but am stuck on the formula. I want to look at two columns of data (Status and Priority) and cannot get the formula correct. I want to show how many rows we have for each Priority level (I am using Stars, which are represented in Smartsheet as "zero", "one", "two",…
-
Idea on connecting two Smartsheets?
I have two sheet that i want to reference and update each other. They both follow similar formatting, with one being more of a log/reference for the other. I would like one list to dynamically update the other. How would i do this? Items list - I have a items list that will show an overview of purchase orders to be done…
-
Using formulas in date fields which reference another field
I'm trying to enter a formula in a date field which is 10 days earlier than the date in another field. I read that I can perform calculations on date fields (https://help.smartsheet.com/articles/2477601-use-formulas-perform-calculations-dates) and reference another cell in the formula…
-
Count # of values in a Multi-Select Cell
I have a multi-select column in my sheet, and I'm trying to count how many items are actually selected in each cell. Is there a way to do that? I've seen a post that suggested creating a "helper column", but can't figure out the formula that would actually do the count.
-
Nested IF (AND (OR))) Formula for Flagging
Hi there, I want to be able to flag a column based on a "Status" and not by using a "% Complete" column. I want to flag a row/task that is <= 3 days from an "End Date" column value and IF that "Status" if "Not Started" OR "N/A" OR "In Progress. The formula I've come up with is : =IF(AND([End Date]@row < TODAY(3),…
