functionality

Ask a Question

Average formulaAccepted Answer

Accepted Answer Deanna Vandermeer 8 views 2 comments 0 points Most recent by Deanna Vandermeer 05/27/20Formulas and Functions

First post 05/27/20,Last post 05/27/20
I am sure this is rather obvious, however I am not seeing where my mistake is. All I am trying to do is return the average cost of a product cost column but I need to not include any $0.00 dollar amounts that are populating (which will hap…
Formulas and Functions82
Deanna Vandermeer
COUNTIF on FLAGS at PARENTS level not returning any value (number)Accepted Answer

Accepted Answer Syed Mohd Muhafzal 9 views 2 comments 0 points Most recent by Syed Mohd Muhafzal 05/27/20Formulas and Functions

First post 05/27/20,Last post 05/27/20
Hi Smart Community, I am trying to Sum my CHILDREN() Countif but it is not giving any value. All my sub-children is indicated as flag (1 or 0) Example When there is a delay release in a category Bug Fix : it will flagged out RED. On Bug Fi…
Formulas and Functions92
Syed Mohd Muhafzal
Mirroring a Grandchild row cell in the Child row cell based off current weekQuestion

Answered - Pending Review A. Marcus 16 views 4 comments 0 points Most recent by A. Marcus 05/27/20Formulas and Functions

First post 05/21/20,Last post 05/27/20
Hey all, I'm relatively new to Smartsheets and am hoping someone can help me out. I promise I've looked everywhere for an answer and I think I'm making this more complicated than it is. Thanks in advance for the guidance! I have a sheet …
Formulas and Functions164
A. Marcus
Default Background Color

Ty Layton 18 views 4 comments 0 points Most recent by Ty Layton 05/27/20Using Smartsheet

First post 05/22/20,Last post 05/27/20
Greetings I some how got the background of one of my smartsheets to appear gray whenever I create a new column and when I pull a report and display the Sheet Name (system column) it too appears to be gray. I have doubled checked the condi…
Using Smartsheet184
Ty Layton
How to Limit Access to SmartsheetQuestion

Question Donna T 5 views 0 comments 0 points Started by Donna T 05/27/20 Formulas and Functions

First post 05/27/20,Last post 05/27/20
I know this question likely goes against all that is Smartsheet, but... We have a sheet setup to take submissions from a form. When a new row is added, a contact in a column is notified. After the row's status is still "in progress&…
Formulas and Functions50
Donna T
How to create a top five.Question

Question Javier 10 views 0 comments 0 points Started by Javier 05/27/20 Using Smartsheet

First post 05/27/20,Last post 05/27/20
Hi! I've working on a dataset for a while now that essencially logs the everyday orders we receive from our clients. One of the colums records the name of the customer and I've been trying to create a report that counts how many orders a …
Using Smartsheet100
Javier
Multiple Criteria, total countQuestion

Answered - Pending Review Mona Singh 10 views 4 comments 0 points Most recent by Mona Singh 05/27/20Formulas and Functions

First post 05/27/20,Last post 05/27/20
Hi All, I am trying to do calculate a total number of events, that match criteria for 1. Date range (can also use fiscal column as a matching criteria where i only want those that contain specific letter/numerical value = Q2) for all -ND…
Formulas and Functions104
Mona Singh
Why Calendar App is not Displaying properly?Question

Answered - Pending Review jpagan03101416 18 views 2 comments 0 points Most recent by Jon Baier 05/27/20Premium Apps and Integrations

First post 04/16/20,Last post 05/27/20
For some reason the calendar App in web or is not working correctly. I have attached a screenshot of the web and a PDF export (PDF is working how is supposed to) Web Version https://us.v-cdn.net/6031209/uploads/193/TNBXIDDJDDHF.png PDF ver…
Premium Apps and Integrations182
jpagan03101416
Reproducible HyperlinksQuestion

Answered - Pending Review Dennis Knipfer 19 views 3 comments 0 points Most recent by Mike Wilday 05/27/20Using Smartsheet

First post 05/27/20,Last post 05/27/20
I'm compiling a hyperlink section to include at the top of project sheets, a little more than a dozen in total. This collection creates my tabbed "Excel report". It will allow end users to navigate to the tabs/sheets they need. I…
Using Smartsheet193
Dennis Knipfer
Updating a Date Column after another cell is updated.Accepted Answer

Accepted Answer Eric Glassey 9 views 3 comments 0 points Most recent by Andrée Starå 05/27/20Formulas and Functions

First post 05/27/20,Last post 05/27/20
I am trying to have a Date Column update with today's date when a single select option is chosen. I don't want to use the system update date column because that will get updated whenever any cell is selected. For example: I have a single …
Formulas and Functions93
Eric Glassey
List of date formula I have used repeatedly

[email protected] 30 views 4 comments 0 points Most recent by [email protected] 05/27/20Using Smartsheet

First post 05/20/20,Last post 05/27/20
Doing this so I have an ongoing list of functioning optimized formulas , keeping it in the community in case it helps someone else. Please feel free to comment with your own, but I'm keeping the most basic of the formulas out of this. Bel…
Using Smartsheet304
[email protected]
Use Wildcards in an INDEX MATCH formulaQuestion

Answered - Pending Review Jose Rivera 21 views 1 comment 0 points Most recent by [email protected] 05/27/20Formulas and Functions

First post 05/25/20,Last post 05/27/20
Hi everyone, I need to use INDEX MATCH formula to get a DS# with a CNDT# in another report. The easy formula would be: =INDEX({DS Report Range 2}, MATCH([CNDT Number]1, {DS Report Range 3}, 0)), "") but the thing is that sometim…
Formulas and Functions211
Jose Rivera
RYGB Symbols Average FormulaQuestion

Answered - Pending Review joe.quinones 12 views 2 comments 0 points Most recent by [email protected] 05/27/20Formulas and Functions

First post 05/27/20,Last post 05/27/20
I currently having issues with creating formula that gets the average of 4 cells that have the option of 4 different symbols (Red,Yellow,Green,Blue). The goal is to show the average of the four cell symbol's in one here is what I have so …
Formulas and Functions122
joe.quinones
=IFERROR formulaQuestion

Answered - Pending Review Lindsay Wilson 10 views 1 comment 0 points Most recent by Ramzi 05/27/20Formulas and Functions

First post 05/27/20,Last post 05/27/20
Hi Within my project plan sheets I have 2 columns , On Time/Late and RAG. On Time / Late Column Formula =IFERROR(IF(AND([Original vs Current (days diff)]@row > 8, [email protected] = "Complete", [email protected] = "true"), &q…
Formulas and Functions101
Lindsay Wilson
How can I count dates in the past/future?Question

Answered - Pending Review Carolina Rivera 9 views 2 comments 0 points Most recent by Carolina Rivera 05/27/20Formulas and Functions

First post 05/27/20,Last post 05/27/20
Hi, I'm trying to create a formula that counts certain actions in a column based on their date. Say, if there are three dates: 5/15/2020, 5/20/2020, and 5/30/2020, I want to be able to know which ones are in the future and which ones are …
Formulas and Functions92
Carolina Rivera
DataMesh - Duplicates In Source SheetQuestion

Question Mike Rini 7 views 0 comments 0 points Started by Mike Rini 05/27/20 Premium Apps and Integrations

First post 05/27/20,Last post 05/27/20
I have a DataMesh sequence that I run that where the source sheet can have 1 to N number of entries, and it's valid. As I understand it, DataMesh only allows me to select two options - Pick First Match and Ignore Entries. In either of thos…
Premium Apps and Integrations70
Mike Rini
Contact List Field in the New Logical FormsQuestion

Answered - Pending Review cthrasher97141 22 views 6 comments 0 points Most recent by Jared Davis 05/27/20Using Smartsheet

First post 05/07/20,Last post 05/27/20
I have a grid with a Contact List Column and I have imported all of my contacts from Outlook, in the grid the field will start suggesting contacts as I type. I created a form from the grid but when I launch the form and start typing in the…
Using Smartsheet226
cthrasher97141
can a person submitting a form save it if they need to come back to it later?Question

Answered - Pending Review Susan Hildebrant 11 views 3 comments 0 points Most recent by Andrée Starå 05/27/20Using Smartsheet

First post 05/27/20,Last post 05/27/20
I have created a form that requires a lot of information before it can be submitted. The person completing the form may not have all the information at hand or may get interrupted while completing the form. Is there a way the person can s…
Using Smartsheet113
Susan Hildebrant
How do I auto-save a sheet without opening the sheet?Question

Answered - Pending Review Lawrence West 31 views 13 comments 0 points Most recent by Paul Newcome 05/27/20Using Smartsheet

First post 05/19/20,Last post 05/27/20
I use conditional formatting. When I review the dashboard, the formatting doesn't update until I go to the sheet and save. I would like the sheet to save automatically when conditional formatting makes changes. Thank You.
Using Smartsheet3113
Lawrence West
How you do get an automation to send an "Alert Someone" email.Question

Answered - Pending Review Garrett Ricker 30 views 2 comments 0 points Most recent by Emma Smyth 05/27/20Formulas and Functions

First post 04/29/20,Last post 05/27/20
https://us.v-cdn.net/6031209/uploads/046/RFT8B36MG9ZR.pdf
Formulas and Functions302
Garrett Ricker
New form builder with conditional logic now available!

Announcement Caroline S. 412 views 14 comments 2 points Most recent by Andrée Starå 05/27/20Announcements

First post 05/04/20,Last post 05/27/20
Hello Community, I’m the forms product manager at Smartsheet and am pleased to let you know that we have launched a new version of our form builder that includes conditional logic. The new, full-screen form builder keeps more of the sett…
Announcements41214
Caroline S.
Printing across multiple pages - Gannt chartQuestion

Answered - Pending Review Simon Cusack (CCHD) 13 views 1 comment 0 points Most recent by Genevieve P 05/27/20Using Smartsheet

First post 05/26/20,Last post 05/27/20
When printing across two pages, can I repeat the columns with task, duration, start and end date, etc on each page.
Using Smartsheet131
Simon Cusack (CCHD)
Merge all attachments of a sheet into one PDF?Question

Answered - Pending Review Julia Peterson 11 views 3 comments 0 points Most recent by Andrée Starå 05/27/20Premium Apps and Integrations

First post 05/27/20,Last post 05/27/20
Is there any way to automate merging all of the attachments of a sheet into one PDF? I was thinking of using zapier or Microsoft Flow but I haven't been able to figure out a good and simple way to. Ultimately I want the end users to be abl…
Premium Apps and Integrations113
Julia Peterson
Count(Distinct()) function that works with one column (range), but not another.Question

Answered - Pending Review Brian_Vaughan 29 views 4 comments 0 points Most recent by Brian_Vaughan 05/27/20Formulas and Functions

First post 05/20/20,Last post 05/27/20
Hi All! I am using a =Count(Distinct({Range})) which works exactly as expected with one range of data, but returns a "1" with the exact same formula on an adjacent column of data. The only difference between the data in the 2 c…
Formulas and Functions294
Brian_Vaughan
VLOOKUP Multiple MatchesAccepted Answer

Accepted Answer Dennis Wierzbicki 39 views 18 comments 0 points Most recent by Paul Newcome 05/27/20Formulas and Functions

First post 05/21/20,Last post 05/27/20
I have a table that sometimes has duplicate entries in a column. I'm doing a VLOOKUP on this column, however, obviously, if there is more than one match, this generates an error. What I'd like to do is return a match for the most recent d…
Formulas and Functions3918
Dennis Wierzbicki
New Columns Not Available to Select in Report BuilderQuestion

Answered - Pending Review Donna T 17 views 3 comments 0 points Most recent by Andrée Starå 05/27/20Using Smartsheet

First post 05/19/20,Last post 05/27/20
I am using the Communications template Smartsheet has available. I modified the categories to suit them to our business. I went into Report Builder to modify the report and the categories do not appear to select. Just for testing's sake…
Using Smartsheet173
Donna T
How can I count the amount of actions in one specific month?Accepted Answer

Accepted Answer Carolina Rivera 12 views 3 comments 0 points Most recent by Paul Newcome 05/27/20Formulas and Functions

First post 05/27/20,Last post 05/27/20
Hi, I'm trying to set up a counter for a number of actions in the month of may, for example if I have 5 actions this month (May), I want the counter to return "5". I've been trying to use the formula below but all I get in return…
Formulas and Functions123
Carolina Rivera
Counting amount of actions in one monthQuestion

Answered - Pending Review Carolina Rivera 13 views 1 comment 0 points Most recent by Paul Newcome 05/27/20Formulas and Functions

First post 05/26/20,Last post 05/27/20
Hi, I'm trying to set up a counter for a number of actions in the month of may, for example if I have 5 actions this month, I want the counter to return "5". I've been trying to use the formula below but all I get in return is a…
Formulas and Functions131
Carolina Rivera
Is it possible to count if a cell changes?Question

Answered - Pending Review Cassie Hart 11 views 2 comments 0 points Most recent by Cassie Hart 05/27/20Formulas and Functions

First post 05/27/20,Last post 05/27/20
Hello! I am trying to calculate the amount of times a cell dropdown is changed per day. Is this even possible or would it need some magic workaround? In any given day the "current stage" column changes possibly many times. An exa…
Formulas and Functions112
Cassie Hart
Column Reference Formula Returning Incorrect AnswerQuestion

Answered - Pending Review JHand 10 views 1 comment 0 points Most recent by Genevieve P 05/27/20Formulas and Functions

First post 05/26/20,Last post 05/27/20
I am writing a simple COUNTIFS formula and I am getting a very different answer when I created a column reference vs. referencing a specific range within the column. What am I missing? I am trying to count the number of customers that ar…
Formulas and Functions101
JHand

Ask a Question

functionality

functionality

Discussion List