-
Filter a report by users email?
Hi everyone, I have set up each PM in our company to receive an individual report based on who is listed in the "PM" column in engineering sheets filled out by each engineer. The report for each PM combines the multiple sheets. I am concerned after doing a couple tests because smartsheets contact management seems to be…
-
Changing an older cell based on criteria from a newer cell
Hello, Looking for a little assistance with a formula (or workflow), if even at all possible. I have a row of data with a Date, a Room and a Status of “Conditional Pass”. When that same Room gets checked again at a later Date, has a Status of “Pass” and a new row is added, is it possible to change the original Status entry…
-
How can I display the last value from a column into certain cell?
Hi guys, I would like to display the last value from the column "Project Phase" into a cell (in this case I would like to implement it at the first cell of the column " Project Phase". Regarding to the screenshot, this would mean that I would like to have the text "Offer Phase" to be displayed automatically in my cell at…
-
Counting instances in each of the last 6 months on a rolling basis
Hello, I'm trying to count the number of times a type of dispute occurs within a month in the last 6 months in order to monitor trends. I want the months to roll so I don't need to adjust the formulas ever. My formula doesn't take the previous year into account and I'm not sure how to introduce it. This is what my…
-
How to write below formula in smartsheet
Hi . Can anyone help how to write below formula in Smartsheet
-
Moving Columns
Hello, I have a "completed" sheet that is the destination sheet for records that have been, you guessed it, completed. I would like to set up an automation that when rows are moved from that sheet copies certain columns to another sheet. The additional sheet is a template that we would use to upload into another system.…
-
SUMIFS AND Formula Help
Hello, I am attempting to calculate the sum of a PRICE column, if the COLOR column=BLUE AND the FABRIC column=TW100. If I type =SUMIFS(PRICE, FABRIC, Fabric@row, COLOR, Color@row) it calculates the total for ALL rows in sheet including a BLUE color, even if the FABRIC is not TW100. I need a formula which will only…
-
Looking to create an =IF(CONTAINS Function for a formatted Date field
Hello! I'm looking to create an =IF(CONTAINS function to pull the day of the week into a separate column from the formatted date column. For example: I want the "Event Day" column to turn Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, or Sunday depending on what is in the Event Date column. I have created this…
-
formula question
we are using smartsheet to keep track of community park passes. i have a column for name, account #, tag # and pass #. I need to be notified / alerted if an account gets more than one pass. Is there a formula that can check for a duplicate account number when the pass # cell is not blank? In the below picture, I sorted by…
-
Unique Variable for JOIN function
Hi All, I am attempting to use CONTAINS in tandem with JOIN(COLLECT()) to populate courses employees must take based on the care-area in which they work. In the below example, the contents of 14A are also being pulled into 4A since they both contain "4A". Is there a way to search for 4A as an absolute? (Unfortunately, I am…