-
Formula for addition of quantities
Good afternoon, I am attempting to create a formula that adds the sum of multiple quantities. How would I create this formula and assign values to different types of information within this formula?
-
Unparesable Error
Receiving unparseable error when selecting a field in one column and wanting a specific result in another field. This is the formula. What am I missing? =IF([Submit for Approval]1,1[Manager Approval]1 = "Submitted") See attached
-
Formulas
Hello, I am needing help with this formula =IF({Colunm Range 1} >= 10, "Met", "To be Started") (this works but will not be relevant for the whole year.) How can I add in a date? I was this formula to recognise if a range is equal to or great than 10 after the 01/03/19, "Met', "Risk" Also can you AVG Harvey balls at all????…
-
Reference a Report
I am using a form to track time spent on projects. Right now, they select the project from a dropdown list that I manually created and then they type in the task and the hours worked. Ideally, I would like for the Task Name to populate according to those available based on the Project selected. For example, if the user…
-
Symbol Formula
Good morning, I am inquiring about a formula that adds a quantity of certain symbols within a sheet. I would like the total of check marks to be added. Attached is a screenshot of what I have unsuccessfully attempted thus far. Please let me know what changes are needed. Thank you
-
IF Statement Help
Hello All, I am trying to create a smartsheet to optimize a process. Basically what I need is a statement to recognize if a cell has a specific text value (for example CUP). If the cell contains the value, I need the cell, that I am writing the statement into, to display text (for example Andrej). I tried to use the IF…
-
SUMIF value exists, leave blank if cells are blank (nothing to sum)
I'm trying to figure out how to create a formula to sum a column if there are values, but leave the field blank if there are no values in the range. Is that possible? Here's the background: I'm trying to create a status report that shows whether or not someone has actually entered values into the appropriate column. If…
-
Please help with a formula!
I am looking to compare Year to Date numbers, and I'm having a hard time figuring out a formula to do so. I've attached a sample screen shot. At the end of the day, I'm trying to add a metric into a dashboard that shows 2018 vs 2019 year to date. I created the "YTD" column that shows the value of the last column that has…
-
"\" Character in String
Forum Id like to create a formula that mirrors 'Concatenate' from Excel, so Id like 3 items concatenated; 2 sources from 2 columns on my sheet and the third is a manually written in text string with the formula itself: Column A Tet String abc\123 [as an example] Column B I can use "+" or JOIN it seems, but the fact my text…
-
Returning Data with a formula
Boy have I gone round and round with this! This formula is meant to bring back the data from another sheet based on the code entered (ie: code - CALVE and it should return the full name, email of that company from a different sheet). Sometimes this formula works perfect and other times it brings back the wrong company? Can…
