-
Trigger "Yes, No, Hold" on item returned.
Hello, I'm still learning SS formulas, and could use some help on what is probably a very "Smartsheet 101" situation. I have a "Item Returned" column that contains a date the item was returned, I would like the yes or no flag to come up on the next column to visually signal if it was returned. I figure a formula like…
-
COUNTING @ ROW LEVEL
Hello, I'm looking for a formula/solution that would count all the correct answers at a row level. If the answer is wrong then it wouldn't count it. Any suggestions? Maybe Conditional Formatting to denote wrong/right answers. Ive tried multiple formulas. I'm stuck. Please let me know if you have any additional questions!…
-
Project Plan - RACI Formula Automation
I have a Project Plan template that will be customized for each client each time it is saved as new. At the top we've included a Stakeholder list (Exec Sponsor, PMO Project Lead, Program Lead, & SDC). I'd like to automate the RACI columns in my Project Plan to correlate with the stakeholder list. The roles themselves…
-
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…