-
Linking two sheets in a very specific way
Hello all! Like my title says, I am trying to link two smartsheets in a very specific way. I have a process in which I have individuals requesting support for specific courses this is tracked in one sheet. I then have a second process that hires people to provide support for those classes. Where I am running into trouble…
-
sumifs pulling from separate page for last 45 days with additional criteria
I'm trying to pull a total quantity of bad parts that have been made in the last 45 days. I'm looking to break this down by specific part numbers. The formula that I'm currently using is : =SUMIFS({Machine Shop Scrap Data Range 1}, {Machine Shop Scrap Data Range 2}, AND(@cell >= TODAY(-45), @cell <= TODAY()), {Machine Shop…
-
Automate Status Change Between 2 Sheets
I have two sheets, both with Status columns. Ideally, when the status in sheet B changes, I would like the status in sheet A to change. For example, if my tester (sheet B) changes the status to "Test Failed", I would like my Defect Critical status change to "To Be Reviewed" Can this be done through automation or do I need…
-
How to visualize the same timestamp that I see in the grid(sheet) and in dynamics view?
I created a dynamics view but the problems it's that the timestamp that I visualize its a different. I already reviewed the timezone an its set similar in my computer also I review the time format and its the same. Any solution or suggestion?
-
No "reference another sheet" prompt
Hi All, I'm a noob, trying to do a basic vlookup (or match, don't care), but when I start the formula, there is no "Reference another sheet" prompt, as I see in every single help video. I've tried directly typing in the name of the sheet/table, but it's not producing. =VLOOKUP([Contract Name]@row ,{List of…
-
How To Cross Reference Another Sheet and Return a Value if The Summary Column Matches
Hello! The title may be confusing. I am looking for help in correcting a formula. I have two sheets. One is a live sheet that is connected to Jira and imports information about Jira cards. I have an automation set up to copy rows to another sheet (Jira Sprint History) if the is a value in the Sprint column. I'd now like to…
-
Countifs with similar strings
I am a bit stumpped - I am using the following formula to collect data from a multi select column =COUNTIFS({Name}, [Name1]@row, {Unacceptable}, CONTAINS([Answer]@row , @cell )) and for the most part it is fairly straigtforward to count the number of elements in the column but the formula does not work when the string has…
-
Sum for a Coloumn based on Multiple column categories.
I have this meta data sheet that shows all the information from a form being submitted, and im trying to gather sums of specific resources based on their qualifiers into another sheet thats easier to others to read. Example would be I have a resource that has multiple configurations and im trying to separate those out…
-
How to use contains properly?
I am trying to use COUNTIF to check a box. The formula im looking to write would look at my column, "PO #" in sheet 1 and check the "PO" column in a sheet 2 and see if it contains the same number from sheet 1. below is my current formula. I dont get an error but it is not producing the expected result. i have a number of…
-
Auto-Rescheduling Tasks (Based On Tasks Being Dragged)
Please see attached screenshot on just a draft option on what I am playing around with. I want to drag Task 4 to actually be Number 1 priority and for that Task to be completed 1st (however I don't want to use the Dependencies feature as the tasks are NOT linked, they are all separate) and I want the dates to all change…