Formulas and Functions
Archives for June 2019
Discussion List
-
First post 06/29/19,Last post 07/02/19Hi, I am trying to auto populate a time date stamp when a cell is filled in on a row. Ex Submission Status then I need to create a formula to populate a due date based on the time date stamp and based on Priority Levels Priority Level …Formulas and Functions437[email protected] -
First post 06/29/19,Last post 07/04/19I have a "Master" project resource sheet with great grandparent rows for "Current Projects" and "Future Projects", Then grandparent rows for each "Project", parent rows for department and child rows …Formulas and Functions10614ON
-
First post 06/28/19,Last post 07/08/19I would like the information from the first document labeled template first to auto populate into the second smartsheet labeled template second. I am managing multiple projects at once and have 7 smartsheets to track the data specific to…Formulas and Functions251mhunt
-
First post 06/28/19,Last post 07/08/19One of the project managers I work with prefers to work in a calendar view for the reports. I included snap shots of our Project Template, Report and Calendar View. Our process is to open a project template and name according to the meeti…Formulas and Functions121[email protected]
-
First post 06/28/19,Last post 07/03/19One of the project managers I work with prefers to work in a calendar view for the reports. I included snap shots of our Project Template, Report and Calendar View. Our process is to open a project template and name according to the meeti…Formulas and Functions906[email protected]
-
barry_CL_smartsheet 30 views 6 comments 0 points Most recent by barry_CL_smartsheet Formulas and FunctionsFirst post 06/28/19,Last post 06/28/19I have reports calculating off multiple workflow sheets based on a column in the worksheet with formulas - the reports sometimes appear blank and when I go into the worksheet to see why, the formula column shows as blank and then reappears…Formulas and Functions306barry_CL_smartsheet
-
Kristie.Bredfeldt 40 views 4 comments 0 points Most recent by Kristie.Bredfeldt Formulas and FunctionsFirst post 06/28/19,Last post 07/05/19Hello all, I really found this community helpful so far in learning how to use Smartsheets. I just wanted to provide a formula I created in case it is helpful for anyone else. I didn't find the exact info I needed when trying to make it,…Formulas and Functions404Kristie.Bredfeldt
-
First post 06/28/19,Last post 07/01/19I am trying to do something that I thought was fairly simple, but I keep running into an issue and receive an "#Unparceable" with my current formula. I am trying to build a Task Status based on Red, Yellow, Blue, and Green Cir…Formulas and Functions40817RC-MTAS
-
First post 06/28/19,Last post 06/28/19I have several different project sheets that contain communication tasks. I create another sheet to create a count of tasks coming up in the next 7 days (I plan to create a report to pull up to a dashboard). I am having trouble creating …Formulas and Functions281Dvenegas
-
First post 06/28/19,Last post 06/28/19Im having a little bit of a hard time trying to make formulas longer and saving column space(s). For instance when I run into an issue of creating a formula in 1 cell i sometimes create a new column and put the formula I wanted to add in t…Formulas and Functions284Marios Hadjikyriacou
-
First post 06/28/19,Last post 07/01/19Hello, I am trying to creating a PTO form but we have users that work weekends. In Excel, there is a formula, NETWORKDAYS.INTL (start_date, end_date, [weekend], [holidays]), that allows to shift what is considered a non-countable workday…Formulas and Functions293Saleena Chiu
-
First post 06/27/19,Last post 06/28/19I've been trying to find a way to combine various checkboxes to designate different status', for example: If this checkbox is checked then this is the status However, if that checkbox is checked AND this checkbox is checked, then it's in…Formulas and Functions1110Zak2428
-
First post 06/27/19,Last post 07/05/19I wrote a formula to calculate the number of days until a task is due. It works perfectly most of the time, but, on some rows, it doers not. Below are the actual copied and pasted formulas from the cells that say "OVER-DUE" and &…Formulas and Functions133Ben Donahue -
First post 06/27/19,Last post 06/27/19I am somewhat new to SmartSheets, and would like to know if there is a more concise way of doing what I'm trying to do. I am using sample names for the purposes of my question. I have one column of data [Data Column] that contains differe…Formulas and Functions1205anna_ashby
-
First post 06/26/19,Last post 06/27/19I am currently working on creating some sort of link or equation, that could allow me to create a "directory" sheet where the names in the primary column could be linked to another sheet so that all the names would automatically …Formulas and Functions122PFI.Data.Specialist
-
First post 06/26/19,Last post 06/26/19Hello I am trying to link formulas to count from a list or column all the cells that contain date and discard that which are text. But I can not get the combination of the formulas to work well. Thank you in advance.Formulas and Functions311angel.blanquet93966
-
First post 06/26/19,Last post 06/26/19We use Smartsheet in many wonderful ways but, in my opinion, the lack of a method to easily lock a cell with a date and/or time stamp is an open door for a competitors raid. A few years ago, I left Smartsheet because images could not be ex…Formulas and Functions532cpo1 -
First post 06/26/19,Last post 06/26/19I am attempting to use a COUNTIF formula on a column of cells that have VLOOKUP formulas pulling in information from another sheet. The COUNTIF formula returns a #NO MATCH. When I copy/paste the VLOOKUP info into text only, the COUNTIF f…Formulas and Functions422JDecepida
-
First post 06/26/19,Last post 07/18/19help me please I want to see in our project through a filter in which I specify: 1) If the status is not fulfilled 2) Deadline date in the past This is all I can do, but through the filter I need 3 points 3) All tasks that have a predec…Formulas and Functions243Materia174
-
First post 06/25/19,Last post 06/27/19I am trying to feed the health on multiple sheets into a dashboard using a metric sheet. I am having trouble adding the secondary location to be included in the formula. Does anyone know if this is possible? Thank you! (Image)Formulas and Functions205CrystalHoran
-
First post 06/25/19,Last post 06/27/19Is it possible to change the value of a certain cell using code in another cell. I would imagine it looking similar to this format.. IF([email protected]=X, different_cell=XX, different_cell=XXX)Formulas and Functions1253logan.boese
-
First post 06/25/19,Last post 06/27/19I have several tasks set up for team members using their email addresses in the Contact column. Some tasks have 1 member assigned and some have multiple. I have to run each person's workload and am trying to use a separate sheet that count…Formulas and Functions2119mel.greenspan -
First post 06/25/19,Last post 06/25/19Any tips on getting this formula from excel working in smartsheets? =EDATE(A2,VLOOKUP(MONTH(A2),'Data Table'!$B$3:$C$15,2,0))Formulas and Functions31@unitedproperties
-
First post 06/25/19,Last post 06/25/19I’m sure this is easy and I am missing something fundamental. I have searched other conversations but can’t debug my formula. I have a detailed project sheet (that is at max capacity…therefore I have created a separate sheet to do som…Formulas and Functions146ilene_healy68056
-
First post 06/25/19,Last post 10/24/19Hello, I have a sheet with a column of cells with formulas in them. These formulas produce numbers. Then I have a second sheet, where I have a formula in a cell that references the first sheet's column with numbers. This formula in the sec…Formulas and Functions1059Eva M
-
First post 06/25/19,Last post 06/26/19Hello, I hope you can help please. We use Smartsheet to prioritise our workload. What we want to do is to highlight if a task is due this week but we have not manually indicated it as a priority for this week. I have written an IF AND t…Formulas and Functions113AndrewC
-
First post 06/25/19,Last post 07/30/19Hi there I'm linking cells from numerous sheets to one specific. Most of the cells are containing dates. When linking, I have realised that month and date have switched places. Not all dates/cells, but in some cases. See below example. …Formulas and Functions312T_W
-
First post 06/25/19,Last post 06/25/19Hi All, I'm looking for assistance with COUNTIF if possible. I have a smartsheet containing 3 Rows of multiple flight departures. I need to create new columns which will count the following cells for me: Departure Flight Number D…Formulas and Functions122mwood
-
First post 06/25/19,Last post 06/25/19Another day, another question to the Community...! I'm trying to get a count of all jobs starting in each month. My formula is giving me an #INVALID OPERATION error though. =COUNTIFS({Start Date} >= (DATE(2019, 1, 1)), {Start Date},…Formulas and Functions1797Kirstine -
First post 06/24/19,Last post 06/24/19I need a formula for my sheet and I am failing. I need a formula that works for the attached screenshot. Calculates: Qty (LB1) x List Price (LB1) x % (LB 1) I really should have paid more attention in algebra! :-( (Image)Formulas and Functions122Andrea Prochaska