-
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…
-
How Can I Connect a string of IF/AND and ISBLANK statements Into a Working Formula?
There is probably a much sexier way to solve this but separately these 3 groups of statements actually work just fine. I just haven't been able to string them together and get Smartsheet to spit out the info for a given input. Would love to employ a shorter, more elegant solution but would be just as happy if someone can…
-
Using the collect function and "Assigned to"
Hi all, I am using the COLLECT function (within a SUM function) to collect all values associated with tasks assigned to a specific person. For example, =SUM(COLLECT({Range of Values I am Collecting}, {Column where I have person assignments}, ="Person's Name")) This isn't working for me... any tips? Thanks!