-
I need help with a formula for Schedule Health.
Currently its working in reference to "Todays" date only. I need the formula to take in consideration the "Completed Date" and not turn "Red" or "Yellow" if the task has been completed by the "Target Date". Currently using: =IF([Target End Date]1 < TODAY(), "Red", IF([Target End Date]1 = TODAY(), "Yellow", IF([Target End…
-
Percentage Formula's
I have a beneficiary nomination form I am asking employees to complete, I am giving them the option of 4 beneficiaries, but would like to be able to tally the total percentage amounts they input per beneficiary as they complete the form to a total of 100%. So would be 4 fields/columns allowing percentage inputs, if they…
-
Edit cells with column formula
Is there a way to edit the cells where a column formula is used? I am trying to link information from 1 database to another via a INDEX MATCH formula, so we don't have to re-write info 2 times. However, the databases does not contain the same projects (we link info based on project number). See below - Project name is…
-
Merged: Bring in Multiple Contacts to a Contact List Field using Index Match Functionality
This discussion has been merged.
-
Make a link reference in a sheet to data in a report?
Hello, I want to link data from a report (a grouped sum amount) into a sheet with a reference link and/or add it to a formula. How can I pull data from reports to use in sheet formulas and/or rows/columns? Thank you, Angela
-
Count Children Specific Year
Hi! I keep receiving the "unparsable" error when trying to Count from Children (sub rows) for a specific year. Current formula entering is =COUNT(CHILDREN([Alliance Partner(s)]@row), ([AM/PM Years Active]@row, = 2024)) Note: AM/PM Years Active column is a multi-select for the years active for those rows/subrows. Any advice…
-
Using SUMIFS formula with CONTAINS or HAS as Criterea
I'm trying to only add up budget line items from specific months and that do not contain the value "Total" in their account code. Here's the formula I have and just can't get right. After breaking it apart, I'm finding the CONTAINS part of the formula is what's incorrect. =SUMIFS({Budget Detail $}, {Budget Detail Acct…
-
INDEX COLLECT formula when the Criterion contains more text than Criterion Range
Hello, I have a formula that works correctly to index "Obser 1" text when there is only one "Vendor #" in the Criterion cell and there is an exact match to the "Vendor Number" in the Criterion Range column. =IFERROR(INDEX(COLLECT({Obser 1}, {Vendor Number}, $[Vendor #]$1, {Vendor Location}, $Location$1), 1), "") I need…
-
Can I automate sub task numbering
What I'm looking for is to assign ascending numbers to each sub task, starting from 1. Like how I have included in the photos. Update: I found the threat where people are talking about the WBS template. If you're reading this and you have not found it yet, here is the link…
-
copying data from row above to rows below via column formula
With form 1 in this example we enter account manager, client hit submit, the another form opens to fill in the services performed, so our users don't have to fill in redundant information for each service. Is there anyway to use column formulas to fill in the Updated Account Manager so when we use reports we can filter…
