-
Automatically copy cells from one sheet to another
Trying to use VLookup to automatically copy cell data from one sheet to another. I tried to create a function that searches for "Project Name" and "Comments" columns in a sheet titled "Projects" and copies "Comments" to a sheet titled "Campaigns", where the Project Names are exactly the same in both sheets. Can't quite…
-
Formula to Copy cells if no match?
I'm looking for a way (probably some sort of Index/Match formula?) to check for a customer name on 2 lists. If the name shows up on the second list, but not the first, add it also to the first list. Here is our specific set up: The first list is a workflow tracker where most people will start. The first step in the…
-
Formula for column converting zip code to time zone
I have a column where our form data populates a zip code. I created another column for time zone where I would like the zip code column to populate the time zone column. I've worked on a formula for the time zone column and can't figure out what is not working. Any ideas would be helpful. =IF((((((“97001:97920”,[[Zip /…
-
Splitting form inputs into separate task lines
Hello, I am wondering if smartsheet has the functionality to split a form input into multiple lines. For example, I have a multi-select column with Items A, B, C,. I select A, B, C in the form and submit. Once I submit, is there an automation that turns that form input into multiple separate lines in my project? So it…
-
Flag formula
I'm struggling with the flag formula even after reading these discussions and downloading the formula tools. Goal is to: Flag if status is not “complete” and due date in the past Flag if status is blank and due date is less than or equal to 3 days from today Current formula that works is below. I've tried adding to it…
-
INVALID DATA TYPE Error in single cell of column formula
Hello, I am getting one cell returning the "INVALID DATA TYPE" error in a column formula. I have 159 rows in this sheet, and only one cell has the error, so I am very confused. The formulas is: =COUNTIFS({Site Visits Range 1}, Type@row, {Site Visits Range 3}, [Primary Column]@row, {Site Visits Range 2}, <>"", {Site Visits…
-
Can I get some help on a Date Formula?
Hi SS Community, I'm currently using a preventative maintenance sheet where I have a "Frequency (Months)", "Last Maintenance Date", and "Next Maintenance Date" column. I am looking to utilize the Frequency to determine what the Next Maintenance Date is via a formula. I'm having a bit of trouble as this is slightly…
-
SumIfs with multiple values from same column
I'm attempting to Sum $ based on several statuses in the Status Column, but can't figure out how to use multiple values. I successfully used the below to sum for one status, but need to add 3 more statuses "Pending Mail Merge" , "Awaiting Calculation" and "Payment Received" =SUMIFS([Amount of Bonus Owed to Company…
-
Adding Time to a date column to trigger an auto email notification.
Hello. I am creating a sheet that will help track when components need to be removed from our baking ovens based on its date in. Its a bit more complex then what I have done in the past so I need some help figuring out how I can do this. So the Date In column is a Date type. I have it automated to fill out when a new line…
-
Multiple ifs when looking at child tasks
Hi All I've got this formula which checks if a line has children then if any of them are "RAG" Green it prints a 1. I am using it to create a report with nested line items =IF(COUNT(CHILDREN([Task Name]@row)) > 0, IF(COUNTIFS(DESCENDANTS(RAG@row), "Green") > 0, 1)) I am trying to limit returning "1" only if any of the…