The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
HelloI have a lookup field that lists every area code in each time zone. These are listed by zip code within each time zone so there are a ton of repeats. You can see them in the area_codes field:I've tried to create a formula field (UniqueAreaCode...
Hello -
I am using a simple formula of:
DATETIME_DIFF({Today},{Start Date :star: },‘days’) to calculate the number of days from the Start Date to Today.
I would like to combine an IF statement to do the following: I only want to return a number IF ...
I have one table that is a Roster of team members with various fields of data pertaining to each record. This table is imported for certain fields and other fields are manually imputed. The data on each record set has the potential to change at any...
The fields that area codes are in are individual zipcodes. Think of the zipcode you live in and all the surronding zip codes. They will all have the same listed area code(s) in that area. Some overlap, some are very large areas with 1 area code. ...
Justin_Barrett:
SUBSTITUTE(Email, "@email.com", "@sso.com")
Thank you, that worked kind of. The issue I have now is that not all domains in the email column are the same. How can I account for the not as commonly used oddball email domain co...
W_Vann_Hall:
REPLACE({Name},1,FIND("~",SUBSTITUTE({Name}," “,”~",LEN({Name}) - LEN(SUBSTITUTE({Name}," “,”")))),"")
Question for you that is related to this, but almost in the opposite direction.
We have 2 email address, essentially. We have ...