Updating New Row Status to Mirror Existing Row Status Using Common Identifier
I have an end to end program that the last process is assigning and working through List Manager assignment, creating the list, approving the list, etc. The input sheet for the List Managers is only updated using rules in data shuttle and some of the rows added are associated with existing rows in the sheet and do not need to start at the beginning of the process, i.e. already have someone assigned, list has been created, etc. I have a common identifier that comes in with each of the rows along with a unique identifier when this scenario is present. What formula can I use within the sheet to see if the common identifier already exists and if so, mirror the status of the original entry?
Best Answer
-
I used a workaround by assigning each status a numerical value in a mapping sheet, i.e Assign List Manager = 1, Set Up Stakeholder Meeting = 2. Using index match and then collect(max()) I was able to get it work - FINALLY!
Answers
-
Are you able to provide some screenshots (sample data is fine if necessary) for context?
-
Hi Paul, this should help. The first entry of the test is on step two of set up stakeholder meeting and the new entry is on assign list manager. I want the second entry to mirror the first based on the multi-tactic taxonomy matching.
-
Hey @Amber Grossman
Are you wanting the Assign Line Manager (SFMC Status) to change to 'Set up a Stakeholder Meeting'? Or is there another status that you are trying to mirror? If it is the SFMC Status, what is the formula that already exists in that column?
Kelly
-
I used a workaround by assigning each status a numerical value in a mapping sheet, i.e Assign List Manager = 1, Set Up Stakeholder Meeting = 2. Using index match and then collect(max()) I was able to get it work - FINALLY!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!