-
Re: Removing Old Users from Member True Up
Hi @Andrew Gardner, Thank you for bringing this to our attention! I’ve been able to determine that users reverting to members after being set to “No Access” is caused by a bug, and I can confirm that…1 · -
Re: Trying to get a list of distinct values across multiple columns based on multiple criteria
Hi @Jpress, I think I’ve got it! The issue with adding the IF statement at the beginning of the formula is as you’ve seen - that results are only provided on rows where the WBS is 123. We therefore n…1 · -
Re: JOIN(INDEX cross sheet with multi select criteria
Hi @Mad Ed, Try this: =IF(NOT(ISBLANK([Area of Expertise]@row)), JOIN(COLLECT({ARM}, {Discipline}, HAS([Area of Expertise]@row, @cell)), ", ")) This worked in my test sheets to return the r…1 · -
Re: Automated project ID using 2 column variables
Hi @Carmen H, I’ve tested the formulas that @L J provided and they’re working for me - thanks for the great advice, L J! The formulas will work with dropdown columns and the order of the columns in y…1 · -
Re: Alert automation shows it has run but alert was not received
Hi @Dale Heincelman, Glad to hear you’re now receiving the alerts! Regarding comments (and attachments) in alerts, this help article outlines when they will or won’t be included (check out the “Comme…1 ·