Update status of multiple rows at once

Jenn L
Jenn L ✭✭
edited 11/07/23 in Formulas and Functions

My sheet is built to duplicate an original request every 6-months and trigger associated notifications, etc. Each subsequent line item is marked with an “ongoing” status until the end user updates the most current to “closed” status to stop the duplication.

I have logic to “cross-out” and move the line item when status goes to “closed”, but I need this to happen to ALL matching line items based off the unique ID associated to the request. Is there a way for logic to render something like “IF ‘case status’ = closed, FIND and UPDATE matching ‘ID’ to ‘case status’ = closed”.

(Fair warning, I'm only intermediate Excel and SmartSheet novice.)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!