-
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…
-
Past Due Formula via Date Column in references source sheet
Hello, I have the below formula to show total count of projects that are less than or equal to today days and the due date. =COUNTIFS({Estimator}, [Assigned To]@row, {Assigned To}, [Assigned To]@row, {Quote Due Date}, <=TODAY(), {Quote Sent Date}, "") How can this be tweak to show, Total Count Projects Past Their Due Date?…
-
How to use a COUNTIFS formula that excludes multiple criterion in Multi-Select Dropdown column?
I'm trying to count the total number of values in a Multi-Select Dropdown column when criteria in another Multi-Select Dropdown column is not present. For example, let's say I have a FRUIT column with Apple, Orange, Banana, and Kiwi values. I also have a STATUS column with Rotten, Fresh, Stolen, and Eaten values. In rows…
-
Return a cell when one column matches another within an IF statement.
Morning, I've been struggling with how to return a specific value from two columns. We have created a risk register, and we want to show the overall risk rating for the project. The Overall risk is simply the risk of the highest ranked risk regardless of count. Initially, we are just using an IF statement, with a HAS on…
-
Sumif by year and month
i am trying to sum my values that are registered in a selected year and month without doing a start and finish date. is there a way of doing it just based on year selected in a drop down and a preset month?
