-
Help with formula to return month + year from "Date Created" field.
I am trying to create a column formula to return the "Month Year" from a "Date Created" field, with the month fully spelled out. This is what I have so far, but for some reason it is returning the blank value even though the date created field has a value of "03/01/24 11:13 AM." Additionally, I need help figuring out…
-
Checkbox with multiple unique identifier rows
I have a checkbox column that I want to set up a formula for. This formula will reference another sheet for a checkbox, using a unique identifier. If the box is checked in any of the unique identifier rows in the reference sheet, it will return a checked box in the formula sheet. The formula I found is:…
-
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…