-
Need help - adding less than or equal value to a current formula
Hello, Currently I'm struggling to add <= value to my current formula code, my idea is to count for Order Numbers (Unique values) and Lines of Order Numbers of certain times. since filter doesn't work in this code, I'd like to add a <= or >= value formula for Ship_Time, so my code filters can automatically generate…
-
cannot edit existing automated workflows
I am trying to edit some existing workflows and when I click the edit button nothing happens I can still create new ones if use the templates but when I click create from scratch nothing happens as well... it was working fine yesterday, any one got the same issue or I am dealing with an isolated case here?
-
Formula for returning a value when multiple criteria are met
I am attempting to write a formula in a sheet to pull in a single value from another sheet when both the Area and yesterday's date match. I have tried this: =IF(AND({Area}, "Offsite", {Date Collected} = TODAY() - 1), {Daily Collection Amount}, "") and this: =IF({Area}, "Offsite", IF({Date Collected} = TODAY() - 1), {Daily…
-
Using IFERROR to reference 2 sheets
Using the formula below to pull references from two sheets. I am getting data returned from the first sheet, but not the second. When I reverse the order of the references the formula works the other way around. Do I have an extra bracket or something causing it not to index past the first sheet? =IFERROR(INDEX({Milestone…
-
I am struggling with my countifs formula
I am trying to use a countifs formula in my sheet summary to compile some information. This is a failure log in our internal product testing. I want to see how many of a specific model have failed due to each of these reasons: Assembly, Materials, Process, or Other reason. So how many Hydra failed due to Assembly, Due to…
-
Has Anyone Integrated Smartsheet with Salesforce
I am wondering because we might venture down the path to integrate Smartsheet with Salesforce. Has anyone done this, and what is the potential cost and time it would take to do so?
-
Percent Completed Calculation
I am new to Smartsheets and looking to do a basic calculation of % completed of a status column. I have multiple steps with task that all need to be completed for the overall project to be considered completed. I want to calculate % completed of each step and to count it completed if status = completed, and if status = not…
-
Get Unique Record Pairings
I have a sheet that tracks the name of sub-contractors with the name of their business, and a column indicating the agency that sub-contractor works with. A single sub-contractor, Joe, from ABC Company, may work with Agency 123 and Agency 789, while Sally from ABC Company may work with Agency 567. What I want to get to is…
-
Conditional Formatting Metrics
I have a sheet with a lot of conditional formatting to identify when training and license dates in my sheet are coming close to expiration or have expired. The sheet has about 15 columns, each for a separate training or licensing completion date, and conditional formatting is looking at those dates to determine when it's…
-
Combining SUM and RIGHT
Hello, How may I find the SUM of multiple columns by using the SUM function and RIGHT function? I am collecting the data via a Smartsheet form and will need to email out the call center representative's score to their managers. I am getting #UNPARSEABLE as the result. Can someone help correct me? A1, Customer…