Combining 2 Formulas

Kyle Lewis
Kyle Lewis ✭✭✭✭
edited 12/09/19 in Formulas and Functions


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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!