Smartsheet PDF Exports Break Links Over One Line?
I am having an odd issue in using Smartsheet and exporting Reports for the first time. I created a report from one of my sheets, with one column that includes a hyperlink. It's a pretty long link, but the text is wrapped so it simply splits the link up with a line break in the export.
However, the actual HYPERLINK that it clicks out to from the PDF, is JUST the first line of the link- which obviously breaks it. I don't want to make the column wide enough to fit the entire link- it'd be enormous. Anyone else have this issue? any way to fix?
Answers
-
Genevieve P. Employee AdminYou are correct: currently when exporting as a PDF, if the entire URL is not displayed in the cell then the export can only read the displayed portion as the link. This has been reported to the engineering team, however I do not have an ETA for when the hyperlink print functionality may be adjusted.
In the meantime, you could use a link shortening service (such as bitly) to create a short URL that will be fully displayed. I hope that helps!
Cheers,
Genevieve
Categories
You would use the below for Jan 2023 and adjust the month and year numbers accordingly for each of the other months.<\/p>
=IF(AND(MONTH([Start Date]@row)<= 1, YEAR([Start Date]@row)<= 2023, MONTH([End Date]@row)>= 1, YEAR([End Date]@row)>= 2023), [$ per month]@row)<\/p>"},{"commentID":387901,"body":"
Lets try a different approach.<\/p>
=IF(AND(VALUE(YEAR([Start Date]@row) + IF(MONTH(Start Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/98724/\") + MONTH([Start Date]@row))<= 202307<\/strong>, VALUE(YEAR([End Date]@row) + IF(MONTH([End Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/98724/\") + MONTH([End Date]@row))>= 202307<\/strong>), [$ per month]@row)<\/p> Basically we are creating a yyyymm stamp from the start and end dates and comparing them to the yyyymm stamp for that year\/month combo. The above is for July 2023 (202307).<\/p>"},{"commentID":387906,"body":"
<\/p>
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/G1SDKXPQ7I1D\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/GCQ7U05Q4GNO\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/79GD9D2EWXCW\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
