-
Adding at risk based on health color
I'm trying to make a formula to set a flag in the at risk column based on whether the health is red and at least 3 days past the due date. Something isn't behaving quite right on the 3 days part and it's flagging some things that are not yet 3 days past due.... Here is what I have, is this not correct? =IF(AND((Health@row…
-
Nested if & countifs to generate a prefix based on number of occurrences
I am trying to get this part of a concatenate to work but keep getting #unparseable. The latter part of the concatenate works and generates a unique identifier for the project. However, the beginning section is meant to generate a prefix based on whether this project is the first, second (b), third (c) etc. project with…
-
Show all Children Health Ball Colors in Parent Cell?
Here's an example, if there are 3 children with different health statuses (see ss below). Is there any way to show all three colors in the parent field? Thanks!
-
Using a VLOOKUP and IF statement to return different values based on two different columns
Hi, I'm so sorry if this kind of question has been asked in the community forum but I've been trying to comb the questions but haven't had any true luck yet. Currently I used a VLOOKUP function to populate a personnel contact column based on a particular project column. That part is working correctly. However, recently I…
-
Parent Flagging based on Child Rows
Hello, I'm working in a project planning trying to highlight if a specific row, or project, has any task as children that is at risk. Does any syntax support this function?
-
Countifs function when using multiple contacts in a cell
Hello, I am trying to run metrics on assigned tasks that are assigned to people on my team. I have reports that will pull into each person's task report even with multiple assigned contacts in a cell, but when I do COUNTIF for a specific person's task, it does not count because there are multiple contacts in a cell.…
-
What is wrong with my formula?
Hi all, I'm trying to write a formula with the following conditions to get the % Complete Complete - 100% N/A- 100% Outstanding - 0% Partially Complete - 50% for example, if we have 4 tasks - 2 of them are N/A and 2 of them are complete - it should be 100% since N/A and complete acts as 100% if we have 2 partially complete…
-
RYG status set by % Complete and End Date
I am using a Smartsheet template (Project Tracking Template) and it comes with RYGB statuses. I would like to only use RYG and adjust the formula but am failing miserably. Please help!!! Here's what I'm trying to accomplish: Green = If % complete is 100% or if end date is greater than today Yellow = If % complete is not…
-
Date Comparison Formula Help
I am a SmartSheet novice, but my team is used to base tracking in SmartSheet. I would like to set up conditional formatting that highlights if a site's planned schedule puts the site at risk. I would like to compare two columns: "Construction Schedule: Turnover to Retail Date" against "Exterior Installation: Scheduled…
-
Merged: Formulas in automation
This discussion has been merged.
