Formulas and Functions
Archives for December 2018
Discussion List
-
First post 12/31/18,Last post 01/01/19Hi, everyone. I don't know if this is a possibility or not but I'm hoping someone can help. I'm looking to see if it's possible to set a formula/equation/conditional formatting so that what's entered in one column will autofill another. …Formulas and Functions1473SPalmieri -
First post 12/31/18,Last post 01/01/19I am trying to automate my schedule for a project as much as possible. I have a line for production start that is based on my current ship date but I have 9 shipments after that and would like to have the actual production line have a star…Formulas and Functions263JamieRH -
First post 12/31/18,Last post 01/03/19One of the questions on my form is what year(s) someone attended our annual meeting. The format is text/number. if someone attended in 2016, 2017, and 2018, the answer is being formatting with commas and displays as 201,620,172,018 even th…Formulas and Functions2920Lainie Franklin -
dacey.hartsfield73521 28 views 3 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 12/30/18,Last post 01/06/19I have a column for priority which returns symbols. Exclamation = high, dash = medium, and down arrow = low. I have tried various formulas and nothing is working. I basically want to know the amount of highs, mediums, and lows in my s…Formulas and Functions283dacey.hartsfield73521
-
First post 12/28/18,Last post 12/28/18I have a master sheet that I am using to pull in data from the child sheets (linking). The child sheets are dynamic and new parents and childs could be added. 1. When linking i lose child sheet hierarchy on the master sheet. How do i main…Formulas and Functions51JamieRox
-
First post 12/28/18,Last post 12/28/18I've created a scorecard in smartsheet and want to create a formula that does not allow the scorecard score to show as more than 100%. I think is should be something like If score >100%,100% but am not sure what the entire formula sho…Formulas and Functions194learle73571
-
First post 12/27/18,Last post 01/02/19Hello, I'm looking for a way to find the next task due date. Ideally, I'll be able to look at a row with several date columns, and determine the next date. This would be the MIN Date that is Greater than Today's date. I can easily get t…Formulas and Functions643pgreene31
-
First post 12/26/18,Last post 12/27/18Hello, I am trying to have my formula count when the row has "Ken Mallory" for the name column and any date that equals January. This is what I have so far but it is Unparseable. Thanks for your help:) =COUNTIFS({Master Compli…Formulas and Functions181daniel68616
-
First post 12/26/18,Last post 12/27/18Smart sheet enables the user to upload attachments, which is useful. So what I do for my workflow is I have a full sheet dedicated for part number and part information, so when I type in a part number on the work order sheet it auto-fills …Formulas and Functions523codynew
-
First post 12/26/18,Last post 12/27/18Having trouble with the formula below. Version 1 works and extracts what I need from a cell. I need to then convert that to a numeric value. Currently I get #invalid value. I'm missing something, and I bet it's dumb. ;) * =MID([Active …Formulas and Functions219Preston -
First post 12/26/18,Last post 12/27/18How can we validate data at cell level? I want different cell ranges (in the same column) give me different drop-down options. Right now I see that we can validate data at column level and not at cell level while Google Sheets and Excel al…Formulas and Functions371Zubair -
First post 12/26/18,Last post 12/27/18I am having some issues using the "IF" formula. I'm trying to make it so if ANY VALUE is in the "CUT, FAB, WELD" columns then it will output the text "In Progress" to the "STATUS" Column, and if ther…Formulas and Functions1467codynew
-
First post 12/21/18,Last post 12/22/18Hello, I hit my maximum cross sheet reference of 25000 - I removed a SUBSTANTIAL amount of columns that were pulling useless information (we realized we didn't really as much information like we thought we did.) But - since removing a hi…Formulas and Functions143Allison_S
-
First post 12/21/18,Last post 12/21/18Hi I am trying to calculate the revenue for each leg of an event. The drop down options are "Spring", "Fall" or "Both". Using the following statements individually I can get part of the answer: =SUMIF(CHILDRE…Formulas and Functions13ChrisT -
First post 12/20/18,Last post 12/20/18Hi, I'm trying to setup a nested IF statement to do the following: If DONE is checked then change the Status to Blue. If Due Date is more than 8 days out then make it Green. If Due Date is 7 days or less then make it Yellow. If Due Dat…Formulas and Functions161dmalbrough
-
First post 12/20/18,Last post 12/20/18Looking to have an update request that would create a new row (much like a form would do). Here is the situation: - Row with Project Name, PMs, etc... A PMs has more than 1 project. I need to calculate the weekly hours for stats purpose…Formulas and Functions677benolecl -
First post 12/20/18,Last post 04/04/19Hi, I am looking for a formula that can return the first, second, third ... value in the table. Using Vlookup will only return the first match Any suggestions!! Thanks Fadi (Image)Formulas and Functions227Fadi Odeh
-
First post 12/20/18,Last post 12/31/18Hello all. Pretty new to Smartsheet here. I am trying to create a call that checks if one column, Trip, contains a value 1st, if it does NOT contain the value 1st, I want it to populate the contents of the corresponding cell in column J…Formulas and Functions1064artaylor
-
First post 12/20/18,Last post 12/20/18Hi all! I'm trying to figure out the formula for how to sum the number of check boxes from the parents. I have the children figured out but it is the summing of the parents that isn't working. (See Picture) I would expect the Retail lin…Formulas and Functions162CDub
-
First post 12/20/18,Last post 01/23/20I have a sheet with a list of assets. There is a pull down menu that defines the status - I need to know when the menu is set to "complete". I can do that easily with a filter - but I want to cull the entries before a specific da…Formulas and Functions4258CamCrichton
-
First post 12/19/18,Last post 12/20/18Hello! Smartsheet newbie here:) I was trying to use a simple SUMIF formula to calculate the total number of days for a specific field. For example: I want to add all the days or duration for all projects that were labeled as "Conver…Formulas and Functions163Jessb9187 -
First post 12/19/18,Last post 12/20/18Hi Everyone! I would like to know if you are able to use date columns when automating a progress bar. Basically dates are entered as product moves to a new stage in the process. As the dates fill in, the progress bar fills as well. I've …Formulas and Functions282lisarae723
-
First post 12/19/18,Last post 12/20/18Building a kanban board with typical IT cycle states: Ready, Dev, Test, Deploy, Done. I'd like to track cycle times and throughput. I've created (locked) columns to capture a status change for each of the cycle states; e.g. Dev Start and…Formulas and Functions304RockyJim
-
First post 12/19/18,Last post 12/19/18I am currently struggling with the following COUNTIFS formula =COUNTIFS(AND([Start Date]:[Start Date], <= TODAY(), ISDATE([Start Date]:[Start Date]), [% Complete]:[% Complete] <= 0.5, [Helper Column]:[Helper Column] = 3)) It should…Formulas and Functions213tlawrence -
First post 12/19/18,Last post 10/23/19Over the past couple of days, I have searched and read every article and even solicited help from SS and have worked myself in a circle. I have a drop-down list (Submitted, Approved, Declined), I need to "auto-populate" a date c…Formulas and Functions9610DENVER DEWEES
-
First post 12/19/18,Last post 01/02/19Hello! I have a workflow created using Zapier so that when a new row is added to my master project sheet via a form entry it will update the first row in a template sheet and create a new project sheet from that sample sheet. This all wo…Formulas and Functions271Shanial
-
First post 12/19/18,Last post 12/20/18Hi all, Is there a way to have a date/time field on a form look up data in a separate sheet to populate itself? I'm setting up a form for people to select a date and time slot to attend a training session. I thought about having the lis…Formulas and Functions696Anelise Wilhelm -
First post 12/18/18,Last post 01/04/19I'm trying to create a weekly work schedule for all of the employees at our company, so that we can see the start and end of shift and total hours worked per day and per week for each employee. I contacted the Smartsheet team only to fin…Formulas and Functions1407JulianaD
-
First post 12/18/18,Last post 12/18/18Hi Guys! I am working on the following Formula: =IF(AND([Date Completed]1 < (TODAY(-3)), Cause1 = "", Correction1 = ""), "Overdue", "OK") Goal: If the date in a date column [Date Completed] is…Formulas and Functions35Kevin Sitech -
First post 12/18/18,Last post 12/18/18Hi, Can someone help me on this formula. Please check the formula if the % is greater than 100 % its should shows as Yes but in my formula its showing as No. (Image)Formulas and Functions13Jimmy