-
Formula that will pull the most up to date information from
Hello I have a sheet that gets new entries every month and each month, the status of the project is calculated and may update. I have another sheet that holds the project information and it needs to show the most up to date status of the project. I was wondering if that is possible to do by a formula that will take the…
-
Sumif column name contains "Tax"
Hi All, I'm using smartsheets to track scores from daily quizzes taken by members over several teams. The end goal is that we want to compare the total scores from each team in a dashboard, so I'm trying to use the sheet summary to calculate the totals. Basically, each column on the sheet has one employee's name and the…
-
Formula Help with CountIf from another sheet
I'm trying to get the total count from a column in another sheet. The column is a drop down list and I'd like to get the count of a particular selection. I keep getting #unparseable no matter what I try. Here is my current formula. =COUNTIF({Source Sheet Column}:{Source Sheet Column},CONTAINS("Discovery",{Source Sheet…
-
IF + ISBLANK Formula
Hello, I am not being able to apply this specific case of the formulas IF and ISBLANK combined. Can I have some help? I want the formula to return "Pending" in the verification status column if all yellow cells are blank, and "Verified" if at least one of the yellow cells is filled out. Thank you so much in advance!
-
Intake data-> Project Sheet...Why so difficult????????????????????????
All I want to do is take what's in a row in the intake sheet and have it populate into a column in the project sheet. I feel like I'm making this too difficult, but after much review of previous helpful answers in this community, I still have issues I can't solve. Hoping you all can help. Issue 1 Index match gives me the…
-
Health Status on Report
Hi All, I've been building my files and reports. I've gotten my RGY formulas down, however, how in the world do I get it to give me a RGY health summary as it does for the other columns? I have a report that pulls in each rep as I have it below, just missing that one piece! Am I missing a step?
-
Creating an automated report
Hi, It's me again. Today I would like to ask if it is possible for reports to automatically select items that meet all the requirements of a set criteria. What I would like to do is make it so that when a task is completed and the box is check, that that task is added to the report and displayed on a dashboard. Is this…
-
INDEX MATCH MULTIPLE CRITERIA
I need an index match formula that can return a match when multiple criteria are met. such as All A's & B's in sheet 2 and indicating a MATCH in sheet 1
-
Is there a way to 'automate' the filling of a DATE column via a formula?
Hi Community, My scenario: I am using a MIN/COLLECT formula to pull the earliest date from a list after a set criterion is met. I now want to have the same field 'lock-in' the date when another criterion is met, column x = "Scheduled". I am unsure if this is possible without creating a circular dependency. I did think to…
-
Health column formula to automatically change based on due date
Hi all, Looking to get some help / formulas to help me with my sheet. I would like my health column to change colours automatically based on: Green = Status column marked completed Yellow = due date two days away from today Red = Due date in the past