Formula Function Help
Current Formula
=IF(ISBLANK([Actual End Time 1]@row), 0, ([Actual End Time 1]@row - [Actual Start Time 1]@row) / 100) + IF(ISBLANK([Actual End Time 2]@row), 0, ([Actual End Time 2]@row - [Actual Start Time 2]@row) / 100)
Results in Actual Duration of 0 if Actual end time 1 is not entered.
Want to update the first part in bold in first formula so Actual Duration is the value in the "Baseline Duration in Hours" Cell if Actual end time is not entered. Otherwise calculate Actual duration by the second part of the formula (in bold). It is not giving me the correct values as you can see in the image below.
=IF(ISBLANK([Actual End Time 1]@row), [Baseline Duration in Hours]@row, ([Actual End Time 1]@row - [Actual Start Time 1]@row) / 100) + IF(ISBLANK([Actual End Time 2]@row), 0, ([Actual End Time 2]@row - [Actual Start Time 2@row ) / 100)
Thank you!
Answers
-
What is the length of your working day in your Project Settings? If your Baseline Duration Hours column is set as the Duration in your Project settings, then since the time is set as hours, the formula will present the number as a decimal of the working day.
For example, my working day is set to 8 hours. This means that a duration of 4 hours is returned as 0.5 in the formula, since it's half of my working day:
Is it possible that your Working Day is set to 18hrs, which would mean that 4hrs is 0.2222 out of your day?
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K 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
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!