-
Count number of events this WTD, MTD, QTD and YTD
Hi, I'm looking for a formula that I could use to count number of events that were reported in the current week, month quarter and year to date. The reported date is autopopulated in a standard date format and the count will be in the Sheet Summary. thank you for all your suggestions
-
How can I use smartsheet in order to keep track of clock ins and clock outs?
I have a staff of about 150-160 on any given day and currently they punch on the clock and then write their time down on a sheet next to the clock. Is there a way I can use smartsheet to do this? Keep in mind one person should have a total of four punches for the day being 'in,out,in and out again' I'd like to record this…
-
Getting values in one row from another sheet where they are in multiple rows
Hi, I have a master data where country wise and department wise email ids are there in separate rows. I n my separate sheet, I need to pick email ids in one row where let's say Country is AU and Department is IT. I have tried to use Index collect formula but that doesn't work as in my master data email ids are in separate…
-
How often can an IF function be boxed/nested?
Hi there, How often can an IF function be boxed/nested? I know that once (decades ago) in Excel an IF could be boxed 6 times, ... now I googled and learned that Excel can do this up to 64 times. But how about Smartsheet? I was trying to look it up but couldn't find it. Maybe someone knows that right away. Thanks already in…
-
Formaula
Hi Brain Trust :-) Cant get my formula to work - basically want it complete + Gree, In Progress = Blue ... ect BUT if my Admin column is checked I want it to be blank cant figure out what I have done wrong :-O =IF(Admin@row = 1, "Blank", IF(Status@row = "Complete", "Green", IF(Status@row = "In Progress", "Blue",…
-
Reference 2 columns in another sheet and total up a 3rd column
I need to look for keywords in specific columns of another sheet (Assets Needed & Year), and if those parameters are found, take the value in the 3rd column (Actual Effort) and add them up. I can get it to calculate if I have 1 parameter, but when I add the 2nd I get an #INCORRECT ARGUMENT SET message. Here's the formula…
-
Site Visits
Hi Everyone, From my point of view this is very complicated to work out so i will try and simplify it as small as possible. People visit site locations on a monthly basis. I want to show on a smartsheet dashboard what sites need to be visited when there is only 1 visit on the site and that date is about to run out of the…
-
Running a report - Keeping old data to compare
Hi Team, I want to set up a report that will allow me to pull values from a column at a certain date/time, then within that same report, for that same column, pull the values a later date/time so i can compare changes. Is this doable? When i create report and link it up to the columns i want, it is all live. So if someone…
-
In need of formula to add multiple durations together from one sheet into one cell on another sheet
I have a list of hundreds (thousands) of rows of data, most of which have one duration per unique identifier, but on occasion, there are multiple durations (usually never more than 6) for the same identifier. I need a formula which will compare the identifier on Sheet A to the identifiers on Sheet B and either: If only one…
-
Contact List not Populating
Hello, I have created a form with a couple of fields that have the Field Type set to contact list, but when testing the form nothing populates in the field, it's as if it was set to text / number. Is there a way to have it auto populate as a user begins to type a name? Thank you.