# Combining 2 Formulas

Options
✭✭✭✭
edited 12/09/19

Hi,

I have a column that is calculating today minus a date that is in another column. I have another column that is taking the days and converting it to weeks. Then i have another column that is taking the weeks and rounding down to 1 decimal point.

Is there a way to combine the column converting to weeks and the column rounding down?

Here are my formulas:

=NETWORKDAYS([Start Date]@row, [Finish Date]@row) - 1

=[Duration (Days)]@row / 7

=ROUNDDOWN([duration weeks]@row, 1)

Thanks for the input!

Tags:

• ✭✭✭✭✭✭
Options

ROUNDDOWN(((NETWORKDAYS([Start Date]@row, [Finish Date]@row) - 1)/ 7,1

Give that a try. Smartsheet is pretty friendly at combining formulas, usually you just need to treat a formula as an output when dealing with multiple, if that makes any sense. It is kind of like basic algebra

example=

ab + c = X

Xy + b = z

therefore

(ab+c)y + b = z

• ✭✭✭✭✭✭
Options

Another way of explaining it...

Enter the cell that is [duration weeks]@row as if you are going to edit it. Highlight everything except for the beginning =.

Enter the cell containing the [duration weeks]@row cell reference, and highlight that reference.

Paste the formula (minus the first = of course) that was in cell [duration weeks]@row into where that cell reference was.

.

I use this method quite frequently when building complex formulas to test each part out individually while using cell references to keep it all working together. I then work backwards and replace cell references with the formulas that were in those cells.

• ✭✭✭✭
Options

Thanks for the help. The formula worked great!

Thanks for the explanation Paul!

• ✭✭✭✭✭✭
Options

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!