RPA - profile

RPA · Aug 23, 2024

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

RPA · Feb 17, 2023

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

RPA · Aug 29, 2022

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

RPA · Oct 28, 2021

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

RPA · Aug 23, 2024

Thank you! That works perfectly!

RPA · Feb 17, 2023

Thank you! That works perfectly! Very much appreciated!

RPA · Aug 30, 2022

Thank you!! This worked perfectly.

RPA · Aug 30, 2022

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

User Statistics

User Activity

len() count incorrect due to line breaks

Remove extra spaces within a string?

Comparing Select fields in one table

Automation script to find matching fields and link records

Re: len() count incorrect due to line breaks

Re: Remove extra spaces within a string?

Re: Comparing Select fields in one table

Re: Comparing Select fields in one table