This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I have a script that looks at a Festivals table and based on a date input prompt in the script it returns any festivals that are occurring during the date input by the user by looking at the start and end date fields. I'd like to further modify the s...
Hello!I'm creating a base that will capture all of my sales. The base consists of a customer table, products table, sales table, and I'd like a goals table. Ideally, the goals table would be have a column for the month/year, my goal amount of sales f...
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...
@TheTimeSavingCo Thank you! This worked wonderfully! I hadn't realized we could link within a table. I had always just had it in my mind we could only link outside of that table. I really appreciate your time.
Adam,Thanks! This is what I did end up setting up for monthly, but where I'm still stuck is how could I do something that would also allow a yearly round up. Ideally, the yearly would take a rollup of each month's goal amounts to get the total Yearly...
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...
