-
Auto Number Formatting
Hello everyone:) I currently have a sheet populated via a web form. There are several people assigned to tasks. My goal is to have an auto number column to populate a prefix & suffix, based off the person assigned & their corresponding ticket number. I don't know if this is even possible. Lets say I'm assigned a task, the…
-
Rond Up
Hey, folks, I am using a sheet to calculate the quarter based on a date field. =ROUND(MONTH([EST Close Dates]1) / 3, 0) However, with no ROUNDUP function, the calculation technically doesn't = the correct values in some cases. For example months Jan - Mar should display 1 however Jan displays 0 February displays 1 and so…
-
SUMIFS with OR and Date range
I am referencing another sheet for this, and this formula currently works... =SUMIFS({SALES Range 1}, {SALES Range 5}, "DK", {SALES Range 2}, "Don Joy", {SALES Range 3}, "paid", {SALES Range 4}, >=DATE(2019, 1, 1)) That being said, I need to embed a logical expression as to include multiple criteria for {SALES Range 2},…
-
Forms
I created a smart sheet that notifies the appropriate lead when someone is requesting access to a project. All the formulas, filters, and alerts are correct. The issue I'm having is when a form is filled out a new row is created the formulas aren’t being placed in the appropriate cells so the notifications for leads would…
-
COUNTIf on the Created (Date) Column
Hello We currently enter data onto a sheet via a webform and I have the system generated created date column added in. I would like calculate the amount of entries from the current day so that I can then use that calculation on a dashboard. I've tried a couple of formulae but nothing is working for me. I would like to…
-
summing totals, referencing multiple sheets
Hello, everyone. I am using Smartsheet to organize our company's sales projections. Each of our product Distributors (9 total) have their own sheet, with case sale projections by Product and Month. I am interested in making a summary sheet, that pulls the case totals from each Distributor sheet, for each Product, again by…
-
SUMIFS criteria for date range (Monthly) #INVALID OPERATION
Hello everyone! I'm trying to make a formula that sums this year sales by month. I have this formula but it returns #INVALID OPERATION, would you mind helping me fix it. much appreciated. =SUMIFS([Valeur TTC]:[Valeur TTC], CO:CO = "UD", Date:Date, IFERROR(MONTH(@cell), 0) = 1, Date:Date, IFERROR(YEAR(@cell), 0) = 2019)
-
Drop down list Formula.
I am having issues developing a formula for a drop-down list/ Assigned to. The goal is when some select one of the departments (attached image). Then in the same row in the Assign To column will populate the right contact for that department. In some departments, there will be multiple contacts and when those contacts are…
-
IF formula
I want "In progress" to display if the check # field is blank or CCC Approved field is Yes, otherwise I want "Complete" to display. I've tried this formula but the syntax is wrong. =IF(ISBLANK([Check #]1), "In Progress", IF([CCC Approved?]1=YES, "In Progress", "Complete"))
-
#Unparseable Error When attempting to use IF function
Hello Everyone, I am trying to write an IF function to automatically change the value of a certain cell for certain conditions. For some reason I keep getting the #Unparseable error when I type out this formula. =IF((NETDAYS([Date Need By] 6, Today())) < 3, [At Risk], [In Progress]) I have attached a screenshot of the…
