-
Creating a formula that takes the total average of a row but excludes certain entries
I need to create a formula that take the total average of the row but doesnt include entries that are "N/A" "YES" or "NO" in the count. At present when ever those are entered the formula im using counts as "0" which greatly decreases the total percentage
-
HELP WITH INDEX/MATCH ACROSS MULTIPLE COLUMNS WITH CRITERIA
Looking for formula help to accomplish the example below:
-
Using IF, Index, Match
Hello, I need a formula that will create the response "Green" if the Agency name matches the "Live Agencies" sheet to my current sheet, as well as have any of the following services (485 Review, OASIS/485 Review (No coding), or Non-OASIS 485 Review) in the "Coding Services" column of the "Live Agencies" sheet and create…
-
Dynamic formula to update a cell with a URL & Display Text
When I create a URL in a cell, it consists of the URL, and Display Text. How do I write a formula to, say, add the value from the autonumber field onto the end of the URL, and then display the autonumber field text as the Display Text?
-
Nonparseable error using IFError
this formula keeps an error. =IFERROR(INDEX(DISTINCT({Project Info PM}), ROW()), "")
-
Formula for Month in words
Hi everyone seeking for a help please I'm making a helper column formula for month I want the result as Month - day- Year (October 28, 2025) but it seems my formula doesn't work is there any way to have this formula or result as (October 28, 2025) =IF(ISDATE([Refund Deadline]@row ), MONTHNAME(MONTH([Refund Deadline]@row ))…
-
Merged: Allow single cell references to be converting to column formulas
This discussion has been merged.
-
Merged: Allow a column formula to be from a fixed cell
This discussion has been merged.
-
Merged: Allow $ (absolute references) in Column Formulas
This discussion has been merged.
-
Merged: Ability to remove a column formula from individual cells for manual updates
This discussion has been merged.