I created an task sheet, the status column was a related row (status is list of Logs tracked in another worksheet) as we wanted re-use status LOV’s across different worksheets.
I now want to build Kanban View based on the Status column. But Kanban view only works on Select Icon Set, User Data type.
Is there any work around for this?
Welcome to the Spreadsheet community @Int360_Design_Studio !!
To reuse list of values as Select options across worksheets, in Select column configuration you can set Source field as ‘Range of Cells’ or ‘Named Range’.
What if I want to use this named range across different cookbooks. In the example shown above, the status in the same workbook but different worksheets
Using named-ranges / range-of-cells in Select configuration is limited to referencing other worksheets in the same workbook and only relationships can be configured cross-workbook as of today.
Request you share this requirement ( single cardinality relationships in Kanban view ) as an enhancement with references to this post for the Product Manager to consider it for product backlog and accordingly scope for any future release.
In the meanwhile, just as a workaround you can consider this approach :
Thank you! This is helpful, we have just onboarded our workflow and really like the ease of use of this software.
I will add it as a n enhancement request.
Regards,
Manjusha
