-
Date-based RYGB balls automation
Hi, For the past couple of days, I have been trying to automate my RYGB balls based on Target End Date and Actual End Date columns. I've been reading this article, but I cannot seem to get the formula right. These are the conditions I am trying to satisfy: * BLUE = if the Target End Date cell and Actual End Date cell are…
-
Persistent formula cells
MS Project has a lot of built in features that SmartSheet just doesn't have. Such as calculating if something is late, setting a deadline that flags if the date moves, calculating AWC and SWC, etc. To that end I have created a bunch of hidden cells that do all the needed functions and checks, and then built the…
-
IF(OR) Help needed
Hi All - I'd like to use a formula to evaluate status of red OR yellow then flag if red or yellow. I think I'm close but it's not working, please help. Here is what I have: =IF(OR([Status6] = "Red", [Status6] = "Yellow"), 1) (doesn't work) =IF((Status7 = "Red"), 1 (this works for red and sets the flag on for reporting…
-
Past Due Formula Help!!! - IF / AND
I cant seem to get the formula correct for this scenario: If "End Date" is Past Due AND "% Complete" is NOT 100% = "Complete" to turn flag red in "At Risk" column Am I correct that the formula would go in the "At Risk" column?
-
Count Blank Cells
Hi I am using Smartsheet for invoice approvals and would like to summarise how many documents are still awaiting approval. I have tried using a countif formula to count all cells that are blank in a certain column, however I get results that include lines are not used, e.g. there are 10 documents entered on separate lines…
-
Display predecessor task NAME
We would like to write logic to display all predecessor task NAMES in a new column. So we want the predecessor task ID to be in its usual column, and we want a NEW column that shows the NAMES of the predecessor tasks. Anyone done anything like that? Thanks Robin
-
Triggering an email when a subset of tasks are complete.
I have a parent task and 3 subtasks. When the Done checkbox is checked on the three subtasks I would like to send an email. How can I trigger this email?
-
Project Revenue Review Formula
-
Best practice of recording occurrences
Hello - apologies if this has been covered elsewhere, I've tried to search for the answer but can't find anything which may work for my purposes. Ultimately, it may not be achievable, but I thought I'd ask: I am creating a group of sheets for a team I work with, and they're dealing with recruitment of individuals (inwards…
-
How to make a different rul???
Hi I want to make a rule, so my health symbol automatically turns green if the status changes to completed. Can anyone help?
