-
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…
-
Generate Ducuments with Multilines
Does anyone knows if its possible to create a document using more then just 1 line a time, meaning if i have 10 rows that i want to include into same document : example Creating a packing slip from multiple lines
-
help with IF
i am trying to write an IF situation referencing another sheet where I want if there's a ). PS the answer is 69, the formula I wrote which is wrong is =IF({VAC Intake R- Stage}, (@cell = "0. PS"), 69) any help would be greatly appreciated. Thanks.
-
Formula - Counting and Blank Data
Hi. I need to know what is the best way to Count but exclude any cells that are blank. I am looking to count how many machines I have per my programs but I don't want to count the ones that have no date. I've read I should start with Is Blank but that didn't work. Thanks you in advance. Ali
-
INDEX help NO MATCH
I want to pull the dates into this data sheet from the Schematic prep column on the Master sheet. What's wrong with my forumla??
-
CONTAINS to check box if cell has certain email domain
Hi All, I have a project plan with a column called "Owner" that has a column type of contact list. The contacts are from multiple companies. It's a large project plan. I have created columns that have a column type of checkbox. I want to check the box if the owner is from a certain company (which can be determined by the…
-
Dashboard - Show progress using project phases not %s
I'm trying to create a visual in my dashboard that allows me to show where the project is at based on our standard project phases. Vertical axis - list of project names Horizontal axis - Project phases (01-Kickoff, 02-Discovery, 03-Build,...etc.) Right now I can only show % complete but I'm trying to show the additional…
-
Rolling budget/spend tracker
I have a bit of quandary with a recurring task, wherein I am tracking weekly budget allocations and tracking what is NOT spent. Currently, I have a basic sheet where my contractors/vendors upload a patient record, which is just a sign-in sheet, and I manually count the hours used. Each of these sheets represents a maximum…
-
Running Count for Rows
I need assistance with a formula: If 'Request ID#' and 'Day of Contact' have the same info, then calculate the running total in 'Request Count'. I can't get my formula to work: =COUNTIFS([Request ID#]:[Request ID#], [Request ID#]@row , [Day of Contact]:[Day of Contact], [Day of Contact]@row , ROW():ROW(), <= ROW()@row ) I…
-
Overall Project Health Based on Health of Milestones
We use the WBS for our project plans and indicate milestones by setting the duration to 0 and the start and end date as being equal. Our current column formula is =IF(ISBLANK([Start Date]@row ), "", IFERROR((IF(OR([Start Date]@row = "", [Start Date]@row > TODAY()), "Gray", IF(OR([% Complete]@row = 1, [End Date]@row >…
-
Looking for hopefully simple formula
Hi all. Hoping this is a simple formula. I want to make the blue highlighted column the same date as left column, but 2026. In this example, I would like blue column to be: 04/03/26 06/01/26 09/05/26 01/01/26 Please help, you'll save me a couple hours :)