Formulas and Functions
Archives for March 2019
Discussion List

First post 03/31/19,Last post 04/01/19I have this working formula: ="Unit 2G is " + ROUND((COUNTIF([Unit Name]:[Unit Name], "2G") / 14) * 100) + "% Completed" 2G could also be 3G, 4H, and 2H. (Dropdown selection list) I have a checkbox colu…Formulas and Functions142DanielGD

First post 03/29/19,Last post 04/01/19I have a grid where I am trying to lookup from a grid that people can log issues on. The first lookup is the date range, we want to count all issues within that date range. Then we only want to count by the "Field". On the log it…Formulas and Functions469jhank

First post 03/29/19,Last post 04/01/19Hi! I'm trying to create a formula that will count the number of rows that have a "Delivery Date" after 1/1/2019. Any row with a date prior to that should not be counted. I also do not want blank rows counted. In the screen cap…Formulas and Functions18810JAA

First post 03/29/19,Last post 04/04/19Hello! I am trying to make a symbol formula that will become "1" (red flag) IF the Start date is in the past, AND if a dropdown list DONT show "Done". Anyone that has this formula or knows how to write one? Kin…Formulas and Functions399Hugo Martinwall

First post 03/28/19,Last post 04/11/19I need to be able to select to view the total cost of children by a certain month. Currently, I have the dropdown values of all 12 months. I have the formula to the right of the dropdown calculating the total cost recorded for each child.…Formulas and Functions11215cramsey

First post 03/28/19,Last post 04/22/19I want to set up a notification for when a row is modified by someone NOT in a contact list column of "assignees". The idea is that if someone not in the assignees cell modifies the column, then I would notify the assignees. I w…Formulas and Functions466kagrawa

First post 03/28/19,Last post 03/28/19Hi, new to Smartsheet but enjoying it so far. I'm building a report from multiple sheets that would ideally be a master list of all the rows that do not have a blank cell for one specific text/number column. The values within the column wi…Formulas and Functions911josha

First post 03/28/19,Last post 04/04/19So I am trying to count the number of times a person worked on a specific task. I have various "types", each person might have worked on the task in a different role (Lead SME, SME 2, SME 3), and then I have a check mark whether…Formulas and Functions46Shesha_K

First post 03/28/19,Last post 03/29/19We have a small team, with each member having very a specific area of expertise. As such, our timelines are defined by prioritization of tasks, dependencies, effort, and resource allocation. I want to enter my tasks, set their dependencie…Formulas and Functions341dtro

First post 03/28/19,Last post 04/04/19Hi, I'm new to Smartsheet and the community. I am trying to trigger a flag on my sheet to alert me when:  The status of my project is not complete, 5 days before the end date  The status of my project is in progress, but less tha…Formulas and Functions1413tsca

First post 03/28/19,Last post 04/01/19Hello, Able to get the countifs to total up some information in a different sheet. But then after a period of time, some of the cells using the countifs display #INVALID REF when it worked when I created my sheet screen shot shows a…Formulas and Functions379STEPHEN ALLEN

First post 03/27/19,Last post 04/04/19I am trying to use the aforementioned functions to crate a list of unique values by referencing a separate sheet. The source sheet contains a column of date values and a column of checkboxes which indicate unique dates. using either functi…Formulas and Functions211underscore_

First post 03/27/19,Last post 03/28/19Hi, Trying to create formula to calculate How many projects start in a certain month by each Project Manager  My excel formulas are weak Master sheet has columns: Project Manager is Contact List (does this have to be a Text/Number Colu…Formulas and Functions542Kelcon

First post 03/27/19,Last post 03/28/19I have two sheets with a common "Name" column between them. I would like for a checkbox in the second sheet to reflect in the first sheet, factoring in that not all of the names will be used in the second sheet. I would normally…Formulas and Functions552Nahum

First post 03/27/19,Last post 03/28/19I need to be able to calculate the first and last days of the year based upon the current date. Can someone help me out?Formulas and Functions302jwestberry83396

First post 03/27/19,Last post 03/28/19The formula I've created isn't working correctly and I can't figure out what I'm doing wrong. =IF([New NCN Score Total]120 = 15, IF([New NCN Score Total]120 <= 14, IF([New NCN Score Total]120 <= 9, IF([New NCN Score Total]120 <=…Formulas and Functions22Faz Mussa

First post 03/27/19,Last post 03/28/19i have this formula for calculating installs YTD for a given property. =SUMIFS({Mira Santi Install QTY}, {Mira Santi Install Date}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())) Not sure how to take this formula to use it to calculate install…Formulas and Functions8913steve50951

First post 03/26/19,Last post 03/27/19Here's the working statement: =IF(AND([Account Owner]191 = "JK", [SALES REP]191 = "JK", OR([BILLED BY]191 = "Merit Medical", [BILLED BY]191 = "Don Joy"), STATUS191 = "Paid"), CHARGES191 * …Formulas and Functions14Annie Dunn

First post 03/26/19,Last post 03/27/19I'm looking for the sumifs= Status column is "green", The Trans Date column in January 2018 the reversed column is unchecked. So far I only have the first part of the formula working. I cannot figure out how to include the re…Formulas and Functions315kari1282

First post 03/26/19,Last post 03/26/19I trying to write a formula if (Days)<=30 will display an Amount in column 030 (Image)Formulas and Functions21kari1282

First post 03/26/19,Last post 03/26/19For this formula, I would like the RYG balls to be the result. Instead, I’m getting the word “Green” or “Red”. So the formula is working, but would like the balls and not the word.Formulas and Functions466klauman69086

First post 03/26/19,Last post 04/02/19Hi Everyone, This is my first post on here and hope someone can point me in the right direction. I have a formula cell which references TODAY() in a certain IF criteria. I also have several alerts going to various users which are generat…Formulas and Functions4712Peter D

First post 03/26/19,Last post 02/27/20I want to use smartsheet as an international project management tool. One thing is driving me creasy. I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario.…Formulas and Functions1274Alexander Wirtz

First post 03/25/19,Last post 03/28/19Hi, I want to set today's date in a date column when the status, in a status column on that row, is set to something other than 'open'. I don't want the date to change once it is set so the TODAY() function does not work for me. Is ther…Formulas and Functions145amirvine68351

First post 03/25/19,Last post 03/26/19I was looking to see if there was a way to make an update to a field based on the status of other fields in the sheet. In my example I have a review process that sends multiple emails at once for review and approval. The reviewers each h…Formulas and Functions1033guy.rooker83086

First post 03/25/19,Last post 03/26/19I'm trying to create an If/Then/Else statement to determine if an employee is eligible for a pay increase. Essentially, the formula needs to say IF Mandatory Training Requirements Met = YES AND Corrective Action = NO THEN Eligible for…Formulas and Functions2052saraha83081

First post 03/25/19,Last post 03/25/19I can't figured out why #INVALID DATA TYPE auto fill when I haven't pick a date for the start and finish date. If I do have those fill out then the formula works fine but otherwise it just fill the duration cell with that error. I do have …Formulas and Functions553@[email protected]

First post 03/25/19,Last post 03/27/19Hello all! I have a smartsheet that is always open in our warehouse to let the guys know when an item needs to be shipped; the line is added by our procurement team. After the warehouse personnel complete a shipment, they mark the status …Formulas and Functions294Thurston64

First post 03/25/19,Last post 03/25/19Hello, I am using the formula =IF(Status2 = [HIDE: Statuses]1, "15") to add a set percentage to a completed task when the box is checked. It works, but then when I go to SUM those numbers, they simply combine the numbers (a…Formulas and Functions23Lauraarsenal