Using Smartsheet

Add new row, calculated field not updatingAccepted Answer

Accepted Answer Pamb10 33 views 15 comments 0 points Most recent by Andrée Starå 03/20/20

First post 03/13/20,Last post 03/20/20
I have a sheet that uses Hierarchy (on month) and is displayed in descending sort order. I have one calculated field that should be automatically calculated when a new row is added. When the person who will be entering data adds a new row,…
Using Smartsheet3315
Pamb10
One form into multiple entriesAnswered Question

Answered Sidonia Posteuca 46 views 7 comments 0 points Most recent by Andrée Starå 03/20/20

First post 02/03/20,Last post 03/20/20
Can I set up a form to populate multiple entries into one sheet? For example, I have a training log in which a form is filled out and entered into the log. However, many training's have multiple attendees in which all the training info is …
Using Smartsheet467
Sidonia Posteuca
Moved: Where is the COVID-19 dashboard

Closed Stephanie Boulanger 1 view 0 comments 0 points Started by Stephanie Boulanger 03/20/20

First post 03/20/20,Last post 03/20/20
This discussion has been moved.
Using Smartsheet10
Stephanie Boulanger
Resource View Missing Resource Information After License Purchase / ActivationAnswered Question

Answered Cheng Kwee Chua 16 views 5 comments 0 points Most recent by Andrée Starå 03/20/20

First post 03/19/20,Last post 03/20/20
Hello everyone, I just complete the purchase of Smartsheet and received the license activation last night. Prior to the purchase, I used the trial version to create a bunch of Project Plan / Sheet as well as assigned resources to them. …
Using Smartsheet165
Cheng Kwee Chua
Calendar View on Dashboard

NBudd 597 views 4 comments 0 points Most recent by Andrée Starå 03/20/20

First post 02/13/19,Last post 03/20/20
Hello! I created a master calendar through a report. I added the report to a dashboard, but the calendar view is not showing. How do I fix this? Thanks!
Using Smartsheet5974
NBudd
Change background color of FormsAnswered Question

Answered alifarhan82 16 views 1 comment 0 points Most recent by Andrée Starå 03/20/20

First post 03/19/20,Last post 03/20/20
I have created a form that is by default Blue Color. I need to change the color / background of the FORM and add logo. The help says we should be able to do that but there is NO option. Can anyone please help? I have enterprise access. …
Using Smartsheet161
alifarhan82
Exclude A Smart Sheet in Project Resource ViewAnswered Question

Answered Julie Xu 15 views 1 comment 0 points Most recent by Andrée Starå 03/20/20

First post 03/19/20,Last post 03/20/20
I saved my current SmartSheet and renamed it as backup, then continue to work on my SmartSheet. Now the Project Resource View shows resources conflict, because the same resource is 100% allocated in the current SmartSheet and the backup Sm…
Using Smartsheet151
Julie Xu
Moved: How are you using Smartsheet to help you homeschool during COVID-19 closures?

Closed Stephanie Boulanger 1 view 0 comments 0 points Started by Stephanie Boulanger 03/19/20

First post 03/19/20,Last post 03/19/20
This discussion has been moved.
Using Smartsheet10
Stephanie Boulanger
Distance of new row from Smartsheet formAccepted Answer

Accepted Answer Jörg Schmidt Novum Hospitality 12 views 1 comment 0 points Most recent by Paul Newcome 03/19/20

First post 03/19/20,Last post 03/19/20
after filling out a form and sending it the data appear automatically in a new row. Unfortunately, the distance between the last and the new entry is arbitrarily different. Sometimes there are only a few (3-4) rows and sometimes up to 10…
Using Smartsheet121
Jörg Schmidt Novum Hospitality
Smartsheet Dashboards for eLearning

rcaroway 18 views 0 comments 0 points Started by rcaroway 03/19/20

First post 03/19/20,Last post 03/19/20
I LOVE Smartsheet dashboards! Actually, I love Smartsheet, PERIOD. As an educator, I am always looking for ways to increase learner engagement and improve the learner’s overall experience when completing a course. Many times Learning M…
Using Smartsheet180
rcaroway
Simple multiplying formula question

Al W 157 views 24 comments 0 points Most recent by Genevieve P 03/19/20

