-
Dropdown List Alternative with Automatic List Update and Dynamic List Features
There have been many requests for improvements to the Dropdown list from Smartsheet Community. The two most typical requests are Automatic updating of the list @Justin Mauzy @Taylor Compton - NOAA Federal Dynamically changing the list of the following selections based on previous selections @Ian Cooper @Mehran Bagherian…
-
Partial match with INDEX(DISTINCT(COLLECT(
Hello, I need to collect a list of values from my source sheet based on a search field (cell) in my target sheet. I have a very large subset of data that I'm pulling from, so I've divided it into 6 sheets to increase the speed of the lookup. Currently, I'm using the formula: =IFERROR(IF(OR(LEFT([Lookup Value]$2, 1) = "A",…
-
Help Summarizing Columns
Thanks for your help! I am looking to summarize in one column all of the reasons why something is red. For instance in row 2, I would like "why red" to be "Financial, Resources" because both of those two have red selections. Other than creating a helper column for each health status then joining them, is there a more…
-
Strange Request of Rounding Down against Laws of Mathematics
I've had a strange request. One that defines the laws of Mathematics: I'm calculating the time difference and then using this formula to round down. However, the formula is following the laws of mathematics and rounding up when it sees an 8 or 9. =MROUND(ROUNDDOWN(Difference@row), 5) E.g. In this example, the requestor…
-
Need help with formula IF PARENT, then INDEX/MATCH for Dupe Flag
First, thanks in advance for looking at my problem. I am sure I am making this more difficult than it has to be. New: Release Update Sheet Formula being added to this sheet in a Flag column Based on IF Parent Row This sheet has Parent AND Child rows Initial field for INDEX/MATCH is Release Column Release List Duplicate…
-
Need help removing blanks from a join collect formula
Hi, I'm trying to use a join collect formula that referencing a column in a helper sheet. =JOIN(COLLECT({Column I Want Data}, {Reference Number}, [Reference Number]@row), ",") It's pulling everything from {Column I Want Data}, that matches the [Reference Number] with {Reference Number} on the helper sheet and any cell that…
-
Output combined column name values from checkboxes.
Hi, I have a number of checkboxes, if they are checked I want to output the column value in another cell. I understand we can't reference the column values but I am able to do this: =IF([Red]1, "Red") This will return a single value if the checkbox is true. When I try something like this: =IF([Red]1, "Red", IF([Green]1,…
-
Countifs no longer working
Hello, I have a countifs formula that was working and is no longer... This is for my "metrics" sheet so the information is being pulled from the Garage Access Issues Log onto another sheet so I can use it in a Dashboard. I'm trying to count how many issues are showing as unresolved and not archived. Both the 'Resolved' and…
-
Nested IF CONTAINS, Return Blank When Contains Blank
I've searched the Community and haven't found this situation, so I appreciate any help. I have a data set in which I'm trying to write a nested IF CONTAINS formula to return the primary program based on what is contained in the Project ID field. My current formula is =IF(CONTAINS("ABC", [Project ID]:[Project ID}), "ABC",…
-
IF Formula
Hi everyone. Im stuck with a formula and need help. this is a screensot of the sheet im working on. I have a formula in the APP STATUS column. it basically returns the status to show if all items of an application is processed (complete). here is the working formula i have: =IF(AND([Profile Picture]@row = "Complete",…
