-
SUMIFS with sheet references.
Hello, I've got this formula working like this. =SUMIFS({DayCount}, {EmployeeName}, [Employee Name]@row, {ReasonforAbs}, "Vacation") However when I change the criteria to "PPL / Sick" it's returning 0 when there are clearly cells to count. =SUMIFS({DayCount}, {EmployeeName}, [Employee Name]@row, {ReasonforAbs}, "PPL /…
-
Last 7 Days Formula
I am trying to calculate how many IT tickets have been moved to the status of "completed" within the last 7 days. The formula returns a value of 6 but when I use the filters on the report, it returns the correct value of 2. Can someone help me with the formula so it returns the correct value of 2? The formula I have is:…
-
Forecasting Data for Event Revenue
Hello, I'm looking for a way to project future event revenue projections in a dashboard. If I had revenue from Q4 and Q1, is there a formula to forecast Q2 data similar to excel? What formulas have you used before? Thanks!
-
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