-
How do I automatically update a target date?
I have a Smartsheet in which one field has the current date using the TODAY function, and the next field has a target date. A third field that is in a countdown column subtracts the target date from the current date. When it reaches 0, an automation sends an email. Is there a way to set up an automation that will update…
-
I am getting #circularreference and I am not sure how to fix it.
I am trying to get this calculation to work =IF(TODAY() < [Start]@row, "not started", IF(AND(TODAY() >= [Start]@row, TODAY() <= [Finish Date]@row, [% Complete]@row < 100), "In progress - on track", IF(AND(TODAY() > [Finish Date]@row, [% Complete]@row < 100), "in progress - delayed", IF(AND(TODAY() > [Finish Date]@row, [%…
-
How to auto-create a new set of rows once criteria is met?
Hello, I want the following columns to auto-create (with the filled in colors as well) below the already created ones every time "SITE" gets filled in. Do I use a formula, conditional formatting, or some other way? Thank you in advance for the help!!
-
Average of values if criteria is met in two other columns
Hello, I am trying to determine the average of values in one column (Days Open) if criteria in two other columns is met: (Date Closed) is from last month (Facility Name) is a specific dropdown option from this column I can calculate average based upon date closed being from last month, but adding in the second criteria…
-
How can I use index-collect across two different sheets?
Hi everyone, I'm looking to create an index-collection formula that pulls data from two separate sheets, but I'm running into some issues. I have a 2024 calendar that lists confirmed projects, and the producer assigned to each project. I've also built a 2025 calendar with all the same data. I'm building a separate sheet…
-
Bring in data to new sheet
Below is a screenshot of the target sheet cell (Created on : etc) I want to update automatically when the source sheet is changed We currently have a cell link, but this is not updating without removing the cell link and redoing it each time. Here is the source sheet screenshot:
-
Pull dropdown menu options from one sheet into another based on a defined cell
Hello, I am curious if there is a way for Smartsheet to populate a designated column in one sheet with dropdown options from another sheet based on the conditions of a cell in the sheet the dropdown should appear in. For instance, if Sheet A has a specific value in the cell, you can pull in the dropdown menu from Sheet B…
-
Assistance Needed: JOIN and COLLECT Formula Returning Blank Values or Duplicates
This discussion was created from comments split from: INDEX MATCH on multiple value cell.
-
Multiple IF/Thens that impact a single cell.
I've tried 20 different formulas and none are doing what I need. I'm starting to wonder if this is even possible. Okay, I am trying to make the Two Crucial Time Status for Alice ISD act as follows: If any of the Two Crucial Times monitoring items with stop signs are checked under Items Being Assessed, and the Alice ISD…
-
Rolling metric data sheet for chart that is current month and last 13 months
I'm trying to setup a metric data sheet that will automatically roll (update) without constant manual intervention. I don't believe I'm doing this right. We have multiple different types of task and I'd like a count by month of each that are In Progress. I want to show this data in two charts on a dashboard: a bar graph of…
