How to combine formulas
Hi,
I'm a novice trying to make the following two formulas work together in the one cell in order to display as time format:
=SUM([Project Hrs]1 * [Percentage Project Hrs]@row)
And
=INT([Project Hrs]@row) + ":" + ([Project Hrs]@row - INT([Project Hrs]@row)) * 60
Could someone help with correct formatting to combine the two?
Also if anyone can recommend resources to learn more about using formulas relevant to Smartsheet I'd appreciate it.
Thanks
Answers
-
Can you give an example of what your desired outcome would be?
Just give me an example for project hours, project hours percentage, and what the result should look like.
-
Hi Michael,
We have total project budget in hours: [Project Hrs]1. We have a number of phases and related tasks. A column called Percentage Project Hrs which allows us to enter the percentage of the total hours each task should take.
This is shown in the project hrs column as time eg 3.8. Now if Smartsheet had a time format I could apply all would be good. It doesn't, so I need to apply HH:MM formatting to the result using the above formula.
I've had multiple attempts at nesting these two formulas but I'm new to all this and would appreciate some guidance. Thanks
-
If I'm understanding you correctly, the first formula is in the same column as - [Project Hrs]1
but instead of translating it into your format in a different column, you want the second formula to be in that same Project Hrs column.
In this case, you can replace every instance of "[Project Hrs]@row" in your second formula with the first formula! Try something like this:
=INT([Project Hrs]$1 * [Percentage Project Hrs]@row) + ":" + (([Project Hrs]$1 * [Percentage Project Hrs]@row) - INT([Project Hrs]$1 * [Percentage Project Hrs]@row)) * 60
Let me know if this makes sense! Here are some other resources that may help you as you build formulas:
- Smartsheet Formula Examples Template
- Formula Foundations Webinar
- Smartsheet Formula Best Practices
- Smartsheet University - eLearning Formula Course
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Brilliant! Just what I need.
Thanks for your help and links to resources Genevieve.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!