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…
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([Expect…
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 …
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 a…
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…
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 …
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 …
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 o…
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 BOOLE…
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 comp…