-
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…
-
Enforce Unique File Attachments
Previously there was an option to either allow versioning of attached files or to enforce unique entries. I've skimmed through notes and questions and do not see if that is still a capability or if it has been retired. Would appreciate if anyone could point me to the location to make this administrative change to enforce…
-
Performance issues
Hi All, I have 4 sheets with 5000+ rows & with 4 column formulas. I would need to add a 5th formula, which looks like as stated below. When I added it the sheet started to slow down, it was freezing, since the formula runs on the cell basis. Is there an option to optimize the sheets' performance, when cell formulas are…
-
Using the OR function within a count formula referencing another sheet
Hey all, Trying to work out how to add in the OR function to a count formual referencing another sheet. Presently I've got..... =COUNT(COLLECT({Activity}, {Row Type}, "Parent", {Status}, "Delayed")) But the Status could be any of "Delayed", "In Progress" or "Client Delay" Any help much appreciated!! Thanks, Anna
