-
Creating a formula for metrics sheet with multi-selection dropdown
Hi all, I am creating a metrics sheet, and am having trouble creating a formula to count how many cells of a specific variable (call it "Zone") has multiple selections. I've already counted the ones where only one zone is selected but, but am missing the counts for those remaining with multiple zones selected (can call…
-
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…
-
Formula to calculate a future date on a specific day (monthly and quarterly)
I have tasks that need to be completed monthly and quarterly. The due date of these tasks falls on specific days of the month, either the 5th, 14th, or 15th. I have a formula that calculates the Next Date based on a Due column and a Frequency of Submittals column. Next Date and Due are date columns. My basic formula to…
-
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…