Skip to main content

Kanban View Based On # of Weeks Enrolled In Program

  • March 11, 2024
  • 1 reply
  • 7 views

Forum|alt.badge.img+3

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

TheTimeSavingCo
Forum|alt.badge.img+31

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!