Text(FLOOR(NOW() - CreatedDate)) &" "&"day(s)"&" "&Text(FLOOR(MOD( (NOW() - CreatedDate) * 24 ,24))) &" "&"hrs"&" "&Text( FLOOR(MOD(((NOW() - CreatedDate) * 24)*60 ,60)))&" "&"min")
The second formula I got off the boards and it keeps track in business hrs the number of hrs a case has been open:
IF(AND(MOD(TODAY()-DATE(1900,1,7),7)< (NOW() - CreatedDate ), ((NOW() - CreatedDate )<7)),((NOW() - CreatedDate)-2) * 24, ((NOW() - CreatedDate)-(2 * ((NOW() - CreatedDate)/7))) * 24)
Both of these formulas work great, however, I would like to have the business hrs formula in the same format as the first formula. So it would be business hrs in days, hrs, and minutes. Does anyone have any ideas?? I keep playing with it but it is always off.
Please assist: I have created a Custom Object called Complaints. It has a Master/Look Up Relationship to Account. I have also added a basic Look Up Relationship to Contact, so the Complaints will show for the Account, as well as on a Contact, and Complaints can be recorded on either level.
Here is my issue: When a Compliant is entered from an Account it works as expected and populates the Account field (Master/Look Up ID) as it should. When a Complaint is entered from a Contact, obviously the Master/Look Up, Account is not populated.
What I would like to be able to do is the following: Create a formula to look up the Account ID from the Contact record that the Complaint is being entered on and return that value (Account ID) to the Complaint record as the Account (Master/Look Up) value. This would take care of linking the Complaint correctly across both Account and Contact objects.
I would greately appreciate help as I haven't been able to loacate how to do this.
The problem is this doesn't actually show up for the user until they've saved the opportunity, so they either select something else and get confused when that selection changes (which is fine from a data management standpoint, but not to the user!), or don't realize the rule is there and select the necessary choice anyhow (then complain about having to remember to make that selection for that account, not knowing they really don't).
So, is there any way to trigger the field to update as a user selects "new opportunity" from within that particular account that I'm missing?
I am a VERY new salesforce user, and unfortunately am likely trying to tackle too much, but basically, I have a custom field that I want to add a validation rule for. I have a 9 digit alphanumeric field that has a very specific set of validations I need performed. I would GREATLY appreciate the help.
The number is 2 letters, 6 numbers, and 1 checksum digits. The 2nd letter is the initial of the contacts last name and the 7th is calculated as: add 1st, 3rd, and 5th digits, then add 2nd, 4th, and 6th digits and multiply by 2. Add those 2 numbers together. The last digit of this last sum shold be the 7th digit.
I know this is likely crazy, but I would like to verify the following:
1. The field is exactly 9 digits, and the first two are letters, and the last 7 are numbers.
2. The 2nd letter matches the first letter of the contacts last name
3. the 7th digit is equal to last digit (ie. RIGHT(x,1) of ( (1st+3rd+5th) + ((2nd+4th+6th)*2) ).
THANK YOU VERY MUCH FOR YOUR HELP!!
Error: Incorrect parameter for function =(). Expected Date, received Text
ISPICKVAL(Negotiation_Status__c , "Declined" ), Declined_Date__c
This fills in the one field which is great, however, we want to pull over 3 or 4 other fields that correspond to the custom object field.
Also, as a separate problem, if trying to lookup a number (field) from the custom object and it doesnt exist, i would like to be able to create a new one if it doesnt already exist, but there is no 'New' button available when doing the lookup.
Any help would be greatly appreciated!
Message Edited by SeawardT on 10-05-2007 07:51 AM
Message Edited by SeawardT on 10-05-2007 07:54 AM
I created two fields under the account level - a marketing stage (prospect, targeted, inactive), and a marketing stage last modified date.
I now want to create a rule that will trigure if:
The marketing stage is "targeted" and has not been changed in 90 days. I assume it will be something to do with: if stage = targeted, and today()-date last modified > 90. But I don't know what the formula would be.
Also, won't the numbers get thrown off when today is february 1st and my last modified date was sometime last year?
Thanks so much..
I thought this should be simple, but it didnt work out the way I had it in mind. I have a checkbox named ALL. I want to write something in a textbox if the checkbox is checked.
All I did was
IF ( All__c, Link_selected__C = " some text here", null).
But when I create a new object, nothing is entered into the text field Link Selected. And there is nothing in the field when I save the record.
Would appreciate any help.
Field #1 name is 'USER'
Value of field #1 is '100-Bob Jones'
I want to create a second field that just has the first 3 numbers of "100-Bob Jones'
I tried using a case statement to do this but the limit is 1300 characters.
Is there any way to set a value to the first 3 characters of a field?
First three characters of the user Field.