Adds a new name to the collection of the given scope using the user's locale for the formula
        :param str name: the name of this range
        :param str reference: the reference for this range or formula
        :param str comment: a comment to describe this named range
        :param bool is_formula: True if the reference is a formula
        :return: NamedRange instance

def add_named_range(self, name, reference, comment='', is_formula=False):
        """
        Adds a new name to the collection of the given scope using the user's locale for the formula
        :param str name: the name of this range
        :param str reference: the reference for this range or formula
        :param str comment: a comment to describe this named range
        :param bool is_formula: True if the reference is a formula
        :return: NamedRange instance
        """
        if is_formula:
            url = self.build_url(self._endpoints.get('add_named_range_f'))
        else:
            url = self.build_url(self._endpoints.get('add_named_range'))
        params = {
            'name': name,
            'reference': reference,
            'comment': comment
        }
        response = self.session.post(url, data=params)
        if not response:
            return None
        return self.named_range_constructor(parent=self, **{self._cloud_data_key: response.json()})