-
Combining columns
Hi! I'm trying to use the combined formula, but every time the 1st and 2nd columns are empty, the 3rd column brings the value with a 0 at the beginning. Thank you in advance for your help.
-
SUMIFS with Multiple Criteria
I have worked up SUMIFS that sums the Final COS for each of main Account Managers individually and for multiple codes in a contracted column that equate to a loss (this worked out fine): =SUMIFS([Final COS]:[Final COS], [Account Manager]:[Account Manager], "Doe", Contracted:Contracted, "not won") + SUMIFS([Final…
-
Validate an email address in a contact list
Hello, We have a situation where we have two employees with the same name, "Test User", and they have the following email addresses: test.user@smartsheet.com test.user2@smartsheet.com (Please notice the "2" in this email.) We use a form to populate our sheet and the form user is required to type(paste) the email address…
-
Triggering an Alert When Data in a Cell Changes
Is there a way to trigger an automation in Smartsheet when data in a cell has been changed from one thing to another after rows are added to a sheet? I keep trying to set up an automation to trigger a reminder (see below) but there doesn't seem to be a condition that matches what I need. I need SS to send me an email when…
-
Removing rows based on a value
I've created an onboarding training template for new hires at my company using the following (https://app.smartsheet.com/b/publish?EQBCT=2a335ca126274786adde88923187b3ca). I've removed some of the original reporting features and added our own. I need to create a version of this that can automatically remove, and re-number…
-
Automating Sheet Summary
Hi there, I'm extremely new to SS. I'm trying to automate our Sheet Summary on our timelines. I would like to automate the Project Health to look something like this. RED = 7 days before due date and less than 75% complete YELLOW = 30 days before due date and <50% complete, AND 14 days before due date and <75% complete…
-
SUM and TODAY() function
Hello, I am building a formula to give me the SUM of the # of spots for dates called within the last 14 days. I was able to build a formula using the TODAY function: =SUMIF({# of Spots}, <TODAY(), AND({Date Calleds}, <TODAY())) However this formula returns a #INVALID DATA TYPE error. I added a number to the TODAY function,…
-
Automation - Update Requests
Hi - I submitted this as a question a while back, and thought it resolved itself, but the problem is still persisting. I have an automated workflow setup whereby when someone submits a Form, they receive an Update Request. The Problem The Update Requests are being sent out, according to SS, but people are not receiving…
-
I would like to sum a column of numbers with only visible rows.
I have the following formula in Excel that works. (See below) =SUBTOTAL(9,J2:J119) How do I write this in Smartsheets? Regards, ds
-
Combined Formulars
I was planning to have this Formular incorporated in our sheets, however I can’t find a way to accomplish this: The basic Formular is used to set a cell to either "1" or "0": IF(AND([Contract Date]7 - TODAY() <= 2, NOT(Status7 = "N/A"), NOT(Status7 = "Not Scheduled"), NOT(Status7 = "Completed")), 1, 0) But, Since “Contract…