Mike_Thorington - profile

Mike_Thorington · Feb 08, 2024

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...

Mike_Thorington · Sep 02, 2022

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 ...

Mike_Thorington · May 04, 2022

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...

Mike_Thorington · Feb 12, 2024

It is possible to have more that one code per record to follow up.

Mike_Thorington · Feb 08, 2024

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. ...

Mike_Thorington · Aug 01, 2022

I could use this, please add ability to shade entire fields.

Mike_Thorington · May 27, 2022

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...

Mike_Thorington · May 26, 2022

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 ...

User Statistics

User Activity

Remove Duplicates from a lookup field

Making DATETIME_DIFF Conditional on another field

Compare multiple data points in two different tables

Re: Remove Duplicates from a lookup field

Re: Remove Duplicates from a lookup field

Re: Colored or Highlighted Fields

Re: Split First and Last Names

Re: Split First and Last Names