-
Schedule Health | Average RGYB symbols
Hello community, I have created a schedule health column in my schedule and used the following formula to calculate the row health: =IF(Status@row = "On Hold", "Gray", IF(AND([% Complete]@row = 1, TODAY() >= [End Date]@row), "Green", IF(AND([% Complete]@row < 1, [End Date]@row = TODAY()), "Yellow", IF(AND([% Complete]@row…
-
Question about Functions and Automations
Hi - I have a formula that calculates whether or not an end date has passed by more than 7 days using the TODAY(7) function. If it is greater than 7 days, then a checkbox is checked. That checkbox is used to trigger an automation which sends a notification to a user. My question is whether or not I have to have the sheet…
-
INDEX(MATCH formula issue
I am trying to use helper columns to consolidate form submissions onto the top row of a sheet, in order to use Document Builder to populate a PDF with the inputs from eight different sessions. There are about 10 columns per session. In the screenshot below, the "Which Session" column is a drop-down list with radio buttons…
-
Need help in formula for counting only if a specific text is within a cell
Hello, Please see the image below. I would like to count the number of Journal Articles but only those with the status "Accepted for publication(attach final pdf copy)". Currently, I am using this formula in my Sheet Summary - =COUNTIF([Activity Type]:[Activity Type], "Journal Article"). But it is also counting the Journal…
-
Need to count workdays too in the formula how can i do that?
=[Due Date]1 - TODAY() How can I make this formula in a way that it only counts working days and not Saturday and Sunday
-
Looking for help in getting a cell in a sheet to read "" or "TBD" instead of "#Invalid Data Type"
I'm using a sheet to consolidate the status and dates of several projects into a easy to read report. For several of my project sheets, I have a cell which will be reading "#Invalid Data Type" until all of the dates are added to their respected sheets and the formula can pull. What I'm hoping is that there is a way that I…
-
Formula Help
Good Morning All Wondering if someone could help me add and addition condition to this formula. I tried and keep getting an error back. I need to add if Program Status Type is NOT blank in the formula below. If the end date is less, then today and Status @row is not Complete and Program Status Type is not blank then check…
-
Is there a v lookup type formula that will find all tasks assigned to a specific person?
I am building a personal task tracker template for my team so everyone can better manage daily tasks as well ass see any tasks assigned to them as part of a project. Is there a formula or way to have project tasks automatically added to a sheet or report as they are created and assigned to a specific person?
-
=IF(CONTAINS... Syntax Error
Trying to figure out where I've gone wrong with my syntax... In a Total column I have the following '#Unparseable' formula =IF(CONTAINS(“Custom”, [Data-Pipe Type]@row), 4, 1) Help me see what I can't see please?
-
Vlookup referencing formula field
I have a text/number field which is populating by using the =Left formula. I then want to reference this field using a vlookup to another sheet and pull in the corresponding information. I keep getting the #UNPARSEABLE error, and I've determined it's due to formatting, but not sure how to fix. As an example, I have a…
