If Then Help

Options

I'd like to have a main input cell for # of items being shipped. Sheet is being set up to ship 40 items. I'd like to have 4 other cells which populate based on the main cell's value.

(Example 1)

Main Cell: 5

Cell 1 (0-10 Items): 5

Cell 2 (10-20 Items): 0

Cell 3 (20-30 Items): 0

Cell 4 (30-40 Items): 0


(Example 2)

Main Cell: 25

Cell 1 (0-10 Items): 0

Cell 2 (10-20 Items): 0

Cell 3 (20-30 Items): 25

Cell 4 (30-40 Items): 0


Can I use If then statements on this?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!