-
Automatically Copy Column Entries into Another Sheet
I have two separate audit sheets, and wish to combine certain columns into one summary sheet. To be more specific, I only want the PO number and overall pass fail from each large data sheet to be automatically copied into a 3rd sheet so I can compare results of the PO number's 2 test results. In theory, the resulting…
-
COUNTIF and Today Formula - How to get this right?
We would like to count how many cases fall within the previous 8 days not including today. We currently have the formula setup as =COUNTIF({Range}, this is counting the current day all the way back to 7 days ago. Please let me know what the appropriate syntax would be. Thank you!
-
Joining cells and adding an IF condition
Hello! I am joining cells by using the + : =[Select 1535 Levante Equipment]@row + [Select 1551 Brescia Equipment]@row + [Select 1552 Brescia Equipment]@row + [Select 6565 Red Road A Equipment]@row + [Select 6565 Red Road B Equipment]@row + [Select 6565 Red Road C Equipment]@row + [Select 6565 Red Road D Equipment]@row +…
-
Date Formula Help!
Hi All, I am trying to find a simple formula that allows me to add months onto a date to get an automated due date. So date completed column plus whatever figure i put in months column ( up to 12 months) and then this to populate in the Due date column.
-
The dreaded #INVALID DATA TYPE error
I created what I thought was a simple nested IF statement, but got hit with an #INVALID DATA TYPE error. Both columns have the Column Type = Text/Number All "State" fields are populated with valid 2 character US state abbreviations. What am I missing? Formula: =IF(OR(State@row, "AL", State@row, "KS", State@row, "MI",…
-
copy text from one cell to another in one sheet
Hi, solution seems to be simple ;-) I want to show text that I choose from a dropdown field in another cell in the same sheet. [column one] [column two] [column three] before choosing [blank] [options 1-5] [options 6-10] after choosing [ =text no. 7 ] [options 1-5] [chosen option 7] what kind of fomula do I have to enter…
-
Time Keep Formula
Hi There Hoping you can help me out with this one. I'm trying to create a Time Keeping Register for my Company. I have created a Unique ID card with a QR code. I have created a spreadsheet for each Project, where they can scan the QR code onto Smartsheets with a date & time stamp. See below Screen Shot. Now comes the hard…
-
Creating a Master Project List and Dashboard
Hello, I would like some help in designing a Master Project List, and a Master Project Executive Summary Dashboard. We have a Roadmap that contains each functional area's main projects/initiatives. Is there a way I can build a formula to have all the information from each road map combined into one Master Roadmap... Which…
-
Reference Number of Contacts In Cell
Greetings Is there a way to reference the number of contacts in a given cell within a formula? For instance, I have a column titled "hours per person", and a column which is a contact list where I enter contacts. I would like to construct a formula for the "total hours worked" which would be the hours per person multiplied…
-
Math formulas across multiple cells
Hello all, Any help on the following issue would be very much appreciated. I have a scoring matrix built in to Smartsheet (See below). I would like to multiply the score of each cell for each criteria (Strategic Init Impact Score, Business Impact, etc.) by the corresponding weight (and divide each by 100) and then add…