-
Auto number
I have a spreadsheet where i keep track of all the samples that we've sent for laboratory testing. They all have a despatch date and the lab that they are being sent to. Is it possible to set up the Auto-number system to generate only one number for all the rows with the same lab and date? The goal for this is to create…
-
Automate Duration Column in Gantt Chart
I'm trying to Great a semi automated Gantt which sets an automatic duration of a task based on Hours, Variance and allotted staff. When task dependencies are on i appear to not be able to write a Formula into this cell. is there a way around this aside from manually doing the maths on the hours every time?
-
Vlookup using Dates
Hello, I'm having some issues around a simple vlookup using dates. I have include screenshots to assist. My formula looks as follows and I am getting a "invalid data type" error. =VLOOKUP([Batch Helper]1, {Site Disposition - database (MASTER) Range 2}, {Site Disposition - database MASTER Range 1}, false) I am trying to do…
-
Smartsheet moving rows
Hello everyone, Bit of a strange one. I have a master list of parent rows each having several children rows. For some reason the order of children rows is changing. I have checked the activity log and no one is editing it and there is no conditional formatting so I have no idea why it is happening. If anyone has any help…
-
Formula needed
Hey Please see attachment. I need help with counting the number of cells in a column, (see attachment: Column [Response Sufficient?]) that contains an exclamation mark(hold) or is blank. I basically want to count the amount of RFIs with an exclamation mark or blank cell in the [Response Sufficient?] column. I have used the…
-
Percentage increasing by 100
Hi all, I have an issue where, when inputting a percentage into the %Complete column which accompanies the Gantt, it multiplies this percentage by 100! I.e. it turns 1 into 100% and 100 into 10,000% - screwing with the sheet. The strange thing is, this is only happening for one of my team. When i do it, in the exact same…
-
changing email address in contact list (web formular)
Hi everybody, I use a contact list in a web formular. Unfortunately, it is not possible to write a new email address into the drop down list which is not yet included in the list. It simply disappears after writing it + Enter. Is there a way to do so? greetings Joerg
-
Getting Oldest Date based on another field
I have created a Metrics Sheet to roll up the oldest date based on another field. I am trying to have it return the oldest date in the "Date Sent to CSOS" column if the Date approved by CSOS column is blank. I can also use the if CSOS Review column is Submitted but I can't get either one to work properly. Does anyone have…
-
Rollup summary of data
This is probably a very simple formula required but I am struggling with it. Can somebody please assist? We have a number of clients on one sheet where we track different trades budget vs. actual for each client. e.g. Plumbing, Electrical, Carpentry etc. We want to count up all the budgets for the Plumbing for all clients…
-
Using a nested HAS formula within a COUNTM?
Hi there! For the life of me I can't figure out this formula! So here is the scenario. I have a grid with a dropdown multi-select column type with different organizational shared service options (e.g. Knowledge Sharing, Project Management, IT, Applied Learning). On a separate grid, I am trying to identify the number of…