set time
Hi,
=IF(Processtype@row = "Fast", Starttime@row + 30, IF(Processtype@row = "Long", Starttime@row + 60, IF(Processtype@row = "Large", Starttime@row + 120, "Not Proper process Type")))
Actually i would like to do, if procees type Fast ,, add 30 min more with starttime, Long means 1 hr,Large means 2 hr,,
can anyone pls help me to fix the problem...
Thank you for your help,
Answers
-
It thinks 08:00 is a text value, so isn’t adding 30 min as you’re expecting. Think this would require using a Date column type for both columns.
-
Hallo Mr. Jason, Thank you for your reply and time,,
i tried to change the column type,, but still same problem ,,,, Is thr any other posiibility
-
There should be a solution tucked away in this thread:
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!
-
hi @Paul Newcome i have searched on that link but am not sure how to bind up that in my solution,,
can you please help me..
-
There should be a solution there regarding (if I remember correctly) shifts that account for a "lunch break". That would be the base of the solution.
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
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!