We have formulas to check character counts and they're returning with "over character count" for long text that is actually not over character count because they're adding characters for line breaks. Is there a way to adjust the formula to not includ...
Hi! Is there a formula (or other solution) to remove extra whitespace within a string? My formula right now looks like: SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TRIM({name})," "," ")," :",":"),” .”,”.”),” ?”,”?”),” ,”,”,”) This works ...
Hi! Is it possible to compare single and multi-select fields across columns in one table? Would a formula be able to do this?
I have a single select field listing the launch month for content. Then there are 2 lookup fields with the launch months for...
Hi! I’m trying to figure out how to extend an automation that works for one record to make it work on 200 records. I have 2 tables, which are linked. Several records from table B are linked to each record from table A. Records in table B have duplica...
Thanks @Adam_TheTimeSavingCo ! Here’s a screenshot of a small piece of the current data.
It’s helpful to see the months visually like this for other purposes. I think I could use a formula to make a date field from the first column, which is single ...
