Updating New Row Status to Mirror Existing Row Status Using Common Identifier

Amber Grossman
Amber Grossman ✭✭✭
edited 04/04/24 in Formulas and Functions

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

  • Amber Grossman
    Amber Grossman ✭✭✭
    edited 04/29/24 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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!