Hi,
I am working on a dynamic weekly calendar by hour that displays several training sessions (Title) and have an array formula that is working.
The intention of this calendar is to have people go through the calendar until they find a training (Title) they wish to attend. Once they find one, they could click on the cell and that would take them to a sign up sheet within the same workbook. Each session (Title) would have a unique sign up sheet.
Is there a way to have the cell returning a value form the formula display a hyperlink to a sheet?
{=IFERROR(INDEX(Title, SMALL(IF(((C$7+$B9)>=Start)*((C$7+$B9)<End), ROW(Start)-MIN(ROW(Start))+1, ""), 1)), "")}
Basically, each Title would be a unique hyperlink to a sheet and I am hoping there is a way to have my formula display that in the dynamic calendar.
Thanks in advance for any support!
sydgirl1983
Bookmarks