From 9882f6d613705bb0bc9cd8f82499ecfdfa96a56e Mon Sep 17 00:00:00 2001 From: justin melvin Date: Fri, 27 Nov 2020 16:03:33 -0800 Subject: [PATCH] Fix arguments to HYPERLINK --- turbot/sheets.py | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/turbot/sheets.py b/turbot/sheets.py index 0ed6847..0b2cb5e 100644 --- a/turbot/sheets.py +++ b/turbot/sheets.py @@ -39,14 +39,18 @@ def sheets_create_for_puzzle(turb, puzzle): new_sheet = sheets_create(turb, puzzle['name']) # Insert some useful links into the sheet + url_link='' if 'url' in puzzle: url_text = "Original puzzle is at: {}".format(puzzle['url']) + url_link = puzzle['url'] else: url_text = '' + channel_url_link = '' if 'channel_url' in puzzle: channel_url_text = "Discussion for this puzzle is at: {}".format( puzzle['channel_url']) + channel_url_link = puzzle['channel_url'] else: channel_url_text = '' @@ -57,7 +61,7 @@ def sheets_create_for_puzzle(turb, puzzle): insertDataOption='INSERT_ROWS', body={ 'range': 'A1:A2', - 'values': [['=HYPERLINK('+url_text+')'], ['=HYPERLINK('+channel_url_text+')']] + 'values': [['=HYPERLINK('+url_link+','+url_text+')'], ['=HYPERLINK('+channel_url_link+','+channel_url_text+')']] }).execute() # Copy some sheets from the Template spreadsheet -- 2.45.2