-
Flag duplicate titles but not if the title is blank
Hiya, I am trying to write a formula that flags entries if the content of the title column is repeated, but I need it to ignore entries that have a blank title. My current one is: =IF(COUNTIFS([Conference Title]:[Conference Title], [Conference Title]@row > 1, [Conference Title]:[Conference Title], [Conference Title]@row) =…
-
Index Match Function Help
Hi Smartsheet Gurus, I am attempt to pull information from one sheet to another given a set criterion that is present in both. I believe that either a VLOOKUP or INDEX function should suffice but cannot seem to get things to work. A little background: We would like to be able to have employees enter a form with data about…
-
Countifs Error for 3 references
I am trying to get a metrics report for a dashboard for a log with multiple test cycles and multiple data. My metrics are by Status (New, Open, Cancelled, Assigned to Vendor, etc) Each of the Status options has to be filtered by the testing cycle which is either SIT or Deferred to SIT (I know I will have to do the same…
-
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…
-
'Sticky' Fields on Forms
Hello I am using two forms to collect Start Times and End Times, respectively, by activity, by part number, for individual employees. A team will be assigned to the same activity and part number so that some fields will be the same from employee to employee. The number of teams, the number of activities, the number of…
-
Wrike/smartsheet Integration?
One of our departments made a decision to get Wrike last year. They've told me it can integrate with smartsheet- but I haven't found anything that explicitly gives how-to kind of guidance or is it just an API kind of thing where we have to pretty much develop it. I hope to show the team all the great new functionality we…
-
reoccurring weekly task with auto updated due date
Hi, I'd like to set up a reoccurring weekly task. When completed, it would reset the row status from "done" to "ready to work". The due date would auto-advance by one week when the status is reset to "ready to work" NICE TO HAVE: I know from the get- go that some months this task won't occur at all. Can I schedule the task…
-
Verification IF Formula
I am trying to create a verification IF formula that will check two cells and they need to both be true to output "Good" or false "Verify". I making this to find errors more easily in forms they are filling out. We have them putting incorrect packaging for production lines that can't make that product. (Yes I could logic…
-
IF Formula Question
Hi there, I am kind of new to SS formulas and I am trying to create a function that adds an amount to a column IF that column is a certain deal type. The columns that I need the addition to are labeled "Development WAG $" and "Implementation Costs $". IF the "Deal Type" column has "Lease/ Purchase" I need the $350,000 to…
-
Looking to auto populate red flag for overdue invoice
Im having trouble figuring out a formula to create a flag in the overdue column when the due date is in the past and the status is pending or delayed. Flag needs to disapper once status changes to paid Picture for reference
