I have a series of fields I want to concatenate together. The final result needs to include a semi-colon in between each piece of data, but not all columns have data. So I was working to do an IF statement to check if the last of the columns (far rig...
Hello!I know at one time there were several threads that spoke to extracting the First Name from a full name, and also a formula for extracting the Last Name. While I can find several threads with the code for First Name, I cannot find any that show ...
Hello!
I have a formula with nested IF statements that works except that what I realize I actually need is to not have the logic stop when it finds 1 of the IF statements true, and actually continue on to validate the remaining IF statements.
It very...
I’ve read the community for how to get the harder-to-read date cleaned up for automation with emails that include that field. I made a new column that formats the date/time to MM/DD/YYY and it populates fine in the table. However, the emails show not...
I currently have the following IF nested statement. I don’t get an error when saving, but it only works when the first IF is found (13) and produces nothing for a result when the other two are in the identified field to check.
Am I missing a key elem...
Solution found! Thanks to this Reddit thread which introduced me to the AI tool "Excel Formulator" I was able to put a prompt in that gave me this formula which works like a dream! Didn't even need the concatenate function. REGEX_REPLACE(IF({Revenu...
@pressGO_design Oh my, you're so right on the commas. I just put in a bunch around all the semi-colon additions, but I have a feeling I'm still missing some (or something else) as it still isn't valid hahah. I feel like there is probably a REGEX form...
@Ron_Daniel that is the typical way I setup every table, however, someone set this one up and I'm trying to make it work without having to do a ton of manual work now afterwards I'm willing to risk the first name being split up as I recognized that ...
@augmented Thank you!
I was guessing that there may be a data table that was displaying the date in local vs everyone seeing GMT, etc. I ensured they were all the SAME and that finally stopped producing the error when I applied your latest example :...
