-
If formula with greater/less than
This is probably a fairly basic question, but I'm having trouble creating a formula saying "IF the value of specific column is less than 45 then make column say YES, and NO if greater than 45"
-
Status formula pulling from 2 columns and using multiple conditions
Hello, I am trying to write a formula that pulls from two columns: Progress and Done? Progress is a drop down column with these options: Not started, In progress, Scheduled, Declined. Done? is a checkbox. When Done? is checked, then the formula should return Complete. When Done? is unchecked and Progress is Not started,…
-
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…
