-
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…
-
Formula need to separate mixed text from a single column into separate columns
Using the LEFT or RIGHT formula currently as a means to separate the [Sales Rep Info] column. Problem is I can only figure out how to do it by number of characters. I need the formula to separate first and last name into a new column and a second formula to capture the information in the parenthesis. Same for the [Customer…
-
Finding Distinct Values in Two Columns
Hi, I was wondering if it was possible to find the number of distinct values in two columns. In this case I am looking to find if there is an overlap between start and completion dates for a given crew lead. Is there a reason that I am getting 1 as my output here? Is there any other way I can accomplish this?
-
Help using a multiple cell criteria from a source sheet to auto populate a formula sheet
I'm stuck. Really stuck. I've attempted more than 30 formulas. I hope someone can help me. I am using a master HR data file with 1500+ rows (reference/source sheet) to auto-populate a training enrollment roster (formula sheet), only I don't want every person listed on the source sheet added to my formula sheet. I need a…