Hi Community: If a task has gone unassigned for >=5 days after initial entry has occurred AND the task has not been assigned to someone, I need to flag the concern and workflow route to a specific ind…
Hello All, I am trying to write a formula on a Status column. the conditions are: Not Started if planned start date is in the future and actual start date is blank. In Progress if actual start date is…
I have a form with multiple departments that are checked if they are affected. sometimes it might be one, sometimes it might be all (12 of them) or anywhere in between. If they are checked an update r…
I ran into an odd situation where the formula I am using is not working in some cells. I tried using this as a column formula (How I would prefer). I also tried it as a cell formula. But I have random…
Hey friends, I'm finally figuring out a complex system to have a first sheet with a Dropdown data row, matched to a column with a helper row that only highlights the MAX (most recent) dropdown. I'm do…
Is there a formula that you can suggest that will count the number of times a Date has been updated in a specific cell? For example; if I have a date of 4/1/2025 and I update it to 4/21/2025, I would …
Hello, I would like to sum up costs only for cells that have multiple homegrown fruits within a single month. In this example, January's sum would be $3,500. I've tried a few formulas and thought I go…
Hello, I am using the column formula below to extract the time from the "Created Date" column. =SUBSTITUTE([Date Submitted]@row, DATEONLY([Date Submitted]@row), "") However, you can see in the screen …
Hi all, I can't understand why this simple calculation isn't working, or if it's my brain! I am trying to calculate in the highlighted cell, 29 * 73,000 Euro each time it returns zero. The 29 is a for…
Hi! I need some help getting a formula to work for a sheet summary and have confused myself at this point. I need to get a sum of the reach our national events collected within Q1. Columns: National_l…