-
Formula to indicate which quarter the Project's end date is in ...
… I had a formula that was working before July 1, but now "Incorrect Argument Set". :( The purpose of this formula is to indicate where the project's end date is in the Past Quarter (one quarter behind the current quarter), the Current Quarter (the end date occurs within the current quarter we're in), and the Next Quarter…
-
Copying a Checkmark Field from one to another on the same sheet.
Hello, I have a process set up where I pull data in from another sheet, and then I have a handful of Columns with formulas that will fill with a Check or Uncheck based on the information in the data that was pulled in. My goal was to be able to use these Checkbox columns to track processes, but since the columns are locked…
-
Formula Question - Finding Data
Hello I have a sheet with three columns and the primary which is not used, 2 Date columns and 1 Dropdown. The Dropdown has 5 tasks in it and the date columns are for start and end date. The Task column will have one to many of the same tasks but all with different start and end dates. For each row I need to find the next…
-
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…