-
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…
-
CountIF Formula for Dates in the Past
I am trying to amend a current formula I am using to track enrollment. Currently, I have this formula: =COUNTIF([Date of Injection]1:[Date of Injection]100, ISDATE(@cell)) which counts the amount of cells that have a date so my team can track how many animals we have enrolled in a certain project. I want to change this to…
-
Formula to calculate working hours
Hello Team , Please see attached photo above Im looking for away to count my employees daily working hours (in working hrs col) The Col names ( Shift Start and Shift End) are select down menu for 24/hrs (hrs and minutes separated with colons) I Need a formula for column (Working/hrs) that count the number of employee's…
-
SUM IF with OR Criteria throwing Invalid Operation error-what are we missing?
I am trying to count a number meeting hours for each leader, but only meetings they lead or are mandatory to attend. I have been trying to get this to work for those 2 types of 'status' and I must missing a nuance somewhere. Thanks! =SUMIFS([Current Hours Per Month]:[Current Hours Per Month], Leader:Leader, "JG",…
-
Formula for projects completed by month
Im looking for a total # of projects that are completed by Month and year
-
Fast status updates based on parent cell
I would like to make our status updates faster by utilizing the parent/child cell(s). If the user changes the status in the parent cell (dark grey line) to "Completed" then the child and grandchild cells would change to completed. If the user marks the child cell as one of the following statuses then the grandchild rows…
-
Formulas with multiple inputs in smartsheets. Help needed!!
This has been a challenge for me to figure out using the smartsheet platform. I am developing what is essentially a big calculator. The formula that I am trying to implement is: [($26,000 * DTH) + (Risk R * Repair Cost) + (Risk A * repair cost)] * frequency). In this database, each row represents an additional input. The…
-
Trying to lookup most recent
Hi New to smartsheet So my goal is to lookup only a value from the most recent row in another sheet and preform a calculation Example. What I am trying to build is a countdown to Preventive maintenance for some of my fleet vehicles as entered on forms The idea is when row 1 on this sheet is updated (oil change preformed)…
