-
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…
-
Calculating SLA based on time/hour formula
Hi @Paul Newcome I thought I would write a new thread and @ your name on this post. Hope thats ok. Taking this from Formulas for Calculating Time thread. --------------------------------------------------------------------------------------------------- @Paul Newcome What a thread! Came across this when I was looking for a…
-
Check for Duplicates and Blanks
I want to check a column for duplicate entries, but if the field is blank, I want it to be ignored. So far, here's what I have. It works for checking duplicates, but if it's blank it still sets it's value to 1 (because there are multiple blank rows). I'm using this for an automation script in a column formula to have all…