-
A Report that filters based on predecessors
I'm afraid I know the answer to this, but I'm working with a very large project plan and I want to flag one task in a report (or maybe a filter? or… a helper sheet?) where I can isolate that one critical task and all if its predecessors. The goal is to see in one view that task and every other task that precedes it (or has…
-
INDEX / MATCH - Do I have to enter a MACTH value in " "?
I have an INDEX / MATCH that works fine if I enter the MATCH value in quotation marks… But if I want to use a cell reference instead… …I get NO MATCH. So I guess the only way this works is if we use text in quotes?
-
Manpower Projection Formula
I have multiple schedules for different projects with the same base information: Task Name (Primary) Start Work Date End Work Date Duration (Dependencies are enabled) Manpower Needed Many tasks have durations that overlap with other tasks. I want a separate manpower projection sheet that tells me each day what the total…
-
Help with a SUMIF Formula please
Can someone help with me with an entire column formula so that I don't have to manually click through 25,000 rows of data? I would like the "Transaction Amount" column added and put in the "Total Client Revenue" column IF the "Transaction Type" column says 'payment'.
-
CountIF for whole column Not just a range of rows
I'm trying to count the numbers of "text a" appears in an entire column. This is the formulas I'm working with, that both produces an unparseable error are: =COUNTIF(contains("Resident Instruction", [Resident or World Campus Offering])) =COUNTIF([Resident or World Campus Offering], ="Resident Instruction") What am I doing…
-
How to Populate Row based on cell option from separate sheet?
I’m looking to populate an entire row on a Smartsheet based on the cell option that is selected from a drop-down menu in a separate sheet. Specifically, I want to populate the row in the Master sheet with the information from the row in the sheet that contains the drop-down menu. Thank you.
-
Overallocation flag in sheets
Is there a formula or method to identify if a resource allocation flag is triggered for a given row? i.e. have another column in the same sheet that is checked/unchecked or true/false if the "red man" flag is on for a given row? I'm trying to figure out if there's a way to summarize all of the rows in our project sheets…
-
#DATE EXPECTED error in COLLECT
Greetings I have been trying to figure this out for a couple days now. Let's say I'm trying to get expiration dates for fruits, which is 1 week after they are bought. However, if I have two apples (initial apple and follow-up apple), I'm only interested in the expiration date for the initial apple. After a lot of attempts,…
-
Counting instances of a request that meets certain conditions but it's not counting sequentially?
Hi, I'm trying to count the number of times a request appears that matches certain conditions. I want the first instance it appears to be 1, and the second instance to be 2 and so forth. Right now, this is what I'm getting when I filter for the requests that meet the conditions I'm looking for. I don't know why it jumps to…
-
I am trying to create a column with all emails associated with a certain name in the column
HI, I have a problem where I need to give access to certain rows of information to people in the same group. I have a smart sheet set up right now that looks something like this. I am looking to put all of the emails in group 1 into the access column so that I can have only people associated with the group to be able to…