Frank_Reagan - profile

Frank_Reagan · Jul 28, 2020

Hi! I need help figuring out a formula that will do a rollup of a horizontal range in an Asset database. SUMIF would be a simple solution if I were using excel/gsheets. Creating a separate table to do a vertical rollup is not an ideal solution, but I...

Frank_Reagan · Sep 22, 2021

Thank you so much @Justin_Barrett! This worked and is SO much easier and efficient than my workaround :grinning_face_with_big_eyes: I appreciate your explanation and resources for REGEX and I am looking forward to learning & practicing it more!

Frank_Reagan · Sep 21, 2021

This is incredibly helpful, Justin! Can you explain this aspect of the formula? "(?:[^,]*, *){2}([^,]*)(?:.*)" I’d like to understand this more so that I can adapt it to find additional item numbers in a string list, not just the 3rd position. Would ...

Frank_Reagan · Sep 21, 2021

How do I extract the third item in an array? Example: One, Two, Third Item, Four, Five Result: Third Item

Frank_Reagan · Sep 02, 2021

Hi, Kuovonne. I am also looking to send emails with Airtable automations. It would work best for us if email does not have the appearance of being automated. The Airtable branding is an obvious automation give-away. The sender display name is also pr...

Frank_Reagan · Jul 29, 2020

Great, thank you so much for the help and tips! I’ll give this a try.

User Statistics

User Activity

SUMIF / Horizontal Rollup

Re: How to find text in text string

Re: How to find text in text string

Re: How to find text in text string

Re: Remove airtable branding from 'send email' automation

Re: SUMIF / Horizontal Rollup