-
COUNTIFS with multiple criteria from multiple columns
Hi all, I have tried various different formulas from various posts on here but still keep getting Unparseable. I am trying to create a formula, linking from another sheet, to find the following criteria: If the row contains ANY of these values: "未着手 Not Started", "進行中 In Progress", "現場確認 Field Review", "保留中（予算）On Hold…
-
Help creating a formula that generates the current fiscal year
The following formula is #UNPARSEABLE. I'm not sure why. Please help. =IF(MONTH(TODAY())>=7, YEAR(TODAY())&"-"&(YEAR(TODAY())+1), (YEAR(TODAY())-1)&"-"&YEAR(TODAY()))
-
Multiple cells locked to single formula in same column
I'm relatively new to Smartsheet and use it as a tertiary tool, so apologies if this is a 'basic' question. What I want is to tweak a formula on one row of a column and have it apply all other rows that reference that cell in the same column so I don't have to copy the tweaked @row + Parent, Children, or Ancestors…
-
How to Join values from a reference sheet based on selections in a multi-select dropdown
Based on preliminary searching, it seems this may be impossible, but I am hoping to use values chosen from a multi-select dropdown to collect and join values associated with each dropdown in a single cell. In this example, a donation manager is choosing donation items from a dropdown with over 40 selections. In the column…
-
Trying to evaluate multiple columns with an IF statement
I keep getting a syntax error for some reason but can't figure out why. I am basically trying to set a status icon of 'Sunny" if the status of the risk is "closed" and if not closed, i am using the other icons based on the level of the risk. here is the formula: =IF([Status]@row = “Closed”, “sunny”, IF([Risk Score]@row <=…
-
Find Number of Duplicates within Multiple Columns
I need to create a COUNTIF formula (I assume) that will count the number of duplicates of a number in at least 10 different columns. I will eventually create a notification for the end result but I can't figure out how to do it over more than one column without only being able to compare the other columns to just one…
-
Pasting formulas from a plain text document causing #Unparseable Error
Hello all, I am building a complex multilingual sheet that will be creating various documents using Document Builder depending on the user's choice of country and language. There are a lot of column formulas that are very similar but use different languages. I am using a text editor to track the formulas but have found I…
-
Sheet Reference Formula Unparseable Error
I'm using the following formula, which references another sheet to pull in definitions/text: =IF([Job Family Recommendation]@row = "Accounting Operations", {Job Family Definitions Range 5}), IF([Job Family Recommendation]@row = "Billing", {Job Family Definitions Range 2}) The first leg of the formula works, but when I add…
-
Help with Unparseable If(And) formula
Please help with reviewing the formula below. I am getting #UNPARSEABLE. =IF(AND([Spend 2022]@row=0,[Spend 2023]@row=0,[Compliance Status]@row<>”Active-NonCompliant”),"Y", "N") If I only do the single IF, it returns the value correctly : =IF([Spend 2022]@row = 0, "Y", "N") [Spend 2022] and [Spend 2023] columns are text…
-
How do you limit items in a dropdown menu field based on the selection of another?
We're building a process where users are limited to a secondary dropdown menu selection after selecting an option from another dropdown field. For example: We have a Job Department field and a Job Type field. If the Job Department dropdown menu includes Accounting, HR, IT, etc., we want the Job Type field to be limited to…
