RELATED IDEAS
Calculated columns - add support for status category
Currently if you are using calculated columns and want to refer to a status, you have to refer to the status by name. It would be a lot more maintainable to refer to statuses by their status category instead.
This would be particularly helpful when reporting across records in different products where the workflow differs per product but you want to build a formula based on whether the records are in the "Done" status category regardless of that status name.
Right now, in this use case you need to build statements including all statuses in each product. If the workflow changes the formula is outdated; whereas if the status categories were used, this would not impact reporting.
-
ADMIN RESPONSEOct 17, 2024
Thank you for the idea. This is possible today by using status_category in your worksheet. For example: self.status_category will return the record's status category. If you include the status category as a column in your list report, you can use that field in your calculation column function. The status of this idea was out of date.
© 2024 Aha! Labs Inc.•All rights reserved