Automatically move a card in CardView

BRoy

BRoy ✭✭

04/21/20 in Formulas and Functions

Is there a way to automatically move a card (in Card view) to the "Complete" column when the Complete checkbox is checked?

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

04/21/20

You would need to use a formula to automate each of the different options available in the field that drives which lane the card is in.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Removing commas if a field being joined is blank?
Have a "Reason for DQ" field that aggregates responses from hidden helper columns (finds fields with "bad" conditional formatting). What it looks like unhidden: I'm so close...but so far...how do I keep the commas separating data but remove them if the fields are blank? Forumula being used below: =JOIN([Pre-Bid…
Formula to Join Cells that have Content (with Line Break)
Looking to see if there is a formula that would allow me to join cells into separate lines ONLY for cells that have content. Essentially I want to remove blanks somehow so it is just seamless data. In my example, when I use CHAR(10). It joins the cells, but leaves blank lines if nothing was filled in for a cell. Im…
Multi Select Column to Show as Individual Rows in Calendar App
Hi! I'm trying to build a calendar for speakers assigned to a program. I really want to see a column of individual names and each program they're assigned to in a multi month view. The underlying sheet has the speakers in a multi-select column. The issue is when I have more than one speaker assigned to a program/row,…