-
Inventory Tracker
Hi - I am looking to build an inventory smartsheet, but am having difficulty setting it up. I am not a guru... We want to input all of our inventory by barcodes (auto populating and grouping same-type products) into our main warehouse. From there, we want to scan those barcodes and deduct x amount of inventory to our…
-
Difference between Today & 7 Days Ago
We have a sheet that contains dates in the column headers with a # of widgets in the cells by office. We are wondering if there is a way to create a formula that would always compare the value for Today compared to the value from 7 days ago. I've attached what our sheet looks like to help understand what we're trying to…
-
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",…