How do I use the ARRAYUNIQUE() for this two-line string
I want to get the unique value of the {Photos IDs} column, but ARRAYUNIQUE() doesn’t work, presumably because it has a newline symbol in it. What should I do
Forum Posts
Check for duplicates before creating user name
I am completely out of my depth here, so I apologize for dumbing what I’m doing down. Also, talk to me like I’m a child when explaining what’s going on :grinning_face_with_big_eyes: I have built a simple website with Webflow and use Wized as the ba...
Sorting time earliest to latest
Hi, IS it possible to sort this list of times, earliest to latest? I can only sort A-Z and this is what it returns:
Resolved! Removing special characters from text for a filename
Hi Anyone have any clever tips for removing special characters from text to make them filename firendly? For example < > { } ) ( etc. I could do it with a massive nested substitute formula but that seems clunky so hoping there is a cleverer way of ...
Resolved! Regex to split string into comma-separated tags
My datafile has a field with multiple tags that are joined like this: TagoneTagtwoTagthree Is there a formula possible, with help of regex, to put a comma between all lowercaseUppercase instances to seperate them?
Resolved! How to do Partner field?
For a table with organizations I have a partner field that links back to the primary column itself. Suppose an organization has 10 partners and I put them in the Partner field, then all those organizations will get that one organization in their link...
Is there a way to make a timer increment only when a field has a certain status?
I am trying to make a formula that tracks how long a record has a certain “Status”. If the status is “Open”, the timer starts. If the status is “Pending”, the timer stops, and stores the value that it was just before the field was switched to pending...
*Help* Formula for different hourly rate for multiple workers
Bit of a tricky one for me, im looking for a formula for this situation with a multiple select box: if ‘Jon’ selected =£18, if ‘Carl’ selected =£20, if ‘Jon’&‘Carl’ or ‘Carl&Jon’ selected £38 just a snippet of what im after, i have 7 opperatives on d...
IF formula based on percent not returning int values
Hello, I’m trying to do a fairly basic calculation that is conditional on a percentage field - if the percent is above a threshold, return a calculated number, if below return 0. My formula works with anything except zero for value 2. Here’s my formu...
Workday Formula Fridays
I am currently using a workday formula to calculate an end date based on a “Start Date and an Average Length of Completion” for a task. My issue is with single-day tasks, if the task begins on any day other than a Friday, the formula works. If it sta...
