Combining 2 Formulas
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!
Comments
-
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
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thanks for the help. The formula worked great!
Thanks for the explanation Paul!
-
Happy to help!
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!