Formulas
Discussion List
- 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…
- QUESTION: How to create a Text string output from a formula that can be copied and pasted into other applications. BACKGROUND: I have a large project that requires many Discovery sessions and have a s…
- 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 - we are having problems adjusting a formula to include additional details. The formula is being used on a sheet for a project checklist. The parent formula shows the overall status of child tas…
- I have a formula I need help with for the top level of my project checklist hierarchy. Overall Project Status - this is looking only at the highest level rows which are indicated by the helper column …
- Hello all, I would like to retrieve the date of "LR1" with the following Index Match function (see field 18). Once I hit enter I receive the error message "#invalid column value". Is something wrong w…
- I am looking to have an automatically updated count for cases opened each week on a dashboard. Relevant data: - Date Consent Turned In To CBH] - [Member Goals] "Obtaining Consents" - I have a weekly i…
- 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…
- I am currently using the formula: =INDEX(COLLECT(Task:Task, Level:Level, 2, Status:Status, <>"Complete", Summary:Summary, 0), 1) to collect the next task due that is not completed for my summary secti…
- 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…
