breso✭✭✭

I am also having this issue on all new and existing sheets.

Thank you, @Genevieve P.! That makes sense and the formula works much better with the -1. I tried it out below and verified the % elapsed by using the % complete. I had the +1 from the Advanced Formula examples (below) where it seemed situational like if before the start date then I would use +1 instead. Sorry if this…

Hi @Dom Orsler, this is a variation of the formula I am using that compares % complete to days elapsed. It first checks if the task is a milestone (Start = Finish) so I don't divide by zero. Then it populates a "Symbol" column with red, yellow, green, or blue circles. It also marks any tasks not ending in the next 30…

Hi @Marcia562, Here is a revised version that will have activities that start in the next 10 days turn green: =IF([% Complete]@row = 1, "Blue", IF([End Date]@row < TODAY(), "Red", IF(AND([Start Date]@row <= TODAY(), ABS(NETWORKDAYS(TODAY(), [Start Date]@row) + 1) / ABS(NETWORKDAYS([Start Date]@row, [End Date]@row)) > [%…

Hello @Genevieve P. & @Lucas Rayala, Thanks for all the troubleshooting ideas, your solution worked! (Image 1) I applied the filter on the source sheet (Project Intake Sheet). (Image 2) I verified the references and Rollup Status had the correct Source, but Project Name was linked to the Project Metadata Sheet for Project…

Hi @Marcia562, the column names in the formula may not match the names in your sheet. You probably need to delete the " 1" from the column names in the formula. In your Sheet you need to right click the cell and select edit column formula. In the community, you can toggle different formats: You could add an OR argument to…

@Lucas Rayala, Thanks again! It still has the same output though Project 1, , , , , , , , , , , , . Is there an array function in Smartsheet maybe the names are getting replaced by blank spaces? Because the count version of this returns 13 with matches the commas. It should be grabbing all the project names in the table…

Hi @Marcia562, Here is an updated Status formula: =IF([Schedule Health 1]@row = "Blue", "Complete", IF([Schedule Health 1]@row = "Green", "In Progress", IF([Schedule Health 1]@row = "Yellow", "At Risk", IF([Schedule Health 1]@row = "Red", "Late", IF([Schedule Health 1]@row = "", "Not Started", ""))))) Your tasks are yellow…

Hi @Lucas Rayala, Thank you for the response! I copied the formula but am still get the same output "Project 1, , , , , , , , , , , ,".

@Marcia562, the column header was missing the function icon.