-
Return a single text value if either option A or option B from drop down list is selected
Hi there! Looking for help with a formula that will be able to return a single text value "Not Applicable" in Column 2 if either Option A or Option B is selected from a drop down list in Column 1? I think I'll need to use the IF and CONTAINS function but not sure how I might be able to join these two together? Thanks in…
-
Need Help with Approaching Due Date Formula
I have an Approaching Due Date column with the Star checkbox and I want to create a formula that will show the Star if today is between 7 working days in advance of the End Date and the End Date, and the Status is NOT Complete. I also have a column for Past Due with a Red Flag checkbox. I want the Approaching Due Date…
-
COUNTIF's Formula Multiselect dropdown + Status
I'm trying to create a sheet summary for the number of items with a status of work in progress under each person. Team Member Assigned To is a multiselect option with several names listed. When I use the formula below, I get a return of 0. =COUNTIFS([Assigned To]:[Assigned To], CONTAINS("NAME", @cell), STATUS:STATUS, "In…
-
Alert or update if a column value is changed based on the column(primary column)
Example - I've columns warehouse and route . I need to setup a notification or alert if the route had changed for a particular warehouse. In this example , I need to send notification or alert for Test and PR103 as the previous values of route has changed for them. can someone guide me as to how to do this?
-
Calculating days between dates, 'unless'...
Hi folks, I have a date column for 'Suggested Risk Assessment Review', and a date column for 'Planned Review Date'. I need a formula to count the days between these (i.e. how overdue are they), UNLESS the 'done' checkbox is ticked. How do I calculate this? Thanks!
-
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…
