-
Order value based on price breaks
Hi, I have ~30 products each with four price breaks and I need to determine the value for each order (a single product type is listed per row) based on the ordered quantity and its associated price break. The really clunky method I have used so far is two main nested IF formulas and additional columns:- The first main…
-
Testing a text value
How can a test be run on a text value to see if it matches?
-
exact match formula in Smartsheet
Hi, has anyone had any luck using an exact match formula is Smartsheet? I have two columns that have text in them. I want the 3rd column to tell me if column 1 and 2 are an exact match or not. I know how to do it in excel =Exact(A1:B1) but not sure how to set up in Smartsheet. Also, can you apply a formula to an entire…
-
Can Smartsheet import live stock or historical currency exchange rates?
For expenses sheets it would be very useful to lookup fx rates based on the expense date for calculating local currency to reference currency amounts easily. Thanks
-
Locking a Summary Row
Hello, Is it possible to have a summary row at the top of my sheet that is "locked" sort of. Meaning, when i filter on certain criteria, the summary row will only total that criteria.??
-
Calculating sums using IF statements
I have two columns of data, one is a class of data in text, the other is a numerical value. I would like to calculate a subtotal of the value of the numerical value based on class. Is there an easy way to do this? I can pull a report based on the class, but it would be nice to have a running total of all classes and their…
-
Day of the week formulas
How do I schedule repeating appointments on a specific day of the week; Ex: Every Mon at 10:00 First Tue of the Month at 09:00 I did not see the day of the week variable or formula. Thanks Alan Guggenheim
-
Drop Down Lists
I am new to smart sheets and way behind my fellow community members level. I have a database spreadsheet for tracking new product development. Question: can you incorporate a drop down list into a smartsheet. Appreciate your advice and apologies for the simplicity of the question. Reagrds, Mark Quillinan
-
Multiple projects and hour registration
Hi there, we are new to Smartsheet (testing) and would llike to registrate our EU projects. * - Registration of multiple projects * - Fill in the available budget * - hour registration from employees on these projects (different from budget) * - different hourly rate per project per person * - Tasks and deliverables within…
-
Formula To Ignore Zeros In Averages?
I have columns running left to right with the 12 months listed as the main header of each. I want to have a column on the far right that shows our average month's sales based on each months totals we go. RIght now it is May, but the simple AVG formula also counts June-December sicne they have zeros in them. So, instead of…
