-
IF formula #Unparseable error
Hello! I have set up the following IF formula that triggers actions based on risk category, but it is returning an #Unparseable error. I would appreciate any help anyone can provide. Thanks! =IF(CATEGORY@row = “Resource”, “Escalate”, “Do not escalate”)
-
Cross sheet formula
I am new to Smartsheet and am struggling with a basic formula. I am simply trying to multiply a value from in a specific cell from one sheet with a value in a specific cell from another sheet. I have been able to get a result by using this formula. =$[2021 WP Year-End Forecast]1 * ({Project Costs - Cost - Labor OT…
-
"At Risk" Status Formula
I have the following formula for setting the parent status. I want the parent status to change to "At Risk" should even just 1 child have an "At Risk" status. I am having a hard time figuring out how to add this criteria to this formula: =IF(COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN(Tasks@row)), "Complete",…
-
Join columns from 1 match
Good evening, I'm looking for some assistance :) I've been trying to find the formula that alows me to join 3 columns value of the same line of the match. This is between 2 smartsheets. I made a quick draw of it. I would appreciate any help :)
-
Formula Question
I'd like to add a formula to my sheet where if it's blank you do nothing, but if it's not blank, i want to include text and also link to other cells. Example: If the course number is blank, then do nothing, but if the course number isn't blank then put "Please charge invoice to" [Account Number]@row, "Org Ref" [Class…
-
Summary Sheet Symbols and Projection Question
Hi, I am trying to do a few things. First, I would like to pull symbols into the Sheet Summary based on the following criteria: Most Recent Entry for Site A. Pull symbol from the "▲ ▼" column. Second, pull the... Most Recent entry for Site A. Pull symbol from the "Status of Goal" column to sheet summary. Lastly, I would…
-
Formula for % Complete - Checked Boxes + Total items listed
Hi, I'm trying to calculate the % Complete on a sheet. The data will be coming from the total number of boxes checked "Complete" and the total number of items on the list (Children). I just keep getting Invalid Operation and Incorrect Argument Set.
-
Simple question, How do I automate my RAG status column based on dates?
This is for contract management circumstances. Green=Contract is active no issues Yellow= Contract is due to expire in 90 days (I have a column with the contract expiration date in it) Red= Contract is expired (Again this would be based on the value in the contract expiration) I checked the Automation and there doesn't…
-
COUNTIFS from one date through today with other criteria
Hello! Needing help creating a formula. The formula has to count all the cells in the "clearance date" column that are blank with the criteria from the "application effective date" which is all dates happening 10.1.2021 through today (which means counting on a rolling basis) I have this formula below that isn't working:…
-
Formula for 2 criteria
Hi, I'm trying to come up with a formula to count all the students in grades K, 1, 2, 3, 4, 5 who are also in our life skills program. I have the formulas separate =COUNTIFS(Grade:Grade, ="K") + COUNTIF(Grade:Grade, <6) =COUNTIF([Life Skills]:[Life Skills], 1) I tried =COUNTIFS(Grade:Grade, ="K") + COUNTIF(Grade:Grade, <6)…
