-
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…
-
Card View - Data Entry (Logic & Formulas do not show up)
I went through a lot of trouble to program my Smartsheet with formulas and logic to make sure the data entry was sound. Only to discover that when someone enters data via the card view, things to not do what they do in grid view. I have many columns to populate and the entire point was to make it easy and smart. Does…
-
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?
-
Calculating Time Between Two Different Dates
I am having some difficulty finding the optimal solution to a problem I am having with Smartsheet. Right now, I have a large sheet which has time on one axis (column A is every date between 1/1/2018 to 1/1/2019). For example, for rows 1/1/2018 - 1/3/18, there is a starting time on 1/1/2018 (example, 8:00:00), and then an…
-
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…
-
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",…
-
Importing Google Finance Data into Smartsheet?
Hi all, I'm attempting to pull Google Finance Data for monitoring stock price movements and creating charts for projected outcomes, etc. I'm not sure if Google Finance data is natively supported or not. I did attempt to import an existing Google Sheets spreadsheet with some formulas in it but receive an "#UNPARSEABLE"…
-
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.…
-
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…
-
Multiple If Statements
I have found quite a bit of useful information to make Nested If statements; however, they are set-up to be "if this, then that or if this, then that". What I need is: "If this is equal to this, and this is equal to this, then this" Here is what I have come up with: =IF(AND(Firm2 = {Building Code}, Firm = {Firm},),…