-
The correct VLOOPUP formula?
Hello I am needing a formula that will pull an employee level and assign it to the alias listed. I have used differed variations of VLOOKUP and nothing seems to work. Breakdown: Sheet #1 will contain a list of an employee alias's, sometimes the alias will be listed multiple times. In the column "Level (Formula)" on sheet…
-
Why do I have a formula that is not working in sheet summary, yet is working in another sheet.
I have a column with some rows marked as "Active /Won" in the "Project Status" column. I want to sum all of those values from the corresponding column "Project $ Value". I have done this successfully in another sheet, but I cannot get this formula to work on my sheet summary... In my sheet summary I get "#invalid…
-
30 Weeks Out - Formula Question
Hello, I have a project that has certain tasks that need to start a specific number of weeks ahead of the project end date. For example, I have 30 weeks out tasks, 29 weeks, out 20 weeks out, etc. On my project sheet, the END DATE is December 1, 2021. I need a formula that would tell me what the START DATE is for exactly…
-
VLOOKUP using flag or checkbox
How do I use VLOOKUP with Flag as the search value? I tried the following: =VLOOKUP("Checked", {Range 2}, 3, 0) =VLOOKUP("checked", {Range 2}, 3, 0) =VLOOKUP("true", {Range 2}, 3, 0) =VLOOKUP(true, {Range 2}, 3, 0) =VLOOKUP(1, {Range 2}, 3, 0) All of the returning #NO MATCH even if there is a row that has a Flag checked.…
-
SUMIF Question
Hello, I am trying to sum a column in my smartsheet that has numbers, but only want to sum those with a status of "Business as Usual"....seems pretty straight forward, but I'm hitting walls and have even reached out to someone who has far more advanced skills than I do. Here's the current formula I am using: =SUMIF([# of…
-
Unable to edit column formulas
I'm the owner of numerous sheets and have been excited playing around with the recent addition of column formulas. However it seems like once I have created one I am unable to edit it, even as the owner of the sheet. It just gives me a little grey message saying "I have to be owner or admin of the sheet to edit". As a work…
-
VLOOKUP or INDEX
Dear all, I'm trying to use smartsheet as a Resource Management tool, unfortunatelly we haven't get 10,000ft yet. so what I'm doing is to assign the resources that we need in each project: Project Manager and Allocation % Business Analyst and Allocation % Tech Leader and Allocation % A person can be in different roles…
-
Index Collect + Max Date
Hi there, I'm having another head banging moment. I have a sheet where we track all project comments. There are 3 different types of comments (Program, Project and financial) I am trying to return a comment, where Comment Type = any of the above, and show me the Most Recent Comment of that type. I came up with the formula…
-
Help with totaling by date
HI I am needing help to total survey responses by date. The goal is to be able to have a chart that shows responses by day. So the users fill out a survey and the results come into the sheet. I then have a dashboard that gives the results for the day. However, what i want is a summary by day and this is where i'm…
-
#UNPARSEABLE error message with formula
Hi, All, Trying to automate a Quarterly column to autogenerate in each row with Q1, Q2, Q3 or Q4 based off a side column (titled: Targeted Completion Month) with month entry (drop down menu of January, February...). In this example, I am using data from Row 120: =IF(OR[Targeted Completion Month]120 = "January", [Targeted…
