-
NEW! Your survival guide to formulas is here. Meet the Formula Handbook.
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of all…
-
To lookup data by matching 3 condition
Hi, I would like to capture data with 3 condition but seems like my formula does not work. Can anyone advice?
-
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…
-
Capture data from column 1 first row to column 2 second row with formula
Hi All, I am creating a CICO using smartsheet. since the data for CI and CO is key in separately in different row. Is there anyway I can use formula to capture the data by comparing the Unique ID and date?
-
Need Formula Help Looking for most recent activity type but reviewing 6 columns
I need a formula for my metrics sheet to pull the most recent account engagement type from a separate sheet, however I have multiple columns to search for the most recent engagement type. The form connected to the sheet allows a rep to select one, two, or three outreach updates so I have three Account Names, three Outreach…
-
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…
-
Absolute Reference changes if cell is moved
Hi, Looking for help with Absolute references in cell formulas. I need the formula reference to remain the same even if the user moves or copies the cells to a different column. The scenario is Column8 has the formula =SUM([Column 6]@row, [Column 7]@row) If a user moves the Column6 cell to Column9 , the reference in the…
-
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…
-
Override Column Formula
Hi, I have a column that uses a column formula to automatically calculate a date based on other columns' criteria. However, we sometimes need to manually adjust the date and override the column formula. Is there a way to do this? Thanks!
-
How do I get this to work as I intend? Health Symbol Formula - Red, Yellow, Green, Gray
Hello, I've worked this many different ways, but cannot figure out how to get this to work. When I reordered the On Hold to the front, I finally got that working but then I saw the Completed < Today was red. I'm sure I'm missing something here and am fairly new to this. Will someone offer a little guidance to point out the…
-
Splitting Irregular Data String into Multiple Columns
Hello, I am trying to split data in one cell into 1-4 cells, depending on the number of semi-colons in the original cell. Each organization's name has a different number of characters. The organizations can appear in any order in the original cell. Data appears as follows: First Organization Second Organization;Fourth…
