-
Form is not populating to Smartsheet - Help!
Hi there, Created a Form and tested successfully last week, data entered into Form after submission populated properly to Smartsheet. This week, 'live', form info when submitted is not (making it to) populating data to Smartsheet. Any idea why this is happening? Thanks!
-
How to search a row for a date among blank values?
I am trying to create a nested IF(ISDATE())... function to pull the date from the columns right of the first column. However, when I try this, after the first IF(ISDATE()) function I am get error message "#UNPARSEABLE." I am unsure of why this is happening. I have tried retyping it multiple times, but am still getting the…
-
Does anyone know why the COUNTIFS function used with a DATE range stops counting things done at 7PM?
I am currently using this function: =COUNTIFS({Closed}, <=DATE(2020, 4, 30), {Closed}, >=DATE(2020, 4, 1)) to calculate the number of projects closed every month. When I compare the number that is calculated to the number of rows in the sheet that it is referenced, it doesn't match because everything that was closed after…
-
SUM(IFERROR(INDEX(COLLECT(MATCH))))
I may have just the brackets wrong or overthinking this but I need to return the SUM of column 'eOEM' when the 'Date of report' column is in the next 7 days AND the 'transaction status' column is "New". The formula I have is =SUM(IFERROR(INDEX(eOEM:eOEM, COLLECT(MATCH("New", [Transaction Status]:[Transaction Status],…
-
What is wrong with my COUNTIF formula?
I am not sure what is wrong with my very simple formula... =COUNTIF(Quarter:Quarter, "Q1") I have a list of 700 line items and am trying to add formula to total up a count of programs 'by quarter' in sheet summary and keep getting #imparseable or #invalid data type (if I add "quotes" outside Q1) I am creating a new field…
-
SUM and DIVISION
Can you check my formula for getting the % for the month It should be add 121-365 Days and Greater than 365 Days DIVIDED by Grand Total
-
Multi Select Dropdown Witih Criteria pulled from Another Smartsheet
Hello! I am attempting to create a Smartsheet form. When a user completes the form they need to identify every account that will be impacted by the project associated with that form. How can we include a multi-select filed in the form, with which all accounts to select from are included in a separate smartsheet list? is it…
-
Trigger Move Automation
I have a automation that is not being triggered, here's the setup: formula to number the time a value appears (1, 2, 3, 4, 5, etc) in the Duplicate column Move Row automation triggered when there are any add/changes and Condition a. Duplicate is one of 2, 3, 4, 5 b. Duplicate is not 1 c. Duplicate is equal to or greater…
-
Creating a COUNTIFS formula to record number of quotes provided by a salesperson in a calendar month
Hello! When using COUNTIF formula in a summary sheet (referencing another sheet) to show number of jobs quoted per salesperson, as follows: =COUNTIF({ASSIGNED TO}, [Primary Column]6) ..... where Primary Column shows the name of the salesperson How would you write a COUNTIFS formula to read the Date Quoted column as well to…
-
Formula to cross reference data and compile into one sheet
Hello, I am needing to take data from one sheet and create a simplified version of it in another sheet. I have tried using MATCH & INDEX and VLookup formulas but none have seemed to work. Details on what I am specifically trying to do are below. Sheet number 1 has raw data in it extracted from a survey, this raw data is…
