Example - Risk Log.
I want to be able to create dynamic filtering of a dropdown column "Sub-Category" based on the value selected in the Name/Number "Category" column.
I've seen this done in Excel using the combination of:
Excel Functions:
INDIRECT() – to reference a named range dynamically
SUBSTITUTE() – (if needed) to handle spaces or special characters in category names
Then, using Data Validation.
Is it possible to replicate this operation in Smartsheet? If so, how could you accomplish this?