I’m trying to write a formula which returns either a value from field A or a string within the formula, dependant on the value in fields B & C. Where the values in fields B & C are met then a value within the formula should be returned, when the valu...
I have some views and even whole tables within my workspace that I want to lock so that no other users can view them. If I set a view to “personal view” then by default other users don’t see it, however other users with “creator” permissions can just...
Hi, I have a table with 3 columns, “Usage”, “Clients” and “Status”. “Usage” is a single select and can only be “Platform” or “Client”. “Clients” is a link record that allows me to select multiple client records from another table. “Status” is a looku...
Hi @Jeremy_Oglesby, apologies for the slow response I’ve been on holiday! Thanks so much for the suggestion I’ve managed to get the SWITCH statement working for the case I outlined. I’m now looking at having 2 separate conditions and then if neither ...
