• Scott Brunson
  • NEWBIE
  • 0 Points
  • Member since 2021

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
Team,  new to this area and may not be using the correct terminology.  Need help w/ formula for adding picklist values. I've been know for going around my elbow to get to my thumb so I'm sure there is an easier way. 

Formula I am using is:
VALUE(BLANKVALUE(TEXT(Equipment_Time__c), '0'))/60 +
VALUE(BLANKVALUE(TEXT(Inventory_Time__c), '0'))/60 +
VALUE(BLANKVALUE(TEXT(Lab_Time__c), '0'))/60

This works. 

Here's my problem.
They have requested me to add two more rows -  (Equipment_Time_2_c), (Equipment_Time_3_c).  I tried this formula (got no sytax error) but numbers are adding up correctly.   Can you help direct me please? Please Help! 

VALUE(BLANKVALUE(TEXT(Equipment_Time__c) + (TEXT(Equipment_Time_2__c) +(TEXT(Equipment_Time_3__c ))), '0'))/60 +
VALUE(BLANKVALUE(TEXT(Inventory_Time__c) + (TEXT(Inventory_Time_2__c) + (TEXT(Inventory_Time_3__c ))), '0'))/60 +
VALUE(BLANKVALUE(TEXT(Lab_Time__c) + (TEXT(Lab_Time_2__c) + (TEXT(Lab_Time_3__c ))), '0'))/60

Service Number formula
Total Hours formula that rolls up from child to parent
Showing decimal numbers in picklist value added work with single line entries
API values I am using to get time values
Team,  new to this area and may not be using the correct terminology.  Need help w/ formula for adding picklist values. I've been know for going around my elbow to get to my thumb so I'm sure there is an easier way. 

Formula I am using is:
VALUE(BLANKVALUE(TEXT(Equipment_Time__c), '0'))/60 +
VALUE(BLANKVALUE(TEXT(Inventory_Time__c), '0'))/60 +
VALUE(BLANKVALUE(TEXT(Lab_Time__c), '0'))/60

This works. 

Here's my problem.
They have requested me to add two more rows -  (Equipment_Time_2_c), (Equipment_Time_3_c).  I tried this formula (got no sytax error) but numbers are adding up correctly.   Can you help direct me please? Please Help! 

VALUE(BLANKVALUE(TEXT(Equipment_Time__c) + (TEXT(Equipment_Time_2__c) +(TEXT(Equipment_Time_3__c ))), '0'))/60 +
VALUE(BLANKVALUE(TEXT(Inventory_Time__c) + (TEXT(Inventory_Time_2__c) + (TEXT(Inventory_Time_3__c ))), '0'))/60 +
VALUE(BLANKVALUE(TEXT(Lab_Time__c) + (TEXT(Lab_Time_2__c) + (TEXT(Lab_Time_3__c ))), '0'))/60

Service Number formula
Total Hours formula that rolls up from child to parent
Showing decimal numbers in picklist value added work with single line entries
API values I am using to get time values