Removing rows based on a value
I've created an onboarding training template for new hires at my company using the following (https://app.smartsheet.com/b/publish?EQBCT=2a335ca126274786adde88923187b3ca). I've removed some of the original reporting features and added our own.
I need to create a version of this that can automatically remove, and re-number days based on a flag that identifies them as a new-hire or a transfer. The goal is to remove the first week of onboarding material so that transfers can get right into the "meat and potatoes" of the content without having to manually check off orientation tasks.
We are reporting progress using a dashboard that calculates the summary sheet so we want to be able to see the difference in total days and tasks for new hires vs transfers.
Is there any automation that can remove rows based on a flag, or possibly using some if-then logic that can re-number subsequent data?
Help Article Resources
Check out the Formula Handbook template!