-
Using IF -> Cell Reference -> OR
Hey folks, Basically I'm trying to put a cell reference in between two logical statements. In this case, if either "Person A" or "Person B" are in the cell, return "Team A". Here's my formula: =IF([Assignee Contact]@row = (OR("Person A", "Person B")), "Team A", "N/A") I can't find anyone indicating that this is even…
-
Struggling to send automated approval requests to multiple contacts generated by formula
This is the formula in my Assignee Emails Column:=IF(Parent@row = 0, email@row, JOIN(CHILDREN(email@row), " ") + " " + email@row) Then I get the emails populated throughout the hierarchy in Project Assignees column: =IF(OR(COUNT(CHILDREN(ID@row)) > 20, COUNT(ANCESTORS(ID@row)) = 0), AssigneeEmails@row,…
-
set health based on multiple status columns
Hello! I appreciate your help! I would like to have a health column that is based on the status columns. For example, if three of the tasks are in progress, but one is delayed, I want the health column to be yellow to show a risk. Is this possible or does the symbol need to be based on input from a single cell? Thank you!
-
Help dynamic dashboard
Hello, I'm looking for some help setting up a dynamic dashboard. I have a sheet per project with various financial and activity information and I want to create a dashboard where a project manager can enter their project number onto a dashboard and see summarised information for that project. I have tried creating and…
-
I have a sheet and need help with a formula
I want to calculate the Spend dollar amounts (Spend) for all (At Risk flags) that are checked or red
-
COLLECT function Criteria Not Working
I am attempting to identify the bottom 2 ranked records from the "Progress" column but I only want to count records that are checked in the "ProMO-Objectives" column. I am trying to identify the bottom records in the "ProMO Rank" column using a combination of IF, SMALL and COLLECT functions (formula below). The SMALL part…
-
Project Plan - Settings, Turning off/on rows per selections
Hello All, Looking to see if there is a setting/function to turn off/on specific rows or tasks in a project plan based on selections. I work with large plans for market launch. Depending on the market type, there may be deliverables that are needed or not needed. Example - Can I select a project sponsor or market type in…
-
SUMIFS Based on Children
Hello, I use Smartsheet as a future revenue reporting tool. I have a total at the top for individual managers, formula for total is a SUMIF function. Formula is =SUMIF(CHILDREN(WAM$8), WAM1, CHILDREN([Est Revenue]$8)) WAM 8 is our total for everyone section, WAM1 is for individual managers, Est Revenue 8 is our total Est…
-
Help on SUMIF Formula not showing a negative value
I know this has to be something simple but my brain just can't get done this morning, so any help is greatly appreciated. I basically need a formula to take one cells value and minus another cells value if one cell is greater than 0. This is the formula ------- =SUMIF([Actual Device Tags]@row - [Quoted Device Tags]@row,…
-
COUNTIFS 4 variables
Hi, I need help with this formula. As you can see I am hoping to count when the name: Category Management is found in FUNCTION 100% is found in PERCENT COMPLETE S-CL is found in PERIOD and Day 1 is found in PERIOD Goal is that if all attributes are found, the count and provide a total. My formula is below.…