How to check if Flag has been flagged in another sheet? Formula?
I have a metadata sheet that has At Risk row with a flag symbol, and I would like to check the other project sheet with an At risk column to see if any flag has been marked in that column. If any task has been marked in the project sheet, I would like the flag symbol in Metadata to turn red as well.
Answers
-
Hi @PKafley
Is there any unique value that is same in both the sheets? So if the task 1 is red flagged, with the help of formula you can map the Unique values in both the sheets and automatically turn the matching task flagged in the Metadata sheet. You can try the below formula.
=INDEX({Flagged},MATCH([Unique value]@row,0))
You will have to reference the source sheet.
Or you can use the COPY ROWS Automation workflow, if the task is flagged then copy the row and move it to the Metadata sheet. I hope this helps!
Regards
Amit Wadhwani, Smartsheet CoE, Ignatiuz Software, Exton, PA
Best Regards
Amit Wadhwani, Smartsheet Community Champion
Smartsheet CoE, Ignatiuz, Inc., Exton, PA
Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"https://www.linkedin.com/in/amitinddr/ -
Sorry for the delay, but Thank you, Amit. However, there are no unique values in both for me to pull the information in.
I was thinking more of a conditional statement - pseudo code below:
=IF({reference sheet column has any marked flagged row} - flagged, mark metadata cell with the flag in red, not mark it)
I tried multiple things but did not work. I am able to check the same row on the same sheet.
Appreciate any help.
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!