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!