-
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?
-
Date Formula
Hi. I have finish dates for tasks and need to start them 120 days prior to that. How would I write that formula. Thank you!
-
Populating text cells that show minimum value
I am in the process of creating a sheet to populate low bidders. I have two columns; vendors and total cost. I've included a cell formula in the total cost column to automatically populate the low bid value : =min(cell1, cell2, cell3, cell4, cell5). My question is, how can I create a cell in the 'vendors' column to…
