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

Countifs formula not returning a value.
Challenge: Countifs formula is not returning a value from a cross sheet. Any help would be so greatly appreciated. Summary: I am trying to pull in counts for a specific month and status for an application. The formula doesn't state any errors but it doesn't return the values. Formula: =COUNTIFS($Name18, {Status}, [JAN…
Help with a Sheet Summary Formula Error
I have a simple sheet summary formula that keeps returning "Invalid Operation". I am wanting to count the number of instances where the Potential Loss column is over $500. I've tried every variation of "500" I can think of (500.00, $500, "500.00"), but it's still returning an error. Any thoughts on what's wrong with my…
Need to pull values across several sheets and columns into 1 column stacked, not combined.
I am looking to pull values from the Time 1 column of Example 1 sheet and the Time 2 column of the Example 2 sheet into the Time column on my Reference sheet with those values listed, not combined. Below images may help explain what I am looking for: