Complex formula using INDEX MATCH to update other columns
Hello Smartsheet Community,
I am trying out how I can do an Index Match to look up data in column 1 and see if the data exists in column 2. If the data exists then update other columns ( like status , health and % Complete, Greatest milestone met) with Values
Im truly in a time crunch , and will be super appreciative if some one has any tips . My data is as below
Logic: Look up and see if value in column1 (Lineage) exists in Column 2 (Type),
if it does then update the Column 3( Dev Complete Status) = " Complete"
Update column 4 ( Dev Complete %)to 70%,
Column 5 ( Health)="GREEN" and
mark the Greatest Milestone "Lineage Complete"
The greatest Milestone is a multi-select column with values
"Analysis", "Dev", "Test", "Lineage complete", "Migrate to QA", "Migrate to Prod"
Help Article Resources
Check out the Formula Handbook template!