-
Potential IF/AND with multiple criteria (each listed multiple times)
Okay, let's start out by saying I am so stuck I have no clue on how to create this formula! LOL Okay the formulas will be added to the PA - CAPA List sheet. The Training Report is the data source. This is just a small sample of my data (there are about 25K rows). In the sample on the Training Report you can see the names…
-
HAS with multiple criteria and qualifying checbox
I'm trying to pull data related to only 1 program and not another, then add in whether a check box is ticked. The first part of my formula works: =COUNTIFS(Program:Program, OR(HAS(@cell, "ECSP & HCW"), HAS(@cell, "ECSP"))) But when I add the second part it becomes unparseable: =COUNTIFS(Program:Program, OR(HAS(@cell, "ECSP…
-
What am I doing wrong with this nested formula?
=IF([% Complete]@row = 1, "Green", IF(AND(OR([Start Date]@row > TODAY(), [Start Date]=""), Status@Row="Not Started"),"Blue", IF([End Date]@row < TODAY(), "Red", IF([End Date]@row = TODAY(3), "Yellow", "Green")))) Red=Not complete by end date Yellow=Not complete within 3 days of end date Green = Complete or end date is more…
-
Formula for Accrual Management
Hello experts, I'm seeking assistance in setting up a Smartsheet formula to manage vacation requests for my team. Here's the scenario: I have two sheets in my Smartsheet workspace: Team PTO & Absence Management Sheet: This sheet contains all the requests for time off submitted by employees via a form and is shared as a…
-
IF Formula Unparseable
I’ve read through many posts to include the formula guide, but I cannot figure out what I’m doing on a very simple IF formula. Let’s start with the first challenge. If a number is equal to a defined number, I want to display text. To do so, I’m using the IF function. More specifically, I want a column to display the month…
-
Cool Features of smartsheet to be aware of
Hi Team, Lets share and discuss in this group about some of the super cool features of smartsheet which help us in the daily work also: To begin with - i aware of some good number of features and offering below one for the day and we can begin collaborating on this more to learn…
-
I would like to know if there is any way to group values from a column in a cell
Hi guys Could you help me with a very specific case? I would like to know if there is any way to group values from a column in a cell Example: In my column "A" I have values X, Y and Z.... I would like to group these values in a cell every time I find a related value in another column, as in the formula index + Match, but…
-
Help with a solution to my Quote Database
Hi all, we have recenlty move our system to smartsheet and loving it so far. Our Quote departments number system has a revision number attached while still using the main quote number. so, lets say our quote number is 121088-1 (this is the fist quote assigned to this particular enquirery)If there are any changes we…
-
Can someone help me with mirroring one column from 1 sheet, into another sheet please
Hi Everyone Can anyone help me with a formula with mirroring 1 column in a source sheet into another separate sheet. the data is dates that I want replicated and mirror. I have this formula so far =INDEX('Calendar - Home Appointments 1'!$A:$A, MATCH([Date of Arrival (2)]@row, 'Electrical Tasks'!$B:$B, 0))
-
How do you calculate the cumulative total of children rows only
How do you calculate the cumulative total of children rows only in a column? I have a column of contract contingency amount, another column showing draws from this contingency and I want to create a third column with a cumulative total of how much is left of this total contingency amount after each withdrawal. But I only…