## Forum Stats

• 38,176 Members
• 20,431 Discussions

# Recent Discussions

Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.

## Discussion List

• Answered - Pending Review stephanie.blake67241 13 views 4 comments Most recent by Andrée Starå Formulas and Functions
First post 04/09/20,Last post 04/27/20
I keep getting this error when trying to embed a Lucid Chart in my dashboard. What am I doing wrong? https://us.v-cdn.net/6031209/uploads/400/LO4OGNXZZP6Z.png
Formulas and Functions134
stephanie.blake67241
• Answered - Pending Review ker9 23 views 3 comments Most recent by Andrée Starå Using Smartsheet
First post 04/20/20,Last post 04/27/20
I would like to allow multiple viewers per row. It does not work with a Contact Multi-select field and you are not allowed to add more than one contact column to the Restrict View option. Any suggestions other than creating 4+ separate v…
Using Smartsheet233
ker9
• Answered - Pending Review Lynn Collier 11 views 1 comment Most recent by Andrée Starå Formulas and Functions
First post 04/27/20,Last post 04/27/20
Hi, I would like to know how to replace a zero value with a blank?  Thanks, Lynn
Formulas and Functions111
Lynn Collier
• Answered - Pending Review Vitaly R. 26 views 2 comments Most recent by Vitaly R. Formulas and Functions
First post 04/23/20,Last post 04/27/20
I am struggling with a formula that I thought would be easy. I want to sum all children of Total column while omitting one child (Taxes & Freight). The purpose of this is to then multiply it all by Tax and Freight mark-up % (Qty2051) .…
Formulas and Functions262
Vitaly R.
• dateQuestion
Answered - Pending Review Cyril BELMONTE 2 views 1 comment Most recent by Genevieve P Using Smartsheet
First post 04/24/20,Last post 04/27/20
Bonjour comment copier une cellule ou est incrit une date dans un autre cellule pour que celle ci soit toujours à jour merci Cyril
Using Smartsheet21
Cyril BELMONTE
• Answered - Pending Review Tammy Parker 22 views 3 comments Most recent by Genevieve P Formulas and Functions
First post 04/24/20,Last post 04/27/20
I have a Target Complete Date for each type of file (over 1600) I need to capture the number of files Due to complete in Jan, Feb, etc Each month. Below I am trying to count IF any Applied Bank Files are due to complete in January. The f…
Formulas and Functions223
Tammy Parker
• Answered - Pending Review Rick Benton 14 views 1 comment Most recent by Genevieve P Using Smartsheet
First post 04/24/20,Last post 04/27/20
Hello, I am pulling data into a report and displaying on my dashboard. The gantt view always starts on March 15th. Executives viewing the report want to have it start on today's date. The both the source sheet and report's gantt view is…
Using Smartsheet141
Rick Benton
• YPS 182 views 6 comments Most recent by Nam Anh Nguyen Using Smartsheet
First post 07/26/18,Last post 04/27/20
Anyone can share how we can disable (or set permission) on export of smartsheet to excel...etc for data security concerns. Thanks
Using Smartsheet1826
YPS
• Answered - Pending Review pietro108076 15 views 2 comments Most recent by Genevieve P Formulas and Functions
First post 04/24/20,Last post 04/27/20
https://us.v-cdn.net/6031209/uploads/084/EXDRTW8QSQSV.png Hi, I'm trying to calculate the average of the operational speed [plants/h] only if the [job type] is "Grafting TOM" (cells highlighted in yellow) and also IF [week NO] is…
Formulas and Functions152
pietro108076
• Accepted Answer Richard Heath 13 views 1 comment Most recent by Andrée Starå Using Smartsheet
First post 04/27/20,Last post 04/27/20
I'm struggling to get my \$ value metrics align based on the fact that they are a \$ value and not just text. This is from the Dashboard https://us.v-cdn.net/6031209/uploads/964/BZ49RA7PQDIM.png Note that the dollar values should be right a…
Using Smartsheet131
Richard Heath
• Answered - Pending Review Paul Piscopo 1 view 1 comment Most recent by Andrée Starå Formulas and Functions
First post 04/27/20,Last post 04/27/20
Hello
Formulas and Functions11
Paul Piscopo
• Accepted Answer Richard Heath 23 views 2 comments Most recent by Richard Heath Formulas and Functions
First post 04/23/20,Last post 04/26/20
Hello all, I'm trying to resolve a function for my sheet below. The basis of the sheet is that a user select "Yes" from the Payment Certificate column which results in Yes populating the Parent Row of the Payment Certificate Help…
Formulas and Functions232
Richard Heath
• Accepted Answer Richard C 26 views 5 comments Most recent by Andrée Starå Formulas and Functions
First post 04/24/20,Last post 04/26/20
Good morning/afternoon everyone. I am just stumped. Looked throughout the community and I'm not sure what is wrong. I have several columns on what I'm calling a master tracking sheet that pulls info from 32 other individual sheets. I h…
Formulas and Functions265
Richard C
• Accepted Answer claude.ngongang80316 23 views 5 comments Most recent by Andrée Starå Formulas and Functions
First post 04/08/20,Last post 04/26/20
Good Day! I am having an error message when trying with the formula below: I am trying to check a box if 2 conditions are met. project may be either in design phase (Analyse/Conception) or Execution. If the first condition is met, and th…
Formulas and Functions235
claude.ngongang80316
• Answered - Pending Review Christina Riot 24 views 3 comments Most recent by Andrée Starå Formulas and Functions
First post 04/07/20,Last post 04/26/20
Hi there. I have a column that is concatenate of many columns and I want to find duplicates within that column. I have used the countif to find duplicates many times but have never had an issue. I'm just checking a box if there is more th…
Formulas and Functions243
Christina Riot
Answered - Pending Review Sidonia Posteuca 32 views 3 comments Most recent by Andrée Starå Formulas and Functions
First post 04/10/20,Last post 04/26/20
Is it possible to link attachments to the appropriate row in another sheet. For example, if each row has an ID that is linked to another sheet. Any attachment that is in that primary sheet gets linked (crosses over to the attachment colum…
Formulas and Functions323
Sidonia Posteuca
• Accepted Answer Emma Smyth 13 views 5 comments Most recent by Andrée Starå Using Smartsheet
First post 04/24/20,Last post 04/26/20
Hi everyone! I have been reading some recently asked questions and haven't been able to find the solution to my question yet. I would like to set up an automation that 1 week after the current date is reached in a specific date field the r…
Using Smartsheet135
Emma Smyth
First post 04/20/20,Last post 04/26/20
I am building a Smartsheet that will track work items for a group. One of the ways I need to have work items added to the sheet is via email. I want this to be automatic (fully automated) so that no one has to open the mail account and cop…
Using Smartsheet246
• Answered - Pending Review mkilci 14 views 9 comments Most recent by Andrée Starå Premium Apps and Integrations
First post 04/10/20,Last post 04/26/20
Hello. I would like to build an app to display content from a smartsheet. I want the end users to have a simple to use app/ Web page where they can search, filter and display content in a firm factor. I know Microsoft Power apps have con…
mkilci
• smitzel99941 266 views 9 comments Most recent by Andrée Starå Using Smartsheet
First post 08/13/19,Last post 04/26/20
Hello, I'm trying to figure out how to have our dashboard update automatically when we work off of weekly periods. In other words, we are adding daily metrics that tally into weekly periods. Those weekly periods are collapsed and saved fo…
Using Smartsheet2669
smitzel99941
• Accepted Answer Jeana 13 views 2 comments Most recent by Genevieve P Formulas and Functions
First post 04/24/20,Last post 04/26/20
Can't figure out why this is returning Unparseable? Anyone have any ideas? I'm looking to count how many rows that do not have status of "Job Complete" and are due in next 7 days. =COUNTIFS([Request Status]:[Request Status]), &l…
Formulas and Functions132
Jeana
• Accepted Answer beth_linder28141 4 views 3 comments Most recent by Genevieve P Premium Apps and Integrations
First post 04/23/20,Last post 04/26/20
Has there been an enhancement yet for graphs to update automatically when data is added?
beth_linder28141
• Accepted Answer Bryson Isbell 58 views 3 comments Most recent by Genevieve P Formulas and Functions
First post 02/07/20,Last post 04/26/20
First post, pretty new to Smartsheet, need some assistance with a formula. I'm trying to Create a Sheet Summary formula to calculate the amount of Tasks completed within a month and quarter so I can represent that information as a graph in…
Formulas and Functions583
Bryson Isbell
• Answered - Pending Review LLaCosta 12 views 1 comment Most recent by Andrée Starå Using Smartsheet
First post 04/24/20,Last post 04/25/20
Is this scenario possible: As the owner of a sheet, I grant Editor access to 10 people. Of those 10 people, I want 7 of them to be able to edit anything in the sheet but I want to prevent 3 of them from being able to edit 3 specific column…
Using Smartsheet121
LLaCosta
• Answered - Pending Review Sarah Smith-Wright 14 views 1 comment Most recent by Andrée Starå Using Smartsheet
First post 04/24/20,Last post 04/25/20
HI there - attachments are not loading on my smartsheets. This occurs across multiple browsers. Everyone on my team is experiencing it, too. Can you please help to resolve?
Using Smartsheet141
Sarah Smith-Wright
• christy.thompson106676 177 views 13 comments Most recent by Andrée Starå Formulas and Functions
First post 10/10/19,Last post 04/25/20
Hi - I need a formula to update the status on the parent row based on status values in the child rows below.  I am wresting with this formula and hoping someone on here can point me in the right direction.  I found this post which is exact…
Formulas and Functions17713
christy.thompson106676
• Answered - Pending Review Mohammed Alolayan 18 views 2 comments Most recent by Andrée Starå Using Smartsheet
First post 04/24/20,Last post 04/25/20
Hi I have made a sheet to collect some important information in a sheet and i have got a message that I have reached cell limit of 200,000 for this sheet, So I would like to ask if Is it possible to increase the limitation in this sheet?
Using Smartsheet182
Mohammed Alolayan
• Answered - Pending Review ALAIN-STEPHANE 53 views 4 comments Most recent by ALAIN-STEPHANE Using Smartsheet
First post 02/08/20,Last post 04/25/20
Hi All , I have two concerns. 1 ) The first one is how to connect efficiently Smartheet to a SMS application so that when managing a project for example, a SMS is sent to some defined persons when a task is 100% completed. 2) My second…
Using Smartsheet534
ALAIN-STEPHANE
• Answered - Pending Review Surya Singh 12 views 2 comments Most recent by Andrée Starå Using Smartsheet
First post 04/23/20,Last post 04/25/20
Hello, can SmartSheet host the URL for the cusom message or do I have to host and provide the URL? I was thinking it would be simpler if I just provided the verbiage and somehow you would redirect the user to that page before allowing them…
Using Smartsheet122
Surya Singh
• annie.maclellan56501 128 views 6 comments Most recent by Andrée Starå Using Smartsheet
First post 08/01/18,Last post 04/25/20
Is there a way to add a contact group to the dropdown list in a contact list column?
Using Smartsheet1286
annie.maclellan56501