-
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
-
Combining Multiple IF(AND) Formulas.
I have studied the Smartsheet Community boards but am unable to get my formula to work. My goal would be to combine the following rules into 1 formula: If the "% Complete" column is 100% then leave the "At Risk" flag unmarked. Mark the "At Risk" flag if the "Start" date was passed and the "% Complete" is less than .1 (10%)…
-
SUMIFS for last 7 Days
I'm writing a formula to sum the last 7 days of New Contacts (number field), where my date column is Day. Here is what I have: =SUMIFS([New People:New Contacts]:[New People/New Contacts], [Day:Day], >=TODAY (-7)) The parenthesis around the -7 are pink. The parenthesis after SUMIFS and at the end are blue. I've tried a few…
-
Counting checkboxes in a column when using column formulas
Hello, Very happy with the column formula functionality, I used it in my sheets, like this: Check the checkbox in the Catalogues (column), IF Hosted Catalogue OR Punch Out L1 OR Punch Out L2 is checked. =IF(OR([Hosted Catalogue]@row = 1; [Punch Out L1]@row = 1; [Punch Out L2]@row = 1); 1; 0) --> convert into column…
