-
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 ))
-
Intermittent Errors on Column Formula, Report always displaying errors
Why is my sheet intermittently displaying error messages & Report always displaying error messages. One minute the columns have data then randomly they all show up with the error messages? My report consistently ONLY displays error messages. I have a sheet performing calculations related to consumption of water based on a…
-
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…
-
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…
-
Formula to Pull In the Sheetname to A Cell?
Hi all. Is there a formula or a way to pull in the name of the open sheet, into a cell on that sheet? Ideally I was thinking something like =sheetname but that's not an available formula.
-
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},…
-
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…
-
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…
-
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…
-
Collecting the most recent submission
Hello, I have set up a sheet in which a form will submitted with 4 columns; a specific label (from a dropdown list), and then up to three barcodes. On the grid I also have a hidden created date column. I am then wanting to create a separate sheet that collates the most recent barcode for each column for label for the day.…
-
Getting error in a countif formula
Hi all, I am trying to expand on my regular countif formula but I am getting an error. The original formula: =IF(Order@row = 2, SUMIFS({Costs}, {Date}, Date@row, {Location}, location@row), SUM(CHILDREN())) works perfectly fine. However, when I add onto this formula, I get an error: =IF(Order@row = 2, SUMIFS({Costs},…
-
Reaching Cross Reference Max error prematurely
I Saved as New an existing Project Metadata sheet with 90+ cross-references. When I removed the old cross-reference formulas. I was only able to add 6 new cross-references before getting the "Unable to create cross-sheet reference, because this sheet already contains the maximum number of different cross-sheet references"…
-
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…
-
INDEX/MATCH formula error, "No match" when there is an exact match
Hello! I'm using an INDEX/MATCH formula to return the "Type" associated with a specific "Email." I'm getting a no match error when an Email value is first repeated. After the first repeat, the formula no longer functions. I've included my actual and desired outputs below. Both the form submissions data and the summary data…
-
Formula on Target Date Column
Hi, I am trying to create a formula in Smartsheet that automatically calculates the target date for a task based on the “Go Live Date” and a “Weeks Prior” value. For example: Go Live Date column has 08/02/2026 Weeks Prior column has 12 I want the Target Date column to automatically calculate the date that is 12 weeks…
-
Is it possible to reference a cell or summary field in a column formula?
At the top of our templates we have a Summary section where project (deliverable) details and key people are specified. I am wanting to reference the 'Deliverable Sponsor' cell within a hidden column on the sheet so we can create reports pulling through all row data across all deliverables that belong to that Sponsor. From…
-
K-12 Education
Hello everyone, my name is Alan Miller and I am an Executive Assistant working in K-12 education in Grand Junction, Colorado. I would just like to introduce myself and share some of the uses of Smartsheet that I use within my industry. I have been using Smartsheet for 4 years now and just returned from my second time at…
-
SUMIF OR SUMIFS
I hope I can explain this correctly. I have three separate columns I am working with. My goal is to sum the total footage of certain rows that have been approved within the last 7 days. My columns are: FOOTAGE, STATUS, and DATE APPROVED. I would like to have a total in a separate cell at the top of the sheet. I keep…
-
Countif formuls
I'm trying to have a countif formula for a column that will count only if the space contains 100%, I can't seem to make it work, this is the formula I tried: =COUNTIF([FAT Completed]1:[FAT Completed]90, ="100%") anyone have any ideas