-
NEW! Your survival guide to formulas is here. Meet the Formula Handbook.
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of all…
-
Auto Populate 10 rows with todays date each day
Is there a way to automatically add today's date to 15 new rows each day without deleting previous dates? This would let us track pull the 15 daily task items that need to be completed each day.
-
Divide By and want a max of 100%
I have a formula that I am taking two numbers and dividing by each other. Then I get a percentage. I do not want the data to come back above 100%. Here is the formula. =[OCME Data]@row / [Total Each Month]@row
-
Modified Date in Formulas
I am trying to use the auto-populated system column "Modified" in formulas. Specifically, I am trying to create a "Modified Helper" column that takes the "Modified" column date alongside the time, checks if it is after midnight, checks which shift it was logged under, and log the auto-populated "Modified" date to reflect…
-
Formula Help
I'm looking for a formula in column D belw that does the following: Subracts column A from column B, unless column C has an amount. If it does, then I need column A subracted by column C. Row 1 should be -2 Row 3 should be -5 Is this possible?
-
Un Join numbers in a cell
Is there a formula to un Join numbers in a cell. have a cell that contains this I want to pull each of those numbers out into its own column/cell Is this possible?
-
Contact Type Column automatically populating with Email
Hi all, Is there a way to automatically populate a contact type column with the name and email address if you have the 2 columns with name and email address? Thank you!
-
VLookup returns nothing for assigned to requiring multiple answers
Hi All, I am working on a project plan where I have a drop down that I can select multiple roles to assign a task to. The Vlookup references a contact list of single role, single assigned to. When using a simple vlookup formula, it will give a single answer where there is a single assigned to, but what do I do to make it…
-
Index/Collect formula with checkbox
Hi Community, working with an index/collect formula and in need of some help. Members from various committees complete a form and when submitted, it comes into one intake sheet. On separate committee sheets where the members name is already in place, I want to show when they submit their form (matching the first name and…
-
CountIfs Formula that Counts Multiple Columns, each with Multiple Values in Each Cell
Could someone please help me correct the following formula?: Formula Goal: COUNTIFS formula that reviews over 10+ columns, each cell can contain multiple values ("Allow multiple values per cell" designation) — What is a formula to count a specific combination? My Example Formula (that doesn't seem to work):…
-
Sheet Summary Formula Help
Hello, I am trying to get this formula to work but am not having any luck. When I remove the last @cell….text below the formula works great. When I add it in I get an error. Any ideas? =COUNTIFS([ACCT READINESS STATUS PLV]:[ACCT READINESS STATUS PLV], OR(@cell = "PENDING LOCAL CAH", @cell = "ADDITIONAL REVIEW NEEDED LOCAL…