Trending in Formulas and Functions
-
Check Box for Current Milestone
I am looking for help in writing a formula (or using automations) so that the most recent milestone where the status is "INV PKT SENT & PSR XL UPDT" will have the checkbox. As you can see, I can write a formula to check the box but then when the next milestone reaches that same status I now have multiple checkboxes in theβ¦
-
Can't get the "Ongoing" piece to work
I'm trying to make a formula, a typical status formula which I do often. But it was asked to include an "Ongoing" status when the % Complete column is at 99%, regardless of other conditions. The problem I'm running into is that no matter how I input it, the "In Progress" piece always overrides it, and I can't quite get theβ¦
-
COUNTM Formula Help
Is there a way to use the COUNTM formula to count the number of selected dropdown options in a multi-select column (e.g., "Deposit Accounts") only when another column (e.g., "Region") equals a specific value (e.g., "East")? For example, I want to count how many Deposit Accounts have been selected only for rows where theβ¦
