Formulas and Functions
Archives for January 2018
Discussion List
-
First post 01/31/18,Last post 02/01/18The subject pretty well tells it all, I am trying to sum the network days between the request received and request sent date but if we haven't sent the request response as yet the field is empty and shows the error " Invalid data typ…Formulas and Functions291Emma_w4tevr -
First post 01/30/18,Last post 02/07/18Hello - I'm a bit new to Smartsheet but loving it so far. I have a few columns with dates that I would like email notifications or reminders set up when the following conditions occur: 1 year anniversary from date in cell 5 years, 9 mon…Formulas and Functions144ericsite
-
First post 01/30/18,Last post 02/07/18Hello New user needing help with formula. I would like it to be something like this: When the due date is => than today -1 turn red, if the due date is < today - 3 days turn yellow, if due date is is =. than today +5 turn green T…Formulas and Functions319ShannonO -
Jessica Bradbury 165 views 1 comment 0 points Most recent by Shaine Greenwood Formulas and FunctionsFirst post 01/29/18,Last post 01/30/18I have used Smartsheet for years and find it to be the best Project Management platform to date. I have a few features I'd like to suggest be added in the near future... please note if you'd find any of these helpful too. Hopefully this w…Formulas and Functions1651Jessica Bradbury -
First post 01/29/18,Last post 01/29/18I have three main columns: Planned Start Date, Planned End Date, and Date Completed I am utilizing the formula below to determine which tasks are done and late in the status column. I would also like the status cell to be empty if the dat…Formulas and Functions1171akkaurkapoor
-
First post 01/28/18,Last post 01/31/18Apologies if this exists somewhere - I tried to look but couldn't find exactly what I needed. Using smartsheet to project manage for an event - I am wanting to have a 'Weeks to Go' Column that counts down how many weeks until the exact…Formulas and Functions816RoxanneF
-
First post 01/26/18,Last post 02/04/20Hi, I have a sheet where the RYGG is automated based on the due date (overdue=red, due date +2=yellow, the rest=green). I then set up the alerts ("Send a notification") so when the status turns yellow one email goes out, and wh…Formulas and Functions8610Heba H.
-
First post 01/26/18,Last post 01/26/18I need data to land in particular areas when entering into a Form... In my sheet I have Hierarchy's...Months, Jan through December. Under those sections I need the orders that are entered into a form to automatically be put under each are…Formulas and Functions605Shane Stanley -
First post 01/26/18,Last post 01/29/18Hello, I would like to type the word recent into a cell based on it being recent(created date is in the last 7/ days). Otherwise I want the Cell to be blank. This is what I tried but get #UNPARSEABLE =IF([Created]246>=TODAY(-7), …Formulas and Functions134Deirdre
-
First post 01/26/18,Last post 01/26/18Please be gentle, very novice smartsheet user! I am trying to get a total value on a smart sheet when certain conditions are met. I have a column called Type and a column called value, so when cell entries in column type are a particular…Formulas and Functions743Ian Smith 2017
-
First post 01/25/18,Last post 01/29/18I'm trying to create a setup where I sum together only the children if another box for that row is checked. I've come up with (see screenshot below as well): =SUMIF(CHILDREN(Include),1,CHILDREN()) But despite trying different variat…Formulas and Functions654dannysteiger2001 -
First post 01/25/18,Last post 01/25/18I'd like a column to populate "late" based on whether another column has a date in it or is blank. Does anyone have any experience with nesting this type of formula?Formulas and Functions251faganc
-
First post 01/25/18,Last post 01/26/18I figured out the formula to give me exactly what I need in Excel: =IF(LOOKUP(2,1/(A1:D1<>""),A1:D1),EOMONTH(LOOKUP(2,1/(A1:D1<>""),A1:D1),3)) This formula does not translate to smartsheet. I need a for…Formulas and Functions313Jeeppler
-
First post 01/25/18,Last post 05/27/19I'd like to be able to link to fields in a separate worksheet based on certain criteria. I'll give an example to try and explain: I have multiple projects running concurrently; each has a separate project plan as they are shared with diff…Formulas and Functions815Lexington
-
First post 01/25/18,Last post 01/25/18Hello, How can I write the formula to show that if the date in column A goes past todays date, hightlight the cell in red? Is that possible?Formulas and Functions131agetchius35541
-
First post 01/24/18,Last post 01/25/18Good afternoon everyone, I'm new to the SmartSheet community, but my company and I have been integrating SS into our PM work processes for about 1.5 years. We're a VOSB DOD contractor, and we use SS to create simple project schedules that…Formulas and Functions583PM_Mr Bill
-
First post 01/24/18,Last post 01/26/18Hello, I've searched and it appears the time formula is an ongoing battle for enhancement requests. Looking for some help, I have two columns; 'Start Time:' and 'End Time'. There is a drop-down box on the web form and sheet that starts at…Formulas and Functions20928Rockee
-
First post 01/24/18,Last post 11/07/18Probably it's easier than it looks to me, but I'm very new to Smartsheet and any help is highly appreciated. I have a column that contains name of several cities corresponding to complete projects in another column. I'm struggling to put…Formulas and Functions7210Y. Czerski
-
First post 01/23/18,Last post 06/20/19Hi all, Our current LOOKUP and MATCH functions are case sensitive, e.g., "my task" will not match against "My task". Would folks expect these functions to be case sensitive, case insensitive, or do you have no prefere…Formulas and Functions196Daniel Stein -
First post 01/23/18,Last post 01/24/18I'm new at this. Let's say these are my three columns: Open Balance | AR Due Date | WK 1 So in the WK1 cell I want this formula: If the AR Due Date is greater than 01/01/2018 and less than 01/07/2018, then return the value of Open B…Formulas and Functions2332DV
-
First post 01/23/18,Last post 08/03/18Hello all! I've been trying to create a time entry sheet like many others, but am running into an error with the Weekday() formula. I'm using the formula on a system column for the date/time the row was created. I have an entry for 01/22…Formulas and Functions304cmondo -
First post 01/22/18,Last post 01/23/18Unfortunately couldn't find the solution here. I'm just looking for a formula that will allow me to count total sum by the category of a product. Basically, I have two columns: first is the Dropdown list with the category of a product,…Formulas and Functions1756Y. Czerski
-
First post 01/22/18,Last post 01/23/18This is likely an elementary question, but I am having a challenge to get the formula for the Count of Children when I have the formula, for example, in a column B cell and I want to count the children of column A. What am I doing wrong?Formulas and Functions1535Cindy Hawkins
-
First post 01/22/18,Last post 02/02/18I have a cell that holds a target date (Target Go-Live Date) and another cell that I want to hold the original date entered in the target date cell. This way if the Target Go-Live Date is changed, the other cell (Original Target Date) has…Formulas and Functions292Keith V
-
First post 01/22/18,Last post 01/23/18Hello Everyone, I have two columns, one has the name of the customer "name" and the other column has the number we assigned to the customer "number". I am trying to link these two for example, let us say if I type …Formulas and Functions331oakhayat
-
First post 01/21/18,Last post 01/25/18I have a formula that calculates the "Planned % Complete" based on start and end date, with no weighting. We use it as a general guide because there is no planned % complete provided by Smartsheet. Formula: =IF(Start14 >= TOD…Formulas and Functions301MelG
-
First post 01/19/18,Last post 01/31/18Hello all, I am using SS to process work orders. People fill out a form which has a priority dropdown column with classifications such as urgent, semi urgent, can wait etc... I wanted to see if i could write a formula in the deadline colu…Formulas and Functions162203jk -
americansurveymanagement35236 26 views 3 comments 0 points Most recent by americansurveymanagement35236 Formulas and FunctionsFirst post 01/19/18,Last post 01/20/18I am new to SS and I am trying to automate the Project Status Red, Yellow, Green & Gray balls to change to the correct color based on the Project Stage selected. Project Stage drop down will need to work as follows: Red Ball = Not S…Formulas and Functions263americansurveymanagement35236 -
First post 01/19/18,Last post 01/19/18Can't get the right formula for the task I want to perform - as follows - IF the PRODUCT column = "MMS", and the POSITION column = "CURRENT - CORE", then SUM the JAN'18 FCAST column basEd on the following range - JAN'1…Formulas and Functions271grussell24246
-
First post 01/19/18,Last post 08/02/18Hi, I have a formula =MAX([Last Modified]:[Last Modified]) + "" for getting the most recent date in the Last Modified System Column to get the latest modification date is for the whole sheet. Now, I'm trying to gather all those…Formulas and Functions953oj6_projmgr