-
How to change star symbol to number equivalent?
I want to change the number of stars in a symbol column to a number equivalent in a column next to it, but do not seem to have the formula correct. It looks like it is a valid formula, but all I receive back is a blank. Here's the formula: Any thoughts on how to make this work would be appreciated. Thanks, Bill
-
Help with a NETDAYS formula
I have a formula in my sheet that is counting the days of an assignment since it was assigned. I would like it to stop counting once the row is marked complete or a date of completion is added. For example, in the screenshot below, the 37 in row 4 should be a 36 since the "Date Completed" column is filled in and/or the…
-
Project IDs and Data Mesh: How do get Data mesh to grab the newest data in a sheet, not the first.
I am building out my organization's portfolio. I have a series of helper sheets that move data through the backend depending on the review venues and approval processes the project may need to go through before it get's its project ID. (See flow chart below) Once a project has been given final approval the row is moved…
-
Running Count with Specific Criteria
Hello! I have a spreadsheet with different projects and their statuses. I'd like to make a running count of projects with certain statuses indicating they're still open (there are statuses indicating they're closed). I'd like to show a running count of how many open projects there are. There are six statuses indicating…
-
How to count total number of requests submitted?
Hi, I am trying to find a formula to count the total number of requests submitted in my grid. I want the formula to count the number of request ID's displayed. I want to use this number so I can display a metric on the dashboard. I also want to use a formula to count the number of "In Progress" requests and use this to…
-
Need assistance with Resource Management formulas
I've got a sheet going that lists all of my active projects. Each project has a deadline (in its own "Deadline" column, Archives Department remaining hours (in its own "Archives Hours Remaining" column), Digitization Department's remaining hours (in its own "Digitization Hours Remaining" column), and Platform Department's…
-
Comma and point
Hello, i got a few columns (text/Number), Column a-b-c-d . Column F is the total of all the others. All columns are with $ sign if i'm adding an amount with a point it's fine the amount got the $ sign and it's adding to F column. But a co-worker is using the same ( point) but the amount is not add to F column, neither the…
-
Adding a Formula within an "IF" statement
Hey there, I was wondering how I would tell the sheet to read a cell and IF the requirement is met it would generate a value otherwise, run a formula. So something like, IF( "Total Deposit Paid" = 0 than generate "0" otherwise generate "=SUM([Gross Rent]@row - [Rent Credit]@row + [Rent Debit]@row)" Thank you!
-
Reverse PMO query
Hi there, I am running hotel opening projects - and using the PMO set up to run multiple openings simultaneously. Now, the one driver that changes the tasks (+700) is the "practical completion date" of the building. I just want to input the delivery date and that all tasks dates changes - in the current PMO set up the…
-
Automated notifications
Hi Brain Trust I have an automation that when the status is changed to onboarding a notification is sent to xx@xx.com.au. HOWEVER - when several rows are updated in quick succession and then saved, the notification sends out a combined notification instead of individual notifications We tried changing to update the status,…
