-
Formula For Subtracting Working Days
Hello all, I am a lab technician that am not currently up to speed on smartsheet functions. Can someone help me in creating a function, in hopes I can reverse engineer to understand it and hopefully not have to ask you all for help next time? I have been meaning to learn more about smartsheet and it's functions, as I see…
-
Make on weekend as working days
I need to make one weekend as working days in my project. I don't want to create a parent task with sub tasks. I want to force the weekend to be a working days. I appreciate your help
-
Count
How do I write a formula to count rows in a dynamic sheet that sheet that keeps growing? How do I reference a column when we don't know where the end will be? Thank you
-
Multiple IF statements
I think I have a simple formula containing multiple IF statements but it is coming back as unparseable. =IF([End Date2]1 = 1, "Sunday", IF([End Date2]1 = 2, "Monday", IF([End Date2]1 = 3, "Tuesday", IF([End Date2]1 = 4, "Wednesday", IF([End Date2]1 = 5, "Thursday", IF ([End Date2]1 = 6, "Friday", IF([End Date2]1 = 7,…
-
Need Help with JOIN COLLECT: Need Help by Tomorrow!
How can I collect data from each column and row? Below you will see each column with an associates name at the top. On the side of the grid you will see the list of dates. I need to pull that data to another grid by needing to know on each date what someone worked. Example on 11/02: I need to know how many hours Angela…
-
Parent function accross sheets
I have a sheet where I am adding some codes, for which I would like to see automatically in the next cell the category for which this code belongs. These categories are established in ANOTHER sheet, i.e., a list of categories with indented rows that contain mentioned codes. Something like this: Sheet 1: "Categories", in…
-
Mutiple If Statements
I have looked through this thread and can't figure out what I am doing wrong... In quiz results, for scoring, I want column 1A to flip the numbers of Column 1. 1=5, 2=4, 3=3, 4=2, 5=1 =IF([1]@row = 1, 5, IF([1]@row = 3, 3), IF([1]@row = 2, 4), IF([1]@row = 4, 2), IF[1]@row = 5, 1) How do I get this to work?
-
COUNTIFS based on two columns without duplicating
Hi all, I have two Contact List columns where we track who is responsible for tasks. I need to count for each row how many times a Contact is entered into EITHER of these columns. I don't want to count it TWICE if either of the columns have one of the values I'm looking for. These are the values I'm looking for in this…
-
Forms - Having Random Issues Submitting
I have a form that my users have been able to complete without any issues for several months. Starting yesterday, I have (2) users that receive errors when submitting, while others can submit without issues. All users are using the same web browser and all are on different networks. The (2) individuals that are having…
-
Finding Duplicate entries across three columns
I am working on our departments budget worksheet that is linked in with our Finance department. I have found that entries are being duplicated and can not figure out why. They have the same time stamp and information. There are 2 columns that I am cross referencing and sometimes 3 to find these duplications. I have tried…