If column has star, then return row name under primary column
How do I return the row name under the primary column, if a separate column title "Active Build" has a star symbol in it?
Trying to use this formula in sheet summary to return the current active build.
Thank you!
Best Answer
-
@AnonUser1 I didn't realize that you had posted the almost solution. I built it the same way but using true or false. I normally use 1 or 0 as well, but for this one, you will need to use true or false.
=INDEX([Primary Column]:[Primary Column], MATCH(true, [Active Build]:[Active Build], 0))
Again, given that you will always only have one marked with a star.
Answers
-
@AnonUser1 Assuming that you only have to check one value for one row, as this is the only way this can work...
For your Sheet Summary field, you will need to use an IF() formula to check the status of the "Active Build" cell.
=IF([active build]15 = 1, [Primary Column]15, "Value if false")
[active build]15 = 1
- this will check if the star is there or not. 1 = true and 0 = false.
"Value if false"
- change this to whatever you want to display if there is no star on Active Build
-
@Emilio Wright This wouldn't work, but thank you for the suggestion
I want to scan the entire sheet to determine 1) the "active build" and the "upcoming build"
The Primary column has a list of all the possible active builds, but only one will be active at a time (as designated by a star under the active build column), and only one of these rows will be the upcoming build (as designated by a star under the upcoming build column).
I want the sheet summary to tell me, at any given time, what is the "active build" and what is the "upcoming build".
Is this possible?
-
This is what I've come up with but it returns #NO MATCH
=INDEX([Primary Column]:[Primary Column], MATCH("1", [Active Build]:[Active Build], 0))
@Paul Newcome, @Andrée Starå would you be able to help?
-
@AnonUser1 I didn't realize that you had posted the almost solution. I built it the same way but using true or false. I normally use 1 or 0 as well, but for this one, you will need to use true or false.
=INDEX([Primary Column]:[Primary Column], MATCH(true, [Active Build]:[Active Build], 0))
Again, given that you will always only have one marked with a star.
-
I can't believe I was looking at this for so long and the only thing wrong was that I added quotes !!! Thank you @Emilio Wright
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!