-
Find First Duplicate in a Sheet
I am trying to find the first duplicate value with the purpose of using that to highlight another cell; however, my attempts at the first part of the process have resulted in both #UNPARSEABLE and #INVALID COLUMN VALUE. The formula I'm trying to use mimics something I've used successfully in Excel: =COUNTIF($[Master…
-
Formula for Adding Sums based on Matching
Hello. I created an example for what I am needing help with. I need a formula that sums a column if the value at the row matches a field in another sheet with my current sheet. In my example, sheet 2 is where the formula will live - I need the grand transaction total for each clothing amount so in this example, the formula…
-
Results shows #UNPARSEABLE
Hello! I recently came across a very helpful answer from here: https://community.smartsheet.com/discussion/99468/if-a-value-in-a-cell-equals-the-same-value-in-a-column-from-another-sheet I have applied the formula to my sheet, but it was returning UNPARSEABLE. I tried another column and it works fine. Below is the value…
-
Weighted Average Summary in Reports
It would be extremely useful to be able to summarize columns by weighted average in a report. Currently only a general average is available which can skew metrics that deal with percentages. Maybe even provide the capability to input custom formulas for certain cells or columns?
-
Matching Comma-Separated Values in a Cell Using Smartsheet Formulas
Hello Smartsheet community, I have a consolidated tracking sheet that captures details like vendor names, contract numbers, invoice numbers, warrant numbers, and vendor numbers. In my current setup, if a vendor has multiple contract numbers, they are all contained within a single cell separated by commas. This pattern…
-
Index/Match across 3 sheets resulting in #invalid value
Hi all, I have lots of experience with Index/Match in Excel and Smartsheet and this one has stumped me and I can't figure out why. Here's the scoop: I have 1 sheet (Sheet 1) where I import an xlsx document with a bunch of entries (with a PO Number, among other things); Sheet 1 would be my INDEX range for each of the…
-
Column to indicate whether predecessor tasks are complete
I'm looking for a way to add a set of formulas on a sheet that can work together to produce a checkbox showing whether a task's predecessors have been completed. Based on another post I saw, I have gotten to the point of having a column that identifies a row's successors, but can't figure out the formula for the next…
-
Getting #UNPARSEABLE and Need Help
Hello Community, I am struggling to figure out why I keep getting #UNPARSEABLE on the below formula. I am trying to add an IF statement for when [CIT PPO #]@row is blank, the result is "Non Compliant". Any help is appreciated! Broken formula: =IFERROR(IF([Job Complete]@row = "", "Non Compliant", IF([CIT PPO #]@row "", "Non…
-
10 digit fixed numeric field
Hi, I have few fields where I want to add a validation/control user to force doing the correct entry - e.g. PO# shouldn't be more or less than 10 digits. Is it possible? They do these entries via Form. I see their are new validations numeric/text etc...they don't help what I need. Also, Can we trigger any flash alert for…
-
Is it possible to hide dates in a project plan and display week 1, week 2, etc.?
I'm setting up a project where the start date is still to be determined. I have been asked to provide a column that has the week a certain activity needs to occur in. For example, instead of kicking off the project on 25/09/2023 the Grid View of the project plan should have a column in it that shows the project kicking off…
