-
IF AND Function
Dear Smartsheet Wizard, I'm trying to create a function but I'm running into an error. The IF - And function I'm creating basically needs to do the following: If salesperson 1 is = "Yan" then deduct 100 from Profit and his commission should be profit*0.5. Otherwise, deduct 100 from Profit and commission should be…
-
Ability to Create Order Form
I have search through various posts but can't seem to find exactly what I am looking for. I want to replace an excel sheet with smartsheets for demo order requests from the sales team. The existing excel sheet has a drop down of all the options that you can choose from and once you choose an option, it will auto-populate…
-
Return 1 if YEAR and MONTH is equal TODAY
Hi, I have a formula: =IFERROR(IF(MONTH([Sale Date]2) = MONTH(TODAY()), 1, IF(MONTH([Sale Date]2) = MONTH(TODAY()) - 1, 2)), " ") and it worked until we have two years in one sheet. I would like to know how to add YEAR to this formula so that we can compare not only MONTH but also YEAR. Thanks.
-
Datamesh Contact Lists
Hi, We are trying to use datamash to bring over contacts to the target sheet based on locations in a source sheet which does not seem to be working. We have multiple contacts enabled and this works fine with vlookup, but datamesh returns no results. Any Ideas??
-
IF or IF AND Formula conditions DATE
Dear, I appreciate your help. I need to create a formula that changes the status column depending on the following conditions. (The image in the example table has reference TODAY = August 28, 2019) 1) If the Balance column is equal to 0 (Green) 2) If the Balance column is less than 0 (Yellow) 3) If the Balance column is…
-
SUMIF the amount in one column has the correct pipeline status in another column
Can someone please help me with SUMIF, I am losing my mind and keep getting errors. I have a pipeline document with status' ( approved, declined, awaiting client, in progress,etc) and I need to show in a dashboard the sum associated with each item. PIPELINE STATUS | dropdown with status' AMOUNT APPROVED | the dollar…
-
formulas under child rows excluded as auto-number column
I have a master sheet with projects that auto-populate from a form that requestors fill out as needed. I created a column named "Request Number" that is a Auto-Number column type. However, I have in the bottom of the page multiple lines with formulas that I use only for my dashboard and although I have all this formulas as…
-
Black out dates in a form (date type column)
Hello, I have created a form and have a column named "Date Item is Needed" which is a date type column. However, the requestor needs to allow at least 10 days from the actual day. Is there a way to always black out those 10 first days? Thanks!
-
Metric Sheet Calculations for a Dashboard
Evening All, i'm looking to see how I can add to this formula a rule to not include sales variances of 100%. This shows when I am comparing year over year sales and the site does not have those figures to compare. =IFERROR(AVG({Sales Variance}), "") Many thanks, Sarah
-
Automate RYG Balls based on 3 columns.
Hi, I need help with finding a way to automate the RYG balls so that if no dates are input, it's white. If the first date is input, it's red. If the second date is input, its yellow. And if the final date is input, it's green. Thank you !