Function to change value of dropdown (to "Completed) when checkbox is checked.

Christopher Warren

Christopher Warren ✭✭

05/10/22 in Formulas and Functions

Screenshot 2022-05-10 151245.png

0 ·

Best Answer

Christian Graf Community Champion

05/10/22 Answer ✓

Hello @Christopher Warren
You are so close!
Try this:
=IF(CMPLT@row = 1, "Completed")

1 · Share on Facebook Share on Twitter

Answers

Christian Graf Community Champion

05/10/22 Answer ✓

Hello @Christopher Warren
You are so close!
Try this:
=IF(CMPLT@row = 1, "Completed")

1 · Share on Facebook Share on Twitter
Christopher Warren ✭✭

05/10/22

@Christian Graf
Thanks so much!

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

How would I write a formula to locate duplicates in 1 column and the difference in another column.
I have 1 sheet that has duplicated Classroom IDs but different scores on each line. I need to flag any instances during the same term of a difference over 1.00 higher or lower with the same Classroom ID. I need to find the repeat instances within column "Classroom ID" that occur during the same Column "Term Name" and then…
#NO MATCH result but not for identical formulas
I have two formulas that are fairly identical but one is producing a #NO MATCH error. =COUNTIFS(Shop:Shop,Shop@row,[Review Start Date]:[Review Start Date], YEAR(@cell)= YEAR([Review Start Date]@row)) This works just fine and returns the proper counts. The Shop column is a number/text field - and the Review Start Date is a…
Ideas to track schedule maintenance
I'm curious for some inspiration please! I'm using a form to log usage of machinery. This collects data on the time used in minutes, which I convert to hours and total for each machine. The machines need routine maintenance every 20, 200, 300 and 400 hours. I'm looking for ideas on how I can use the total hours run for…