First post 12/11/18,Last post 03/19/20
I am looking for a simple formula to multiply [Quantity] times [Cost] only if there is data in the quantity cell. Currently the [total] column fills with $0.00 if there is no data in these columns. The "HELP" page is not clear to…
Using Smartsheet15724
Al W
Limitations to a sheet?Accepted Answer

Accepted Answer Sean Murphy 18 views 26 comments 0 points Most recent by Paul Newcome 03/19/20

First post 03/18/20,Last post 03/19/20
Hello, I'm in the process of automating a tracking sheet, and it will no longer allow me to copy and paste the formulas into the rows- see screen shots below- it stops at row 1400 The formulas are: =IF(ISDATE(Start1375), "Complete&quo…
Using Smartsheet1826
Sean Murphy
How do I use 10000 feet? Is it available?

Jef Forward 15 views 1 comment 0 points Most recent by Andrée Starå 03/19/20

First post 03/19/20,Last post 03/19/20
Hello - I am interested in this approach - but I can only find (1) video. Is this even available? How do I start using it? Thanks, Jef
Using Smartsheet151
Jef Forward
How do I view the list of Support tickets I have submittedAnswered Question

Answered Cheng Kwee Chua 14 views 3 comments 0 points Most recent by Genevieve P 03/19/20

First post 03/19/20,Last post 03/19/20
Hello everyone, being a newbie on submitting Support Ticket, I was wondering if anyone can help confirm where I can view the list of tickets I have submitted to Support - hopefully with the status as well. Anyone have experience in terms o…
Using Smartsheet143
Cheng Kwee Chua
Why does 0 Stock at the top of the chart on Stock column charts?Answered Question

Answered jpagan03101416 19 views 5 comments 0 points Most recent by Paul Newcome 03/19/20

First post 03/18/20,Last post 03/19/20
The graph below are from the same data source but for a reason in the first one stacked column charts 0 values are placed at the top making it impossible to see the value while stacked bars charts does not. https://us.v-cdn.net/6031209/up…
Using Smartsheet195
jpagan03101416
Dependencies and SubtasksAccepted Answer

Accepted Answer Eid E. Eid 47 views 12 comments 0 points Most recent by Genevieve P 03/19/20

First post 03/17/20,Last post 03/19/20
Dear All, Hope you are all safe and in good health. Can anyone tell me where I can find some good explanation about how dependencies work with tasks/subtasks? Whenever there is a main task with say 3 sub-tasks, I can see that we can set …
Using Smartsheet4712
Eid E. Eid
Summing up the values in a rowAnswered Question

Answered BESP10 10 views 1 comment 0 points Most recent by Zachary Mitchell 03/19/20

First post 03/19/20,Last post 03/19/20
Hi, How do we sum up the total value of numbers in cells in a row? Everytime we add a new value in the row we want a total https://us.v-cdn.net/6031209/uploads/983/YXCMGL13CQJY.jpg
Using Smartsheet101
BESP10
Cross Reference Cell limit

Joan Smith 16 views 1 comment 0 points Most recent by Genevieve P 03/19/20

First post 03/18/20,Last post 03/19/20
Hello, is there any news on increasing the 25000 cell limit for cross referencing?
Using Smartsheet161
Joan Smith
Option to make a report editable when embeddingAccepted Answer

Accepted Answer Katye Reed 16 views 5 comments 0 points Most recent by Paul Newcome 03/19/20

First post 03/18/20,Last post 03/19/20
Currently, when I got o publish my report, the only option is as read only. All of my sheets and dashboards are editable - is it possible to do this with a report? Thank you for the assistance!
Using Smartsheet165
Katye Reed
Unwanted release of a sheet when starting conversation from a rowAccepted Answer

Accepted Answer Jörg Schmidt Novum Hospitality 12 views 1 comment 0 points Most recent by Genevieve P 03/19/20

First post 03/18/20,Last post 03/19/20
After starting a conversation the recipient is free to see the whole sheet (when they press blue button "change to sheet") although I did not make a general release. Is there a way to restrict the view?
Using Smartsheet121
Jörg Schmidt Novum Hospitality
Form not updating the WorksheetAnswered Question

Answered Cheng Kwee Chua 13 views 2 comments 0 points Most recent by Andrée Starå 03/19/20

