-
Trying to check a box using OR
I want a box to be checked IF Sales Status is "Verbal Agreement" or "Deployment Prep Call - Scheduling" or "Deployment Prep Call - Scheduled" =IF([Sales Status]@row = OR("Verbal Agreement", "Deployment Prep Call - Scheduling", "Deployment Prep Call - Scheduled", 1)) I'm getting the error INCORRECT ARGUMENT SET. Thanks for…
-
Trello Integration
Does Smartsheet have plans to integrate with Trello?
-
Cell Linking / Autopopulate
Can I use cell linking to auto-populate the data from my main sheet to a second sheet? As I enter new accounts in my main sheet, I would like specific columns to auto-populate in the second sheet. Is cell linking the best option to perform this task?
-
Why am I getting an INVALID DATA TYPE error?
Here is my formula, which references another sheet. All referenced columns are the same type (drop-down) =COUNTIFS({Lead Category}, OR(@cell = "Lite Upgrade", "@cell =New Lite Site"), {Sales Type}, "New Deployment", {Sales Tier}, "Experiencia") Thanks for your help!
-
SOLVED Invalid Value with COUNTIFS Formula
SOLVED: there were a few invalid values in there causing the counts to not work properly. Lesson learned Hi, I have a COUNTIFS formula that works just fine with my Contact Column data but is not working with a text column; it gives the Invalid Value error. This is the COUNTIFS formula =COUNTIFS([Account Director]:[Account…
-
Latest Modified Date/Modified by Formula
Hello I need help on a formula tracking when a particular person has modified a sheet. I have 25 project plans that I am admin for. I need to find out when the last time the project manager updated their plan. I have the following formulas running against the Modified and Modified By column. However, I need to update the…
-
Pull a value from a cell if date of the row matches today's date
Hello, I am trying to do something that is likely very simple for someone, but I keep hitting an #UNPARTSEABLE error! In Sheet Summary, I am trying to pull a value from a cell if the date of the row matches today's date; else key "Not Available". Here is the formula I am using: =IF([Date]:[Date]@row = TODAY(), [Overall…
-
Please help correct my formula - copy/paste results in carriage return and quotes around text
Here is my formula: =[Client Name (Avi)]@row + "-" + LEFT([Request Category]@row, 1) + "-" + MID(Created@row, 7, 2) + "-" + [Request ID]@row + "- " + JOIN([Services Requested - Utility]@row + [Services Requested - Waste]@row + JOIN(" -P")) When I copy/paste the cell (or export to Excel), the text looks like this (two rows,…
-
Struggling with formula that references status in another sheet
Hello Smartsheet friends! I have a sheet (called Test Receiver Sheet) where I want a box to be checked for each row if the client code for that row matches client code on the second sheet (called TEST Client Audit Form) AND the status is "Complete". This is the formula I have so far. Im getting an invalid reference error.…
-
Populate contact cell with multiple email addresses for alerts?
I have investigated a few possibilities for this without success. Basically, I have a sheet of facilities with facility info. One of the items is what market that facility is in. So, If I want an alert to go to the entire market, I need to collect the email addresses for each facility that is in the market, then my…