-
Display text in a countif formula
I have a project type column and I want to show in the summary row at the top of my sheet the number of PoCs and Pilots. Instead of just displaying the number, I want the cell to read PoCs = 22 or Pilots = 15 =(COUNTIF([Project Type]3:[Project Type]69, ="PoC"))
-
IF Formula with Children
Hi everyone, I am new to Smartsheet so apologies if this has been answered elsewhere. I am trying to change RYG balls for a parent row based on children rows being marked done or not. I've used this formula which seems to work, but it gets tedious when there are several Child rows to include or if I want to add another…
-
I would like a formula to tell me the number of days holiday taken this month
I have searched for a formula to calculate the number of days holiday, but I would like it to be more specific to tell me the number of days taken this month. So far I have this: =SUMIFS(Duration:Duration, Absence:Absence, "holiday", Assigned:Assigned, "Fred") which tells me the number of days holiday, total. But I need to…
-
Can i have the AVG(collect) formula in the same column as the range that I want to Average?
I want to average the % complete column. I am writing the formula i the top row of this column and it doesn't allow me to do it. also, doesn't allow me to select any column from the same sheet. Am I missing something here? How can I solve this?
-
Calculation of monthly duration
Hi All, I've been trying to find a formula to automatically calculate duration in months from start date and end date. I went through several threads here but none of them seems to fit at all. Could any of you advise? I presume it is something in terms of =[End Date]@row - [Start Date]@row, unfortunately this shows me…
-
Using the v-look up function
Hello, I am trying to use this formula, =VLOOKUP([Facility ID]1, {Data Control Range 1}, 3, false) and it continues to come up no match or incorrect argument set, is there anyone able to help figure out whats going on here?
-
COUNTIFS Less than Today on a referenced sheet = INVALID OPERATION
I'm referencing another sheet and want to count rows belonging to a particular individual where the planned date is in the past. I'm trying to COUNTIF Owner@row and Planned date is less than TODAY() Here is my formula but I'm getting an INVALID OPERATION error. =COUNTIFS({520.07db Qualified Testing Facility Databa Range…
-
Formula on checkboxes
Hello all, I am trying to find a formula that will show me progress based on 3 or more columns that are checkboxes. I want to show progress if one of them is checked, I want this new column where the formula will be to say not started if all are not checked and completed if all are checked. Can this be done? I tried to…
-
How to work around this Cirular Reference Error?
Hi everyone! I am working on an Inventory sheet for my business and it is not allowing me to do what I need, IE(CircularReference Error). I have a [Starting Inventory] set at 20 in my 'Master Inventory' Sheet. Then I have 2 Forms that are filling in the [Inventory IN] and [Inventory OUT] as my team re-stocks and takes off…
-
COUNTIFS with Parents/Childrens AND/OR and multiple columns
Hello, I have spent HOURS on this and help. This for "Invoice/Sheet Received" Parent column with drop downs. I am combing the Parent code AND child codes so can click+drag it down my sheet. I want to keep this. So the first part of this is for the Parent, the 2nd is in relation to the child. I keep getting Errors on my…