-
Best way to cross-reference multiple sheets for repeated values only?
Hello all! Looking for some advice here. I have multiple sheets that track guests invited to events (5 right now, but it will continue to grow). I want to create a something that references them and lists only people that have attended more than one event and which events they have attended. So for example, let's say on…
-
range checking & flags
Hi, I'm trying to leverage a formula to check if the employee ID is listed on another sheet. Sheet 1 (sanity check): This is where I want the formula to live. On sheet 1, if the employee ID on the row is not listed anywhere on Sheet 2's Employee ID column (range), then turn the flag on. If the employee ID on the row is…
-
Flagging rows based on number of occurrences within a range of another date
I have a sheet where I want to count the number of occurrences of the same [PI Name] within a 30-day period [Sx Date]. I only want to count each PI once on any given date. I've given an example below to show how I want the counting done, but the solution can look different from this. Whatever solution I use will have to be…
-
Collect from another sheet
I want to populate a date in sheet A based on the min date in a list of dates on sheet B. What is wrong with this formula: =MIN(COLLECT({REWORK Sprint Dates Range 1}, {REWORK Sprint Dates Range 1}, >=[Start Date]@row ))
-
Trim Leading/Trailing Spaces
This is pretty basic but I'm not sure what formula to use in Smartsheet to trim any leading / trailing spaces from values that are entered into cells. In excel this is a simple TRIM formula but there doesn't seem to be an equivalent in Smartsheet. I've tried the formula glossary and AI but unfortunately I'm not finding the…
-
Budget - Sum total of a specific category
Hi! I'm working on a simple budget sheet and I'm having difficulty with a formula to sum total a specific expense category. I want to sum all expenses in a given category from another sheet. This is what I have so far but it's pulling back $0.00 despite their being items that match the criteria. =SUMIFS({Expenses Range 2},…
-
Automation to Move cells without individual logic
Hi Smartsheet Community, I’m looking for assistance with optimizing our workflow for our project intake process. Here’s our current setup: All project requests come in via a single intake form. They populate into our Prioritization Tracker Rows are triaged as Declined (move to Declined sheet), Backlog (move to Backlog…
-
Personal Account for Fun (And Practice)
I am always trying to advance my skills and so, being the unapologetic Smartsheet buff that I am, I now pay for my own personal Smartsheet account to play around and practice my skills on personal projects. In my heart I would like to someday live somewhere else and to help me determine where…. I built a Smartsheet. Using…
-
Help with a Simple Formula
I am trying to calculate a formula that I can use in a dashboard graph. I need to show the following: status of a task (i.e. completed, in progress, etc) That it is US only (management responsibility) The end date is within the year 2026 This is what has been generated for me, through SS AI - COUNTIFS({My Sheet Name here…
-
Return blank when count total is zero
Can you give me a variation of this formula that delivers a blank if total counted is 0? I want to use it in forward months so I don't have to update the metrics sheet monthly, if possible. Thanks, Lisa I tried the IFERROR and IF(COUNTIFS( I could find but most deliver Incorrect Argument. =COUNTIFS({4Q2025 FPG thru Oct…