-
Why is a text field only appearing in automation responses as the column title and not row contents?
Hello - newbie to Smartsheet! Have reached a roadblock I hope I can get your help with. I am automating a report sent to a manager after their team member completes a Smartsheet form. The team member is assessing their ability on a scale of 1-4 against various role requirements. Due to form limitations on the number of…
-
Work Breakdown Structure (WBS) - Column Formula Configuration
Hello Everyone, Recently myself and two fellow Smartsheet Sales Engineers, @Lea Gikas and @Dave Stanley got together to create a WBS solution powered by Column Formulas. We wanted to provide the resulting configuration to the community in case some may find it helpful in executing project management solutions, this…
-
IFERROR, INDEX, MATCH, IF(AND( Formula for 5 sheets?
So, this is a doozy. I am trying to create one report that, when one piece of information is entered, pulls the rest of the necessary information from across five other sheets. I have seen a discussion on this forum about doing just that thing, but the difference is, I need to include certain criteria within the search,…
-
Index Match with multiple Parent/Child rows in a sheet.
Hello all, I'm looking for some advice on a tiered IF statement using index/match and CHILDREN formulas. My case: I receive numerical data from another metric sheet that copies it snapshots into this archive once a month. There may be times where we need to edit the historical data. To ensure the % columns are updated I…
-
Google calendar like option or work around?
Hey I have 2 columns that show different dates that I would want to see together in the calendar view. Has anyone figured out a work around for this or a clever formula to make this work? Hypothetically, for example: I would like to see the Packaging Release Date, Photography Shoot Date, and Copy due date.
-
If formula for checkboxes
Hi, I am having trouble with the correct formula sequence for check boxes to stay checked through out the workflow process? I want the check boxes to stay check as it moves along its stages. current formula I am using is: 100% Rec'd column =IF([Workflow Status - BitRip]@row = "Received", 1) Shop Installed column…
-
Dropdown multi-select columns list comparision
I have two columns that are dropdown multi-select. One column includes a list of all possible values (example: letters A-Z) while the second column includes a list of some letters (without duplicates (example: A, B, C). I would like to create a column that displays the missing letters (example: D-Z). How would I go about…
-
OR( ) for multiple criterion ranges within INDEX/COLLECT/SUMIFS
Hello, any tips for using OR for multiple criterion ranges? The formula below outputs #INVALID DATA TYPE. =INDEX(COLLECT({Task Name}, {Details}, <>"", OR({X Budget}, {Y Budget}), <>""), [Expense #]@row) The goal is to only pull tasks into the new sheet that have a value for either budget type (X, Y).
-
Index collect = incorrect argument set
Hi there, I am using index collect and cannot understand why I am getting an error message "incorrect argument set" =INDEX(COLLECT({Rack CMDB}, {Asset Tag}, [Asset tag]@row), 1) Cross sheet references are connected to the same sheet. Column format is Text/Number Many thanks in advance Sam
-
SUMIFS Delivery Date >= Inventory Date
I'm attempting to write a SUMIFS formula where one of the criterion is to compare one date to another. It is returning 0 when it should return 1830. =SUMIFS({PURCHASING QTY EA}, {SHIP TO PLANT}, "HUBER HEIGHTS", {CONDUIT PURCHASING JDE CODE}, "RPVC0412200", {CONDUIT DELIVERY DATE}, >={CONDUIT INVENTORY DATE}, {CONDUIT…