Kanban View Based On # of Weeks Enrolled In Program

Topic Labels: Automations Base design Views
306 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I currently have a formula running for # of weeks someone has been enrolled in the program.  Is there a way to have a Kanban view with 52 columns (1 for each week of the year) and have the clients auto populate in those columns based on # of weeks enrolled?

1 Reply 1

Hmm, try:
1. Create a select field called "Week Number for Kanban" or something
2. Create an automation that'll trigger whenever the formula field with the running # of weeks someone has been enrolled in the program updates
3. Give it an "Update Record" action where it'll paste the value from the formula field into the select field created in Step 1

Should do what you want!