Formulas and Functions
Archives for June 2018
Discussion List
-
First post 06/29/18,Last post 06/30/18I'm trying to count everything in a Type column that = "Risk" that match a status of "Red" and "Yellow". How would I add "Yellow" to this statement? =COUNTIFS(Type:Type, "Risk", Status:St…Formulas and Functions41rlakin52911 -
First post 06/29/18,Last post 07/03/18Hi, I'd like to copy a SUMIF formula across columns, where the only change in each would be to have the formula automatically update to match the new column name. Specifically, it would autmoatically change from the original colum =SUMI…Formulas and Functions271AMichel -
First post 06/29/18,Last post 07/02/18Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date…Formulas and Functions2383LouiseM
-
First post 06/29/18,Last post 07/02/18Hi all, I am struggling to find a solution for this. I have 15 individual sheets for a project. One of the activities on sheet 2 will include a "yes/no" question. If yes, then sheet 3 needs to be completed. If no, then sheet…Formulas and Functions22Jose da Silva
-
First post 06/29/18,Last post 06/29/18Im trying to count 2 columns on a issue sheet and want to count out each specific type (Risk, Action, Issue, Decision) that are open (not counting the closed or in progress types) I have these formuals but its not producing a result * =C…Formulas and Functions172rlakin52911
-
First post 06/28/18,Last post 07/09/18Hi, I have a sheet with diferent columns, one is "Initial Date" and other one is "Ending date". How can avoid users update "Ending Date" with a date earlier than today?Formulas and Functions385amedina52556
-
First post 06/28/18,Last post 05/29/19Is there a way for smartsheet to implement an auto-downfill function that allows users to input their desired formula into a column heading that makes every cell within that column (including cells added in the future) populate with said f…Formulas and Functions2726Brandon S
-
First post 06/28/18,Last post 06/28/18Hello, I am trying to do a vlookup on my smartsheet task list to reference a different smartsheet which looks up for example "312" returns the value two columns over, which is a date, and then minus 90 days from that date and ret…Formulas and Functions33heather.altiero52961
-
First post 06/28/18,Last post 06/28/18Hello, I have two checkbox columns: one for Arabic and one for English. These columns will either be checked, unchecked or say "n/a". What I want is to have another checkbox column where it is checked if Arabic and English are…Formulas and Functions31nicky.whiteley52946
-
First post 06/27/18,Last post 07/09/18I want to have a condition where IF Delivered column checkbox is checked, then that whole row will be deleted. Is that feasible? Can you please guide me how to start with it? (Image)Formulas and Functions506trishhfernandez
-
First post 06/27/18,Last post 06/28/18Hi, Please excuse my beginner's questions. We are starting to use scanning QR codes into smart sheet. Currently our QR code translates to the below text, where important values are delimited by "|" symbol. When the below text is…Formulas and Functions783SarahLee
-
Silvia C Rodriguez 97 views 4 comments 0 points Most recent by Silvia C Rodriguez Formulas and FunctionsFirst post 06/27/18,Last post 06/29/18Hello! I have another beginner question. Is it possible to combine an If conditional with a Vlookup? This is my scenario: I have 2 sheets: Summary and Form. Columns in each sheet are: Summary Sheet: -Column Name -Column Question #…Formulas and Functions974Silvia C Rodriguez -
First post 06/27/18,Last post 07/02/18Hello Community, How do I go about writing an IF function to get a particular cell to automatically show Green when the child rows turn Green individually? Basically, I would like to see the parent row update green without the need to do …Formulas and Functions33dyep
-
tina.hutchinson52776 12 views 4 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 06/27/18,Last post 07/23/18Hi team, Could you kindly help me out with the formula syntax for the following scenario please: If the "Rag Status" column is 'Red', and the "Complete" checkbox is not checked, then the "Action Status" must…Formulas and Functions124tina.hutchinson52776 -
First post 06/27/18,Last post 06/28/18Hi Smartsheet community! I have the following problem: I have a Smartsheet with a long list of items. These items will be shipped in several shipments and several collis, on different dates and to different locations. I would like to ext…Formulas and Functions421Gabriele
-
First post 06/27/18,Last post 06/27/18Hi, It's me again. Today I would like to ask if it is possible for reports to automatically select items that meet all the requirements of a set criteria. What I would like to do is make it so that when a task is completed and the box is …Formulas and Functions321Anton
-
Maxime Vanwynsberghe 11 views 1 comment 0 points Most recent by J. Craig Williams Formulas and FunctionsFirst post 06/27/18,Last post 06/27/18Hi, I've noticed that when you insert a column in one of the source files all vlookups in other sheets will reference an incorrect cell. Either it should be smart enough to know the change on the source and change it's formula or at leas…Formulas and Functions111Maxime Vanwynsberghe
-
First post 06/26/18,Last post 06/27/18I would like to write and IF formula in one column that involves 3 other columns. I'll do my best to explain what I am trying to do and the issue I am running in to. The first column is called "Building" and this is where I am w…Formulas and Functions33Shawn R
-
First post 06/26/18,Last post 06/27/18I understand that Smartsheet is not automation tool, but would like to make team's work easier without having to enter lots of information manually. Situation is that that we have two files: pipeline and quote. Once the quote is complete…Formulas and Functions423Y. Czerski
-
First post 06/26/18,Last post 06/27/18I'm still pretty new to Smartsheet. My goal is collect data from another sheet in an easier to read format but I cannot get my COUNTIFS formula to work. If I do separate formulas for each criteria it will work but not when I attempt to com…Formulas and Functions1482Nic Larsen
-
kelley.kimball34646 11 views 2 comments 0 points Most recent by kelley.kimball34646 Formulas and FunctionsFirst post 06/26/18,Last post 06/26/18Trying to Auto-fill a value in one column based upon "fixed" drop down list of values from another column. So this is the formula I am starting with. =IF([Product Family]1 = "7765", "252 Industrial", "26…Formulas and Functions112kelley.kimball34646 -
First post 06/26/18,Last post 06/26/18Hello All, I am using this formula =TODAY() - [Date Field Checked]3 but I need to stop this count when the item is complete. Could someone please help out?Formulas and Functions313Team Orbie 9
-
First post 06/26/18,Last post 06/26/18Hello! I have a question, is it possible to create a percentage for symbols? I've been trying to create a percentage of items that are high priority, which would be displayed as a red flag. This would all be displayed in both sheets, repo…Formulas and Functions677Anton
-
First post 06/26/18,Last post 06/26/18Hi Team Is there a way that the rows can disappear after we’ve ticked them delivered please? (Image)Formulas and Functions692trishhfernandez
-
First post 06/25/18,Last post 06/26/18Hi Smartsheets Community, I am trying to write an index match that looks at a row that either says yes or no (only one column says yes) and return to me the corresponding value in the column below it. I currently wrote =index([column n…Formulas and Functions371cfischer
-
First post 06/25/18,Last post 06/26/18Hello everyone, I would like to reference multiple cells in the same column from sheet B onto sheet A. I thought I could create a reference formula on Sheet A to pull the value from sheet B and then drag that same formula down onto the re…Formulas and Functions1094Veronica GM
-
First post 06/25/18,Last post 06/26/18Hi I have a sheet with a column for 'created by' (for form entries) and need to be able to strip out the @domainname.co.uk text so that I'm just left with the individuals name in a separate column. Ideally, I would also like to add a spa…Formulas and Functions22Phil Smith
-
[email protected] 32 views 3 comments 0 points Most recent by J. Craig Williams Formulas and FunctionsFirst post 06/25/18,Last post 06/26/18I am having an issue with a formula that I believe to be a bug. =LEFT(JOIN(COLLECT($C:$C,$Created:$Created, NETDAYS(@cell, TODAY()) <= IF(WEEKDAY(TODAY()) = 7, 2, IF(WEEKDAY(TODAY()) = 6, 1, WEEKDAY(TODAY()) + 2)), $A:$A, $[Work Des…Formulas and Functions323[email protected]
-
First post 06/25/18,Last post 06/26/18I am trying to summarise a Smartsheet that we log sales activities (F2F Calls and Phone Activity into). So I want to see how many Phone calls have been done in the current month. 1. What is the most efficient way to achieve this? I have u…Formulas and Functions31OSG
-
Silvia C Rodriguez 69 views 4 comments 0 points Most recent by Silvia C Rodriguez Formulas and FunctionsFirst post 06/25/18,Last post 06/27/18Hello, I need help. I am wondering how can I create a formula using the IF function with a range of dates. For example: If the date is between 01/01/2018 and 03/30/2018, then write 1st Quarter., and if the date is between 04/01/2018 and …Formulas and Functions694Silvia C Rodriguez
