-
Can you move entire rows based on colour?
For example, I have a sheet that contains multiple tasks. Once the task is completed the row containing the tasks information will change to green. I would like to then move all green rows into another sheet to produce a sheet of completed tasks. As tasks are added and completed each day, I am looking for this to be an…
-
user-approval matrix reference
I have a form for users to submit documents for approval and gets loaded into sheet A where the approval automation is set-up. The approver column in sheet A is linked to a user-approver matrix that is managed on another sheet B, such that when user submits form and sheet A is updated with a new row, sheet A will reference…
-
Flag if date range across weekend
Dear Smartsheet, first, great product and I have been able to learn alot on this forum....however I am a little stuck with a function/formula. I have a list of tests which is dynamic and changes frequently due to predecessors. I would like to be able to Flag column "Weekend Run" if the test date range occurs over a weekend…
-
Formulas & Filter Assistance for a To Do List
Hi, I have tried a few searches and haven't quite found what I need to perform the function within my smartsheet. Hoping some of the Formula wizards can help me out. I am using Smartsheet to manage my to do list. The filters are great but only make allowances for 1 or ALL conditions, I require 2. I am wanting to create a…
-
Finding the minimum value in non blank cells
I'm creating a dashboard out of the project timelines and I need to extract the task with the earliest date where the % completion is not 100%. =INDEX({ATL BP Material Handling Automation Task Name}, MATCH(MIN(COLLECT({ATL BP Material Handling Automation Actual Start}, {ATL BP Material Handling Automation % Complete},…
-
multi level IF formula
I am trying to formulate a cell to look at who is the Assembler and then return a corresponding Factory Team Name based on a group of names - auto populating the Team name. Something like: IF Assembler@row = Ayesha, Connor, Al, Loretta, John and Martin then cell Factory Team Name@row = Factory Team 1, IF Assembler@row =…
-
If-then-else
trying to get a formula for a risk register. Tried the below but cant get it to work =IF({Risk Rating}@row<= 6,= "No significant impact") or =IF(Risk Rating @row<= 6, "No significant impact") once I get this right, I can add the other ifs.
-
IF/AND cross-sheet formulas
Hi there, I'm getting error messages with my formulas and was hoping someone could help. I'm trying to create a formula with the logic below: IF [Lot Number]@row in my target sheet = Lot Number in the my inventory form AND [Status] in inventory is "Approved" THEN check a box in my target sheet. Whenever I try to reference…
-
Automation
I am maintaining a tracker with training for the whole year for our team. I was planning on using the workflow to notify employees of an upcoming course. I have the email address in a column but I am unable to select email notification. Can someone please let me know how do I fix this? Thanks in advance.
-
Formula for weighting tasks on a scale of 1-5
I have a sheet that is a master list of all of my ongoing and upcoming projects. I have a multi-select column that has a list of tags for product type. I would like to have a column that looks at the product types and assigns a number to indicate complexity. For example: Product Type 1 = 1 (simple) Product Type 2 = 2…
