-
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!
-
Move row automation with a full destination sheet
Can anyone advise what happens when you have move row automation running but your destination sheet is full? I assume the workflow stops until a new destination sheet is added in the automation logic? Many thanks!
-
UPDATE: Answered.Form changing a number entry to a % in the Sheet
ANSWERED - Found it from another post where RossL told someone to make sure the % sign wasn't selected for that column. Magic solution. Thanks RossL. I have a form with a question asking "What % of time will be allocated to this project?" When the answer to that question is populated in the sheet, it's coming through as a…
-
Find duplicates based on multiple criteria
Hello everyone, I need some help with correct formula to find out duplicates. Is there a way to find duplicate records if case number, client's name, from date, and to date are the same? The first and last records are duplicate but how do I set up a correct formula? I currently only have case number and name columns in my…
-
Time function
I need to record hours in HH:MM in one of the columns of my sheet is there a time format or formula I can use so that entry format is HH:MM . I will not be tracking time in and time out, just the total time worked, for instance, if John Doe worked 7hrs and 20mins, I want to be able to enter 07:20, is this possible?
-
Sumif across sheets using criteria
=SUMIFS({New product Load sku}, {New Product- Prime Tab}, [Primary Column]@row, {New Load- Stage}, OR(@cell <> "Ops Team Reviewing", @cell <> "Working", @cell <> "Assign to Data Team", @cell <> "Data Team Rejected", @cell <> "Ops Team Missing Info Request Sent", @cell <> "DT Reviewed - Ready To Assign", @cell <> "With PM",…