-
Percentage Command Issue
How do I formulate a percentage in cell "Total Percentage" using division formula based on data from "Total Score" cell? The "Total Score" cell correctly shows a result of 43. What I want to do is divide that number (43) by 50 with the end result of 86% displaying within another cell called "Total Percentage." Total Score…
-
Count number of cells that contain specific text
Hi, I am trying to work out the formula to count the number of cells that contain specific text (eg "FG"). The cells may contain more than the specific text so I want to ensure that any cell with the text is included. Some of the cells may contain text with an extension such as "FGL". If possible, I would like to exclude…
-
Adding running totals
Hi. Sorry, this may seem really simple but I am new to smartsheets. I have 2 columns. 1 - email addresses(email addresses) and another column sick days(number). I want to add all the sick days up as a running total for different peoples emails addresses but for the life of me cannot seem to get the formula right. Can…
-
JOIN Command Issue
Getting a #unparseable error with the following Join command below. I want to combine ten different comment cells and join them under another separate Comment cell. =JOIN([Comments #1]1:[Comments #2]1:[Comments #3]1:[Comments #4]1:[Comments #5]1:[Comments #6]1:[Comments #7]1:[Comments #8]1:[Comments #9]1:[Comments #10]1,…
-
Running workflow with alert & if, then formulas
When a row is added/changed, I need a workflow that kicks off an approval email to only two people. After those two people receive the alert to approve or decline (I only need one response), whichever they choose needs to fill in "approved by" and "approved date" columns in the sheet. How do I set this up correctly?
-
ISBLANK Formula
Hello, I have a formula for a Health/RYG column: =IF([Working Days Remaining]32 < 0, "Red", IF([Working Days Remaining]32 < 2, "Yellow", "Green")) It works well except if Working Days Remaining is blank, I would like the cell to stay blank. I think this is where ISBLANK comes in but I am struggling to use it. Can I get…
-
Formula issue - IF Statement between 2 dates
I have input a formula to calculate a monthly revenue figure for an annual subscription charge (i.e. divide the subscription charge by 12 between the dates 01/10/2018 - 30/09/2019. I used an =IF(AND...) formula however it is only picking up Oct - Dec of every year rather than Oct 2018 - Sept 2019. I can't figure out what…
-
Resource Assignment based on a Vlookup?
I am creating templates for repeatable "projects." I would like to have a column of "Role Assigned" and set up a table (filled in when the template is used) that associates a specific person (Contact) with each role. Then in each row, a Vlookup would be used to automatically fill in the "Assigned To" contact name from the…
-
Auto Assign w/in Marketing Request Tracker
I am trying to figure out how to write a formula to auto assign a task when it meets different criteria. For example, my column is "Type of Request". If it is Creative, then I want to assign Kristi from my contact list. If it is Product, I want to assign John. I have 7 different choices within the Type of Request column…
-
Pulling Email Address from Another Sheet but as a Contact
In Sheet 1, a user enters a course code (e.g., BUS 123) in one column. Smartsheet searches for that code in Sheet 2, finds the corresponding program leader's name and e-mail address, then puts them in two cells in Sheet 1. Now Sheet 1 shows the course code in Column 2, the program leader's name is Column 3, and the email…