-
Count Parent rows only based on checkboxes.
Hello again! I am trying to create a better sheet. I have what I would call a "template". For each of the check boxes in the Report column, these correspond to a parent row. I would like to be able to have a formula that would count ONLY the parent rows. So, in my screenshot below as an example, the 3 checkboxes I have…
-
How to return most recent value when conditions met. Smartsheet Support is Stumped
Hello, I stumped Smartsheet Support with this formula question: I want to return the most recent approval status from another column based on common Project ID. I have four columns: Created Date - Project ID - Enter Status - Project Approval Status (Where the formula exists) All the columns are text except for Created…
-
Basic A/P and A/R payment tracker
We're a property management company with a construction arm. Our construction is basic and requires us simply to track Owner/Address/Date of approval/Job number (which we create)/Contractor's Bid/Change orders/Payments to Contractor/Balance to contractor/Our Bid/Change Orders/Payments to us/Balance due us/A/R for cash paid…
-
Check a box in the phase row, if all the tasks are complete
This should be easier but I'm struggling with it. If all the tasks are complete, indicated by check boxes, I want to automatically mark the phase complete. So, the box in black below should automatically check when the other boxes below it are all checked.
-
Can I use an if statement to return a numeric value based on red yellow green symbols
I am trying to create a scorecard and would like to return a numeric value based on symbols (green = 5, yellow = 3, red = 0). Is that possible? Formula help would be amazing!
-
Applying a formula for the whole column
Hi! I currently have a formula for a specific cell in a row. I would like to apply that formula to all cells in the same column. I tried dragging the formula down as far as I can go, but when a new row is added from a form, it seems to add way down my sheet (not consecutively after the last entry) and the formula is not…
-
Looking for Help / Guidance
Greetings, Looking to do something extremely simple but just cannot get it done. Hoping that the folks in this community can assist. I have 2 sheets. See below. Sheet A: Sheet B: All I am trying to do is .. in Sheet A ... Value of License Used for Customer Number (1234) be the Sum of all the same Customer Number ("1234")…
-
Need help with a formula that will pull info from 2 sheets.
Hi, I have my comprehensive sheet. Its currently pulling status info from a photography sheet. When photography is done with a project (each project has its own row), the project(row) gets archived to another sheet. When achieve, the current status of the project is no longer on the comprehensive sheet. So currently I can…
-
What formula could I use to nest automatically based on primary column?
Hello, Trying to make it so that information in columns b-f automatically nest under the names in column a instead of doing it manually as I have a large amount of data. For example, John Doe has a badge with two different types of access. I need those to nest under them while John Smith's access information nests under…
-
Project Management Plan - Schedule Health Formula
Hello, I looking to apply a formula to my Project Management plan whereby a color is assigned to each row given the "% Complete" and the "Start Date" "Finish Date". I want the health of the children rows to roll up into the Health of the parent row. I've used one of the templates with a built-in formula, however it does…