Formulas and Functions
Archives for May 2018
Discussion List
-
First post 05/31/18,Last post 06/01/18Hi everyone, I'm hoping this is easy to read, it is hard to explain. I am trying to STOP counting days from commencement date of a project once the DONE box is checked. I have managed to make it work without using NETWORKDAY, using this…Formulas and Functions172adrian -
First post 05/31/18,Last post 06/01/18I am trying to total points based on the persons name. Basically one column has the names, some of them duplicates. Another Column has points. I need a third column for total points at the end that looks at the names, finds those that a…Formulas and Functions1142shaun49811
-
First post 05/31/18,Last post 05/31/18Rookie here -- I'm hoping to get some help with a formula issue. I am trying to flag the "Attn" column if "Days Until Due" is less than 120. However, I don't want the "Attn" column to flag if the cell is blan…Formulas and Functions633Alyssa -
First post 05/31/18,Last post 06/01/18Hi- I see lots of threads to mark a parent if a child meets a certain criteria, but I am looking for the opposite. I have Material, Labor, and Subcontractor Parent rows and would like to mark the children with either a number or letter in…Formulas and Functions166Mike Liggett
-
First post 05/30/18,Last post 05/31/18Hello my friends - I need to create a formula to find any new rows added to a sheet in the last 24 hours. My created on system column is added. We currently are using the TODAY function, however, that only captures those added today, whi…Formulas and Functions452Tana Perkins -
First post 05/30/18,Last post 05/31/18Is there a way to validate a date before submitting a form. The Use-case is: We have an Event Request Date (Date field) on the form and we don't want the end client to select the close-by dates. We want to add a condition on the form; …Formulas and Functions192jaya.c.bandaru
-
First post 05/30/18,Last post 05/31/18Hi, Is there a way to use the harvey ball status to drive a formula? Here's an example of what I was able to achieve in excel but cannot replicate in Smart Sheet. =If(HarveyBall = "Full",date-today(),"") Result in e…Formulas and Functions363irene
-
First post 05/30/18,Last post 05/31/18For the formula below, when I drag this formula, which references another sheet, across columns in the sheet that I'm writing it, the column referenced in the formula doesn't change. Even though I've done nothing to anchor it, it just rema…Formulas and Functions813sstikons -
First post 05/30/18,Last post 09/17/19This one is baffling. I have a problem with 2 sheets reading each others data through a Vlookup. Each sheet has Vlookup ranges from the other sheet. I understand why formula and Vlookup may return a #circular or #blocked reference, but …Formulas and Functions312scott.barrett
-
First post 05/30/18,Last post 05/30/18I am trying to turn on a flag with a formula. I am using the below, my problem is that the flag does not turn red, when I enter the formula the flag disappears and I get a 1. When I take the flag formatting off and change it to text I get …Formulas and Functions1203pea.ccu49236
-
First post 05/29/18,Last post 05/30/18Hello again Community! I currently use the following formula for our projects: (Works well!) =IF(Finish15 <> 1; IF(due_date15 - planned_date15 > 0; "Red"; IF(due_date15 - planned_date15 > -3; "Yellow"; &qu…Formulas and Functions45vanzin -
First post 05/29/18,Last post 08/27/18I'm trying to have an automatic countdown but I keep running into an invalid data type or unparsable error. I am trying to show how many days remain until a point in the future (07/17/2018). Here are some of the formulas I've tried with…Formulas and Functions352Eric R
-
First post 05/29/18,Last post 02/20/19Hi is there a function that can return the column number when given the column name? This would help when columns are added in sheets that have vlookups referencing them.Formulas and Functions762yidnek
-
First post 05/29/18,Last post 05/29/18Hello Community! My question is quite simple. (I hope). How can I display the last value of a column? I tried to use the formula = INDEX, but I could not read the last number automatically. Thanks! (Image)Formulas and Functions1072vanzin
-
First post 05/29/18,Last post 09/30/19Hello Team, This would be a great formula to incorporate into my daily SmartSheets process within my organization. I would like to know how to create a nested IF statement if this is the correct formula to use, that uses an RYG (red, yell…Formulas and Functions41611Chris.fowler49286
-
[email protected] 24 views 4 comments 0 points Most recent by [email protected] Formulas and FunctionsFirst post 05/29/18,Last post 05/30/18I would like to create notifications for the creation of new sheets in specific workspaces and in general better track what sheets are getting created where. To this point I would like to build a master sheet with drop downs for each works…Formulas and Functions244[email protected]
-
First post 05/28/18,Last post 05/29/18Is there a way to reference the cell above? example: =IF(logical_expression, value_if_true, <CELL ABOVE>) The simple way is to reference using [COLUMN_NAME]2 (the number being the current row number minus one). But this is broken …Formulas and Functions1597BP97
-
First post 05/25/18,Last post 05/29/18I am trying to get a count of each row on my sheet that meets the following criteria. Children of ([Requested Date]17) (which is date format column) is between 1/1/18 - 1/31/18 and Children of (Canceled17) (which is check box format) i…Formulas and Functions331JL412
-
First post 05/25/18,Last post 05/25/18Hi - I am running into a problem with finding the average of multiple rows based on the two previous columns. I want to return the average of all the rows in column Fall Rate that correspond with Month = 1 AND Year = 2018. This would th…Formulas and Functions322NickV
-
[email protected] 52 views 7 comments 0 points Most recent by Richard Rymill SBP Formulas and FunctionsFirst post 05/24/18,Last post 05/25/18I would like to create a master project rollup to track projects, and do not want to set up cell linking every time a new project is added. To this end can we create a dynamic lookup so all the user has to do is type the name of the sheet …Formulas and Functions527[email protected]
-
First post 05/24/18,Last post 05/25/18My question is regarding this statement: "There's a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet in total." If a cell on the inbound sheet is reading a range from another sheet, do all t…Formulas and Functions281scott.barrett
-
First post 05/24/18,Last post 05/25/18Hi, I am trying to create an element of capacity planning for the company i work for, and am having issues with the start date and finish date. I have a master production planning sheet which has a basic start date for the job, and a fin…Formulas and Functions233Grant Davies
-
First post 05/24/18,Last post 05/28/18Good morning. I created a meeting request form for business units to fill out so we can capture information we need about an upcoming conference. I'm trying to rig the way the information is captured on the sheet and am having a little tr…Formulas and Functions221karen_berard -
First post 05/23/18,Last post 08/02/18I've not been active on this site over the past 2 weeks or more, simply because I'm becoming increasingly frustrated with the limitations I'm faced with because of bugs, oversights and a lack of fundamental features. Primary for me is a f…Formulas and Functions473Chris McKay -
First post 05/23/18,Last post 05/24/18I want to count how many times a "Department Name" shows up once a complete date has been entered into the date "Completed Date" column.Formulas and Functions53mark.gipson27746
-
First post 05/23/18,Last post 02/19/19I'm trying to write a formula using an IF/OR statement to set a flag (for the Revised Timeline column) when NA has been selected from a drop-down menu in the any one of five columns (e.g., Reason for Revised Analysis End Date). The flag sh…Formulas and Functions1043pkburns
-
First post 05/23/18,Last post 05/23/18Can anyone tell me what I am doing wrong here? I am trying to automate RYG balls from a % column. =IF([% Complete]3 < 50, "Red", IF([% Comlete]3 = 100, "Green, IF([% Complete] >50 AND <100, "Yellow")Formulas and Functions149Beth Blome
-
First post 05/23/18,Last post 05/25/18Hi, I would like to change a symbol cell based on the status of a predecessor completion status i.e. "If a predecessor completion status is 100% then the status of this raw should change".Formulas and Functions333Shanon
-
First post 05/22/18,Last post 05/23/18I have a simple math equation in one of my cells, and in place of one of the numbers I would like to reference a count of cells with dates in them in a certain column. My equation is: =100 - (((60 / 477) * 100)) (this returns a number …Formulas and Functions15n.burch
-
First post 05/22/18,Last post 05/24/18I have successfully automated the RYG balls to show a different color as we get closer to a due date, and then show "OVERDUE" when the due date has passed (Urgency). (Days1 is a hidden column that counts the difference between to…Formulas and Functions313HROptions
