Formulas and Functions
Archives for May 2019
Discussion List
-
First post 05/31/19,Last post 06/03/19I need to Sum the "Total" column cells IF: 1) Column Department Allocation Code = "49 CONTINUOUS IMPROVEMENT: Formula: =SUMIFS(Total:Total, Department Allocation Code:Department Allocation Code, ="49 CONTINUOUS IMPROV…Formulas and Functions363JKelley -
First post 05/31/19,Last post 05/31/19Hello, Smartsheet example here: https://app.smartsheet.com/b/publish?EQBCT=e6247aff028844ff9da1e4d0906860c2 What I am trying to do is the following: =SUMIFS(Name1:Name14, "Happy", average1:average14, Date1:Date14, >TO…Formulas and Functions22NBurrus -
First post 05/31/19,Last post 06/19/19Good Morning All, I am new to Smartsheets and would like some assistance on what I thought would be straight forward and I know I am missing something basic. So the formula in English: Is DATE 2 Blank YES - then NETDAYS between DATE …Formulas and Functions122Bluenose
-
First post 05/31/19,Last post 04/29/20Hi, New to Smartsheet, is it possible to link fields on a form based on conditions i.e: - If user selects 'Production' from the field 'Employment Department' then mandatory that must select a 'Production Shift' (i.e. one of following Gr…Formulas and Functions5857[email protected]
-
First post 05/30/19,Last post 06/06/19Hello, I have a Smartsheet here with some data formatted by Name, Date, Number Done, and Hours. This data is populated by forms. Here's a live Smartsheet example: https://app.smartsheet.com/b/publish?EQBCT=e6247aff028844ff9da1e4d0906860c…Formulas and Functions152NBurrus
-
First post 05/30/19,Last post 06/04/19Please help! I am working on a IT Change Request sheet where the request is submitted by Forms. For a change to take place we require a specific time to be entered. I know Smartsheet currently does not have a time option, but is it possi…Formulas and Functions2108Tori Peregoy -
First post 05/30/19,Last post 06/03/19Hi, I have a formula that works perfectly in Excel but I can not get it to work in Smartsheets. I am having issues finding corresponding functions in Smartsheets. This is the formula and screenshots show what I am getting from them. =IF(…Formulas and Functions563eganji
-
First post 05/30/19,Last post 06/11/19Hello, I am trying to flag duplicates that meet 2 criteria. I have a sheet that has Request type actions (Add, Revise, Delete, etc.) and also a Part ID column. I am trying to identify duplicate Part ID that also have the same Request ty…Formulas and Functions28312KevinL
-
dave.mcpherson56751 183 views 18 comments 1 point Most recent by Paul Newcome Formulas and FunctionsFirst post 05/30/19,Last post 06/10/19Hi, i am looking for some help please. I have been reporting using today and looking back 30 days, however my business now wants me to report on the previous months data. so if in Mid June it looks at May's data Is this possible to have …Formulas and Functions18318dave.mcpherson56751
-
First post 05/30/19,Last post 06/03/19Hello, I have this formula: =IF(AND([Completion Date]@row = "", [Date Range End]@row < TODAY()), "Past Due", "ALL DONE") I've tried a few things but I keep getting invalid operation, and I'm sure it's…Formulas and Functions1326Lisi
-
First post 05/30/19,Last post 06/13/19Hello, I am trying to create a formula that will automatically check a box if a due date is past due AND % Cmplt is not 100% OR due date is in the next 10 days AND % Cmplt is not 100%. Basically, I will pull the checkboxes items into a re…Formulas and Functions695RGeet
-
First post 05/30/19,Last post 05/30/19Hello, I have this formula to add 10 days to a date: =[Date1]@row + 10 Then I have this formula to leave blank if there is no date: =IF(ISBLANK([Date1]@row), "") I need to put them together so if there is a blank the cell …Formulas and Functions143Lisi
-
First post 05/30/19,Last post 05/30/19Hello! I have this formula that works great: =DATE(YEAR([Completion Date]3), (MONTH([Completion Date]3) + 3), (DAY([Completion Date]3))) But if my date in "[Completion Date]3" is blank it throws off my whole formula. What can …Formulas and Functions358Lisi
-
First post 05/30/19,Last post 05/30/19Hi, I am working hard to get my head around formulas and have managed to get the correct return with the below formula, if greater than 14 days then return "Yes", if less than 14 days then return no. Where i am struggling is i a…Formulas and Functions13dave.mcpherson56751
-
First post 05/30/19,Last post 05/31/19Hi, I'm having problem with my formula below. If I update the column 2 to reference "Amount Invoiced", it automatically change the formula in Column 1 to "AmountInvoiced". I need Column 1 to only reference PO Amount…Formulas and Functions34kkeung84246
-
First post 05/30/19,Last post 05/30/19Good Morning, I am trying this formula within my sheet in a brand new column: =IF([Planned Start Date]@row - 21 <= TODAY(), [Estimated Hours Number]@row, "") For this column, if someone put a date that falls between today a…Formulas and Functions2166Veronica J -
First post 05/30/19,Last post 05/31/19Please help, I am trying to flag late tasks in a column using the following formula... I am getting a #INCORRECT ARGUMENT SET error...Please help =IF(AND(Status27 <> "Complete", (Finish27 < =TODAY()), "red")) …Formulas and Functions1472leezee
-
First post 05/30/19,Last post 05/30/19Hi, I have a formula in place to have a certain value in a cell if the modified date is today "Updated", and if not display a different value "Not Updated". However, this seems to work when I open my sheet the next da…Formulas and Functions711[email protected]
-
First post 05/29/19,Last post 06/03/19I have completed building and testing my sheet and Dashboards. I now want to remove the System Generated Date for all my Form entries used for testing. If I remove the column and reinsert it, the formulas dont work. Is there a simple way o…Formulas and Functions245wrightco12
-
First post 05/29/19,Last post 11/13/19I'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program. I'm hoping there's a way to automatically track inventory usage base…Formulas and Functions1956@agredling
-
First post 05/29/19,Last post 05/30/19I have two numbers or dates Baseline budget 100,000 Current budget 35,000 Variance is 65,000 If I do a % calculation (variance/baseline) then its 65% I have a health indicator that says if the variance is > 10% then red, mor…Formulas and Functions892matthew.hird90386 -
First post 05/29/19,Last post 05/29/19Hello, I need help with the following. I am buildig a sales pipeline tracker. On one sheet I have a list of master accounts. On the tracker sheet I have a column named account list. Can I do a lookup/dropdown to get the account names f…Formulas and Functions231mkilci
-
Alicia_Murad90366 58 views 7 comments 0 points Most recent by Alicia_Murad90366 Formulas and FunctionsFirst post 05/29/19,Last post 06/06/19Hello Smartsheet Community, I have been attempting to create an automated formula in the status column. I tried the following two options. =IF(AND("Complete" , IF([% Complete]4=100% , "In Progress" , IF([% Compl…Formulas and Functions587Alicia_Murad90366
-
First post 05/29/19,Last post 05/30/19I am trying to find the first duplicate value with the purpose of using that to highlight another cell; however, my attempts at the first part of the process have resulted in both #UNPARSEABLE and #INVALID COLUMN VALUE. The formula I'm tr…Formulas and Functions243Andrew Brimer
-
First post 05/29/19,Last post 05/30/19I'm looking to add a formula which will check the dates in modified and created columns and update the status column. If the modified date is today and is greater than the created date I want to populate the Status column with "update…Formulas and Functions12916[email protected]
-
First post 05/29/19,Last post 05/29/19Hi All, I have a smartsheet and am unsure the work arounds with date formulas. I have two columns one referencing when a task should be completed and one with an actual delivery date of task. I am trying to enter in something to auto popu…Formulas and Functions443hbookston
-
First post 05/29/19,Last post 05/30/19I've created a sheet that we use to track our projects. For each project there could be one invoice we need to pay, or multiple, as the project progresses when the invoice is processed and the checks are sent out to our partners there is …Formulas and Functions123adamacantwell
-
First post 05/28/19,Last post 05/28/19I'm looking for a formula that would let me update the status column when the %Complete has a value entered. It should read if 0% is entered Status would be not started; if a value of 1-99% is entered then it is in "Progress" in…Formulas and Functions134[email protected]
-
First post 05/28/19,Last post 05/28/19I have created a block of formulas 4columns x 13rows that are each unique (with complex COUNTIFS formula) counting values etc. with different features. I would like to copy this formula block to another identical sheet. When I copy paste…Formulas and Functions231Randy Van Winkle
-
First post 05/28/19,Last post 05/29/19If I have a column with text like this: Mac:Air Mac:Pro Lenovo:Yoga Using formulas, how can I pull the data that comes before and after the semicolons? I want to end up with 1 column like this: Mac Mac Lenovo And another colu…Formulas and Functions6272SYSPK
