-
Trying to Get traffic light to work with two different criteria
The part I'm having issue with is, I'm trying to get the traffic light to turn yellow if either the termination date is equal or less than 120 days out but greater than or greater than or equal to 60 days out but also look to see if the Anniversary date is less than or equal to 60 days out. I can get the individual…
-
Use report count value in dashboards
Hello, I am new to Smartsheets. I have tried searching in the forums, but couldn't get a resolution. Below is the scenario. In Folder - Project Type 1 Project 1 Project 2 Project 3 Using Summarise function of a report, I can get the count of number of projects in each folder. Can I use this count value in a Grid or…
-
Mode Function
A formula for the Mode of a column would be helpful. I have gotten help from the community members on alternatives with helper columns and have found methods online but having a set function would make the process more efficient.
-
Formula for 1st of the month in a prior month is coming up Invalid Value
I have 3 different formulas for 1st of the month 1 month, 2 months and 3 months before renewal date, excluding holidays and weekends. The formula is working great, until it has to calculate back in a previous year. 1st Follow-Up Email Due Formula: =WORKDAY(DATE(YEAR([Renewal Date]@row), MONTH([Renewal Date]@row) - 2, 1) -…
-
Add Months to Date formula?
I've read through a lot of the help topics and others' questions, but haven't been able to find a simple solution to my issue - which I think is fairly simple. I'm trying to add a certain number (Varying) of months to a start date to produce an end date. I have a start date column (which is a date column), a column that…
-
Merging CountIFS and Contains
Hi all, Trying to get a CountIFS statement to count when a column contains the values "UE" where another column contains a certain animal type. In the example below, the value should be 2, not 0. What am I missing or am I trying to combine the wrong types of formulas? Thank you in advance! Current formula: =COUNTIFS([Study…
-
How to create a flag column that identifies a scheduling conflict
I am trying to create a checkbox column that gets checked when the conditions of a formula are met. Essentially, I am trying to flag a row if someone is assigned to that row who already has an assignment for that same date AND if the start and end times overlap. Example: Interpreter= John; Date= 6/1/2025; Start Time= 8:00…
-
Mode Function
Does anyone know if there is a "Mode" formula yet without using a helper column?
-
Counting Children Rows if marked as Active
Hello, I am trying to list the number of projects (AKA children rows that are marked as "Active" under Active Project/Staff) in the Number of Projects column. The formula I am using where I get #unparseable is =COUNTIF(Children([Active Project/Staff]@row ), CHILDREN([Active Project/Staff]@row = "Active"))
-
SUMIFS Help
I am trying to sum a column with SUMIFs. I have two sets of criteria but am having trouble with the third. I am trying to sum the cost if it matches a project title column, and invoiced quarter column. If the invoice quarter column is blank I want to check if a different column (expected delivery quarter) matches. The…