-
Creating a formula that references a static cell?
Hello, I have a form that is submitted to one of my sheets daily. Currently, new entries populate at the top of the sheet. I am using a formula that always needs to reference the top row, or newest entry. Is there a way to accomplish this? Currently, if a new entry is submitted, the formula changes to tracking row 2…
-
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…
-
INCORRECT ARGUMENT SET
Hi, First time poster here. I see there is a great community of users here willing to offer their expertise. I am struggling with a formula and am hoping to get some help. I would like to reference a different sheet to display an average score for a date range (by quarter) for each of our query authors. When using the…
-
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,…
