-
Auto Check Box if Date Falls in Specific Range?
Hello All, I'm trying to figure out a formula to automatically check a box if a date falls between a specific range. For example, I want to check a box for Q1 if a project start date or end date falls between 1/1/2023 and 3/31/2023. Does anyone know of a way to accomplish this?
-
In regards to the Marketing Campaign Management Template
I'm using the Marketing Campaign Management Template that Smartsheet offers. I'm updating some parameters within the '3: Campaign - Plan' Sheet and have unhidden columns to see how everything is connected. I noticed there is a 'Campaign Code' and 'Campaign Name' Column that was hidden and has a column formula. I looked at…
-
Calculate formulas by Columns
I am relatively new to Smartsheet and am stumped on a formula, and so are my coworkers. I do QA for multiple teams and I need to be able to calculate information such as # of Exceptional scores (100%), Meets Expectations (85% - 99%), and Needs Improvement (0 - 84%). We tried Countifs, Averageif, and a few others and did…
-
Counting the number of items due in the next six months from today's date
Hi, I am struggling to find a formula that can count the number of items (each row represents a task/project) that are due in the next six months from TODAY (the date of viewing). At the moment the below formula is incorrect ... =COUNTIF([Target Closure Date]:[Target Closure Date], IFERROR(MONTH(@cell), TODAY(MONTH(+6))))…
-
Duplicate Values causing multiple emails being sent with the same info
So I have a sheet that is essentially tracking missed attendances. And we want to know when a miss happens each time. I have it set up currently to check for duplicates and then a box gets check for each miss up to 3. Then I have a workflow to notify different people based on the number of miss it was. My issue is that…
-
(SmartSheet newbie) Filter and Count across Columns
Hello, I am very new to SS (a day into using it) and I'm not even quite sure how to ask this question. I am trying to create a dashboard to see the total number of different types of positions in my company, with intersecting filters. I have a master sheet with a column for the type of position (Contractor, FTE, etc) and a…
-
RAID Metrics
Hello! I am hoping to get a little guidance. I am a little rusty on formulas and I have been trying to determine the count of "Open" items on our RAID log. We have Risk, Action, Issue and Decision that is a drop down option under our "RAID Type." Our "Status" column has a drop down option of Open, Closed and Canceled. Our…
-
Automatically linking different sheets to a master sheet?
Hi, I am trying to create a master sheet with information I need that pulls specific cell data from multiple different project sheets. I know I can use vlookup's and reference another sheet within them but I'm wondering if there is any way to create a template or workflow so that when a new project is added to the projects…
-
SUMIFS with OR
I feel ridiculous asking a question when I've seen several others on this same topic and I modeled my formula after them. I'm trying to sum an account total when the string matches either of two different strings and the account code matches a different criterion. I'm just getting an unparseable error so I'm sure it's a…
-
Retrieve Date from Data
Good morning gurus! I have a tricky one today. I need help retrieving data from a cell. The column (Routine Execution) contains information imported from another program and looks like this: 5S Audit - Jul 29, 2022, 04:01 PM Gemba Checklist - July 13, 2022 I was able to pull the date from the above data using the following…