First post 03/19/20,Last post 03/19/20
Hello everyone, I created a Form from an Excelspreadsheet I imported into Smartsheet - it's an issue tracking list. I can complete the Form data but the information entered in the form do not seems to appearing in the Worksheet itself. …
Using Smartsheet132
Cheng Kwee Chua
*NEW: Proofing using ReportsAccepted Answer

Accepted Answer amontemayor 100 views 24 comments 1 point Most recent by Geoff Baker 03/18/20

First post 10/01/19,Last post 03/18/20
The new Proofing capability is something we would like to implement in our department, but we are having issues with accessing this in Reports. We see that Proofing can be done in the main smart sheet, but our Artists access new design req…
Using Smartsheet10024
amontemayor
How can I embed a link within a text in a widget?Answered Question

Answered Gabrielle Bastos 11 views 1 comment 0 points Most recent by Andrée Starå 03/18/20

First post 03/18/20,Last post 03/18/20
I would like to create a body paragraph and within it include a link within one of the words. This hyperlink will either be referencing another sheet on smartsheet or a URL.
Using Smartsheet111
Gabrielle Bastos
how can I organize my workspaces into foldersAnswered Question

Answered Lori Cross 17 views 3 comments 0 points Most recent by Andrée Starå 03/18/20

First post 03/18/20,Last post 03/18/20
how can I organize my workspaces into regional folders
Using Smartsheet173
Lori Cross
I want sync a field across multiple sheet, being able to edit it from any of those sheetsAnswered Question

Answered Rebecca Larkin-Martinez 30 views 5 comments 0 points Most recent by Rebecca Larkin-Martinez 03/18/20

First post 03/13/20,Last post 03/18/20
Use case. 4 sheets Intake Sheet, Prioritization sheet, Resource sheet & Overall Status Sheet When a project is requested it is automatically added to the "Intake" sheet through the form. Status field is New. When we agree th…
Using Smartsheet305
Rebecca Larkin-Martinez
Multiple Update Requests In One Email

Jack C 73 views 6 comments 0 points Most recent by Manuel Seubert 03/18/20

First post 09/03/19,Last post 03/18/20
Greetings - I currently have employees getting multiple update requests in one email. Please see the attached screenshot for an example. I am needing these to come thru as individual emails and not multiple update requests grouped into o…
Using Smartsheet736
Jack C
Examples for Custom Welcome Page and Custom Help PageAnswered Question

Answered Christine Rosenberg 32 views 5 comments 0 points Most recent by Andrée Starå 03/18/20

First post 03/11/20,Last post 03/18/20
I have read the help articles for enterprise customers on how to work with branding, and I understand, that I can add an URL with a customized welcome page and Help Page. However, I am very interested in seeing examples of good /best prac…
Using Smartsheet325
Christine Rosenberg
Best Workflow for tracking tasks and reportingAccepted Answer

Accepted Answer Jeana 89 views 7 comments 0 points Most recent by Andrée Starå 03/18/20

First post 03/17/20,Last post 03/18/20
I am using Smartsheet to accept requests (using a Form) to upload a video and get captions generated then share the links and other details with the requestor once the tasks are completed. This process involves several steps over a period …
Using Smartsheet897
Jeana
What is the effective approach to Group Management and ContactsAnswered Question

Answered Subash Sitaraman 18 views 6 comments 0 points Most recent by Subash Sitaraman 03/18/20

First post 03/17/20,Last post 03/18/20
i would like to have a contact with name. I need Groups so have to add contacts via Group Management else it won't allow me to add a contact from "My Smartsheet Contacts" Within Groups, I can either paste all emails or add one by…
Using Smartsheet186
Subash Sitaraman
Sorting IssuesAccepted Answer

Accepted Answer BTMarketingOps 14 views 2 comments 0 points Most recent by BTMarketingOps 03/18/20

First post 03/18/20,Last post 03/18/20
I have a column set up as a multi-select drop down with the numbers 1-30 and the word Carry Over as well. I understand that the sort function will sort on the first option which will always be the numbers but what I have an issue with is w…
Using Smartsheet142
BTMarketingOps

Using Smartsheet

Using Smartsheet

Discussion List