-
Can Requested Data be Compared Against Product Available Data
I have a situation where a form request for products populates a sheet but the products requested may not be available in that market so the request is an invalid one. It would be great if, after form submission, we could compare the new row (request) against a matrix sheet of available products. Has anyone done that…
-
Salesforce Imports Apostrophes
This is a public service announcement... If you have an Index/Match that isn't working, and the source sheet is a data mesh or data shuttle from Salesforce, check the numeric field to make sure there isn't a leading apostrophe. The apostrophe will not appear until you click in the cell. You can rid of it with a helper…
-
How to combine multiple rows of data into one row based off of one cell value.
Hello Smartsheet's community! I am back with another question. I have a database that holds the tracking of employee trainings. The training structure is in tiers and after each completed tier they fill out a form. The raw data from this forms looks like this: Depending on an employee's level they will have a differing…
-
Document the value of function / calculated field every day
Hi all, I have 2 sheets: 1) working sheet where all tickets are logged + their status is maintained 2) calculation sheet with fields showing e.g. number of open / closed tickets and so on (calculated by formulas which refer to the working sheet 1). These values are used for dashboards and so on. I wish to automatically…
-
Find a MAX value in row and return the Column name.
I'm trying to find the max value between all the strength columns and have it return the column name of the max value. I've tried the following formula as suggested by AI and other articles I've found but I keep getting #UNPARSEABLE. =INDEX([Behavioral - Strength]@row:[Respiratory - Strength]@row, MATCH(MAX([Behavioral -…
-
IF-OR-AND Formula for Multiple Scenarios
Help! I need to finalize a formula to return a value of "Yes" if one of two AND statements are true. I am not getting an error with the formula below, but it is not returning a value of Yes or No: =IF(OR(AND([Send to Compliance?]@row = 1, [Finance Approval Status]@row = "Approved", (AND([Send to Compliance?]@row = 0,…
-
Weekly date with manual override
I'm looking to create a formula to have a cell show a date for when our next delivery comes in. Typically these deliveries are every Tuesday, but sometimes they are late by 1 day, or we skip a week because we don't need it. I would like a cell to show the next estimated delivery date example. Today the cell would show:…
-
Formula to Count Children Tasks Only
I am looking for a formula to count Children tasks that meet specific criteria. I want to see how many tasks (Children only) do not have a task owner and a "LM" flag is set. The formula below provides a count for ALL tasks (Parent and Children): =COUNTIFS([Assigned To]:[Assigned To], "", Reporting:Reporting, <> "LM") I can…
-
Using DISTINCT function
I am trying to use the distinct function. It seems like it should be relatively simple, but I am getting an error message. Am I doing something wrong? Thanks
-
Counting Blank Cells
I need assistance on counting all rows that are blank based upon a status column The formula I used is: =COUNTIF({Status Blank}, HAS(@cell, "--")). and I tried using this formula: =COUNTIF({Blank Status}), ISBLANK(@cell)) The "Status Blank" is referencing the other sheet.
