-
Count # of Open issues in another sheet
Trying to count the total number of "open" and "Waiting" issues in a another sheet =COUNTIF({Sheet - RAID Log Range 1} Status:Status, "Open")+COUNTIF (Status:Status, "Waiting") Hitting a wall, getting an error. Anyone have some guidance?
-
IF formula with Condition on dates
Hi there, can anyone help me on this formula ? it looks the only issue could be on the date format but I don't know what I have to change. =IF([Expected Order Date]4 < 3 / 31 / 18, "1Q 18"; IF([Expected Order Date]4 < 6 / 30 / 18, "2Q 18",IF([Expected Order Date]4 > 9 / 30 / 18,"3Q 18","4Q 18",)))) Thanks a lot in…
-
Pre Populated Form Fields
I want to create an order request form with an inventory control sheet I've created. The sheet contains remaining stock on hand of several different items. The drop down list will contain the items I have in stock, but I'd like to have the amount available to show up based on the item selected. This number would be…
-
not able to paste to the column with ID number
hi, I have removed a number of rows from my smartsheet. now I want to paste the data from another sheet but the system would not allow me to paste to the column with the doc ID number which fills in automatically. I would like to keep the original ID numbers therefore I would like to paste them from another sheet. What can…
-
RYG Ball automation based on end date and status
I am trying to automate RYG balls based on both the end date [End Date] and status [Complete]. I am using RYG balls for the [Status] column and Harvey Balls for the [Complete] column. If [end date] is in the past and [Complete] is "full", turn rgy green If [end date] is in the past and [Complete] is either "empty",…
-
VLOOKUP misalignment with column sort
hi, I have found misalignment of the data sort expectations between VLOOKUP function and Smartsheet's Column sort capability. It seems that when Column is being sorted, underscore symbol "_" is being put ahead of the letters, while when VLOOKUP is looking for the cell to match, it does expect "_" to be after the letters.…
-
Copying formula across columns
Hi, I'd like to copy a SUMIF formula across columns, where the only change in each would be to have the formula automatically update to match the new column name. Specifically, it would autmoatically change from the original colum =SUMIF(Personnel:Personnel, "Alison Michel", [Summer 2018 - Aug]:[Summer 2018 - Aug]) to…
-
Auto populate Assigned to based on reference
We have a project plan template and populate the 'assigned to' column with the role/title. Once I copy the new project plan template, how could I automatically update the 'assigned to' by task based on a role/name mapping. Could I have a project resources sheet with role and name and have the Project Plan tasks 'assigned…
-
Help with my formula
I am not the best at formulas and need some help. I cant seem to get my head around building formulas. Anyway can someone help please. I am trying to build a formula that will count all the true BOOLEAN in the children row and when it is greater than 4 return the a true outcome to the parent row. Hoopefully someone can…
-
"If clause" in Dependancies
Hi all, I am struggling to find a solution for this. I have 15 individual sheets for a project. One of the activities on sheet 2 will include a "yes/no" question. If yes, then sheet 3 needs to be completed. If no, then sheet 3 will not be necessary. I can't see an efficient solution for this. Any suggestions? Thanks!
