In Sheet 1, I have several rows, each with information about a course being developed in a particular term. The sheet has a list of courses, within four parent rows, one for each quarter of the year (e.g., Parent Winter 2019, with several rows as children, one for each course to be developed in that


I am wanting to refer to a cell (or find a match in a range of cells) in Sheet 1. The cell in Sheet 1 contains a hyperlink.

What I get in Sheet 2, however, is just the text in the cell, not the text as a hyperlink.

Sheet 1 (contents of cell, text as hyperlink):

BUS 123 6Wk Online

What I get in Sheet


Hi everybody, 


I'm new to smartsheets and I'm not sure if there's a name for what I'm looking to do.


I volunteer for a small afforestation project in my local area. And want to make planning our planting trips a bit easier, as all our members are college students with varying schedules and


Hey guys.

I am just starting to setup a sheet for a huge sports event that shall provide all relevant info, but also be used live to update the onsite status.

Basically there will be about 10 stations that will be identically except for individual timings and some details (i.e. number of people per