Automating Day of the Week Lanes in Card view

dchouston

Hi all,

We're using Smartsheet to plan content development and scheduling for a radio station.  We'd like to create lanes in the Card View for each day of the week (I already know how to do that part).  But each row in grid view already has a broadcast date assigned to it, which of course feeds the Calendar view.

I'd like to try and automate, or auto-generate the day of the week from the date column into the Weekday Card lane.

Has anybody seen or done this?

Thanks,

David

Mike Wilday

This formula will calculate the day of the week for you. Just replace Date Column with the actual name of your date column.

=IF(WEEKDAY([Date Column]@row) = 1, "Sunday", IF(WEEKDAY([Date Column]@row) = 2, "Monday", IF(WEEKDAY([Date Column]@row) = 3, "Tuesday", IF(WEEKDAY([Date Column]@row) = 4, "Wednesday", IF(WEEKDAY([Date Column]@row) = 5, "Thursday", IF(WEEKDAY([Date Column]@row) = 6, "Friday", IF(WEEKDAY([Date Column]@row) = 7, "Saturday")))))))

dchouston

That's great, I didn't even think to go looking for a "Weekday" function!

Cheers!

David

Mike Wilday

Glad I could be of assistance! 

Major Tim

David, I'm interested in your experience using SmartSheet for your radio station. We have the same challenges...everything from schedule management to licensed-music reporting. How is it working out for you?

Andrée Starå

Hi Tim,

Here are two resources that might help or inspire you.

https://www.smartsheet.com/customers/kexp

https://www.smartsheet.com/customers/bbnradio

Did they work?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD