Formulas and Functions
Archives for August 2018
Discussion List
-
First post 08/30/18,Last post 09/06/18Hi All! I searched for this, but couldn't find an answer. Maybe it doesn't exist! I'm trying to set up a new dashboard for sales reps. In one sheet I will have them fill out all of their activities. I was TRYING to get them to fill ou…Formulas and Functions2412KatieS -
First post 08/30/18,Last post 09/04/18Hello! The sheet that I am working with is used to track agreements my department works with. Two of the data points (among many) that we capture is the agreement type within a drop-down and the signature date. I would like to capture the…Formulas and Functions773E_Pieper
-
First post 08/30/18,Last post 08/31/18Hi all, I'm trying to figure out a way to sum the number of one column if it has the value of another column. The formula I was trying is: =COUNTIF(Scoped:Scoped, Channel22) I want to know how many are scoped in the scoped column if the…Formulas and Functions36jhawking
-
First post 08/29/18,Last post 08/29/18I'm trying to copy a template to use. I have formulas already on the template, however when i put the new numbers in, it doesn't use the formula to add/subtract them. I have to litterly go through and on every sheet I create from either a …Formulas and Functions851Jodi Waldrup -
First post 08/29/18,Last post 08/29/18Hi all, I am trying to use the count of a symbol across some sheets. I know I can get this information by creating a report but for a more visual presentation, I am looking to get an actual number. I am currently trying something like th…Formulas and Functions161Jose R Trucios
-
First post 08/29/18,Last post 08/30/18Thank you for taking a look at this. I have one sheet where I am trying to show the count for a person on another sheet IF another column has a 1 in it. The 1 represents a checkbox in the ajoining column. For some I have tried looking for…Formulas and Functions15Angie Hatfield -
First post 08/29/18,Last post 08/30/18I have a column that shows red (off track), yellow (at risk), or green (on track) depending on whether a date column (completion) is before or after another date column (goal completion date). What I'd like to show is the amount of days si…Formulas and Functions114Daryl Horrocks
-
First post 08/29/18,Last post 08/31/18Hi, First, thanks for members of this forum, you’ve been a great help! I have one main sheet where all (different) legal tasks are listed to help the legal team manage the work load. Only the legal team has access to this sheet. One of …Formulas and Functions513Tomer
-
First post 08/28/18,Last post 08/29/18Below are two screenshots. The first is a screenshot of my target sheet. The other is a screenshot of my reference sheet. On the reference sheet I have a list along the left. In the column to the right is: =TODAY() On the target s…Formulas and Functions2117Paul Newcome -
First post 08/28/18,Last post 08/29/18I am attempting to have a RED Flag populate in the "Risk" Column for cells where the "Available Space" is less than 10. Kindly when answering, please complete the entire formula from start to end as from research I te…Formulas and Functions2409cramsey
-
First post 08/28/18,Last post 08/28/18HELP!!!!!! How do i create a formula to use RYG balls in the status column with % Complete column no matter how many videos and threads i look through!! I have a status column I also have a % Complete column I want to use balls to sho…Formulas and Functions5844Kate P
-
First post 08/27/18,Last post 08/28/18Hello, I need my sheet to lookup an employee's id number on a second sheet and return a RYG ball depending on the code in the 8th column. I tried this with no luck: =IF(VLOOKUP([Employee #]1, {EIC Range 3},8,False)="Yes","…Formulas and Functions161Elizabeth Lynner -
First post 08/27/18,Last post 08/28/18Hello, I am trying to add formular to sheets to show the tasks that have been marked 100% for each user in a certain time period, ie past 7 days, or 30 days etc. This data will be shown in a widget on our report page for team dashboard. …Formulas and Functions671Kelky01
-
First post 08/27/18,Last post 08/28/18I am having the hardest time using any kind of formula...whenever I type them in I get the unparsed error. I am trying to do a countdown from today to an end date but no dice. I find the explanations on here for how functions work aren't r…Formulas and Functions975dartarro21
-
First post 08/27/18,Last post 08/27/18Hello! I'm currently using a Sum If formula that works to sum up by each lead, however, once we turn the Sales Stage to Loss I would like to remove the losses from the sum for that person's weighted forecast. The formula below is filterin…Formulas and Functions273Lindsey P -
First post 08/24/18,Last post 08/27/18I want to figure out how many times a specific person sends an application out within a specific date range. Here is the formula I tried: =COUNTIFS(Name:Name,"Jane",[Application sent]:[Application sent],[email protected]>=DATE(2018…Formulas and Functions132KO_in_Colo
-
beth_linder28141 13 views 14 comments 0 points Most recent by beth_linder28141 Formulas and FunctionsFirst post 08/24/18,Last post 08/30/18I am trying to make a Primary sheet for all of my escalation formulas (since i have 14 single sheets to use the TODAY() function). so... if(TODAY(-7)> {Date Cleaned}, "enter a name", " ") so if today's da…Formulas and Functions1314beth_linder28141
-
First post 08/24/18,Last post 03/13/20Hello, I'm brand new to Smartsheets. Is there a way to find the number of duplicates in a column for a specific value? For example, how many "John Smiths" are in a list of names? Many thanks, PltrmgrlFormulas and Functions2327Pltrmgrl -
[email protected] 66 views 10 comments 0 points Most recent by J. Craig Williams Formulas and FunctionsFirst post 08/24/18,Last post 09/05/18[Update: I've found the solution and posted it in a comment] I am having some issues with a very complicated set of sheets I have created. Please be warned, I am stressing the limits of smartsheets, and it is a rather complicated group…Formulas and Functions6610[email protected]
-
First post 08/24/18,Last post 08/24/18Hi, this should be relatively easy I think, but I'm struggling. I have the following formula (pasted below these comments) functioning to test whether a certain value exists (IFC) within a range on another sheet, and then returning "&…Formulas and Functions361JRose
-
First post 08/24/18,Last post 08/27/18I have a sheet that contains a Posted column that is auto-populated with the created date. I have another column next to that that pulls the number of the month out of the date. Example would be the Posted column says created 03/11/2018 11…Formulas and Functions114Brandon E
-
First post 08/24/18,Last post 03/18/19I am working on creating a master list of events, that pulls data from 2 source sheets. I worked out the linking, but when the source sheets are re-sorted it messes up my links on the destination "master list". Is there a way aro…Formulas and Functions1145EFHuey
-
First post 08/23/18,Last post 08/27/18I am trying to use the following IF statements for my health column. I get up to IF([Move Complete]@row = "Termed? ", "Red", and if I add any IF statements after that it doesn't work. Can anyone tell me what I am do…Formulas and Functions162Lori Khoury
-
First post 08/23/18,Last post 08/24/18Used this formula to get No Flag and Flag result based on the date/whether the cell was blank. =IF(ISBLANK([Date1]2), 0, IF([Date1]2<= TODAY(7), 1, 0)) Now I need to get a Flag if the date in Date2 column OR Date3 column is within …Formulas and Functions31kkath
-
First post 08/23/18,Last post 05/08/19Goal: Flag when the due date is in the next 7 days No flag when the due date is BLANK or more than 7 days in the future Two formulas that seem to work separately: =IF(Due Date2 <= (TODAY() + 7), 1, 0) …Formulas and Functions9046kkath
-
First post 08/23/18,Last post 08/23/18Hi, I am trying to get a formula to sum the total value of orders invoiced this week. The formula i have tried is below, but returns '0' as the value. =SUMIF({Completion Date}, {Completion Date} = WEEKNUMBER(TODAY()), {Order Value}) The…Formulas and Functions204grant53396
-
First post 08/23/18,Last post 08/24/18Hey! I need to create UPCa text strings in Smartsheet. Currently we are using an excel spreadsheet that converts number strings into UPCa font values using an excel VBA macro. When I imported my Excel file into smartsheet, this macro …Formulas and Functions531Pelowtz
-
First post 08/23/18,Last post 08/30/18I've got a basic handle on VLOOKUP but what I am trying to do is a little unconventional due to sheet row limitations within smartsheet. We have a sheet in which people will fill in a part number, each part number has a part description. …Formulas and Functions125Shawn R
-
Marios Hadjikyriacou 2.6K views 12 comments 0 points Most recent by Mike Wilday Formulas and FunctionsFirst post 08/23/18,Last post 08/26/19Pretty new to the SS scene. I am looking for assistance/guidance on how to create a formula to check the current date, and compare it to another date in a different column and if the difference is greater than XXX days have it provide a sy…Formulas and Functions262712Marios Hadjikyriacou
-
First post 08/23/18,Last post 08/27/18Hi, I am trying to create a tracked schedule and was wondering if smartsheet had an option or setting that auto updated status based on the date entered and real time date. For example if a phase is due at 08/24/2018 and it is 08/25/2018 …Formulas and Functions3597rochen