Hi, I've spent way to long trying to figure out if Smartsheet can do what I want it to do so I thought I'd ask the experts.
I have about 70 events a year and 150 tasks to complete for each event. It is just me working on this so I don't need to assign or escalate. I need to have reminders on certain tasks for different days. The are many different dates for the reminders and besides the event date there aren't any hard and fast deadlines for a task. The reminder is more so I remember to do it and not get it done by a certain date kind of thing.
1) Below is a screen shot of one way I tried with the event name on the column and the tasks on the rows. I need a different reminder for each column under say Post-Course email (5th row down) to tell me what date to send the email for the event in that column
2) I have also tried setting it up with the event in the row and each task in a column. Same as above, I would need different reminders in different cells on the same row.
I like the visual appeal of the collapsible tasks better because I like to be able to see more details at the same time instead of having to scroll right like in the second screenshot. Oh, and I would like to keep it all in one sheet.
Would anyone have any ideas on how I can set this up or how to help me?