Using Smartsheet

Cell Linking Modified Date

stephanie.blake67241 41 views 4 comments 0 points Most recent by Andrée Starå 03/15/20

First post 08/06/19,Last post 03/15/20
I have a main sheet I use to gather information from underlying, linked sheets. Is there a way to get my base sheet to update with modified by date of those underlying sheets? (i.e. I have one sheet I use to roll up information from more d…
Using Smartsheet414
stephanie.blake67241
Conditional Formatting Grid View v. Calendar View

alwayslearning 43 views 5 comments 0 points Most recent by Andrée Starå 03/15/20

First post 08/04/19,Last post 03/15/20
I am new to SmartSheet. I have a column called "Conference Call." I set a conditional format that appears correctly in the grid view but not in the calendar view. I'd like the word font/color to appear the same in the calendar…
Using Smartsheet435
alwayslearning
Project Management - Resource AllocationAccepted Answer

Accepted Answer J Tech 19 views 3 comments 0 points Most recent by Andrée Starå 03/15/20

First post 03/11/20,Last post 03/15/20
Hi, Is there a way when allocating a resource to be able to set what days they work, e.g. On Monday / Tuesday / Wednesday?
Using Smartsheet193
J Tech
Sum Based on ValueAccepted Answer

Accepted Answer Beronica Muller 23 views 12 comments 0 points Most recent by Andrée Starå 03/15/20

First post 03/12/20,Last post 03/15/20
Hello, I am trying to use a formula to calculate the number of inquiries created based in a particular column. For example, I am trying to get the total number of inquiries that have been assigned to the responsible area NAOPS.Priority. …
Using Smartsheet2312
Beronica Muller
Smartsheet LimitationAccepted Answer

Accepted Answer Cheng Kwee Chua (Hotmail) 14 views 5 comments 0 points Most recent by Andrée Starå 03/15/20

First post 03/15/20,Last post 03/15/20
Hi everyone, I understand Smartsheet have the following Limitations (plus many others). Can someone please clarify if the 10MB includes attachments ? The file cannot exceed 10 MB Up to 5,000 rows, 200 columns, or 200,000 cells can be impo…
Using Smartsheet145
Cheng Kwee Chua (Hotmail)
Custom Domain?Answered Question

Answered Steve C 26 views 1 comment 0 points Most recent by Andrée Starå 03/15/20

First post 03/14/20,Last post 03/15/20
Hi there, I am an enterprise user with Smartsheet. I would like to setup a custom domain for my clients to access their Smartsheet view. For example: portal.mydomain.com They will be able to login using their custom credentials and acce…
Using Smartsheet261
Steve C
Using Forms to enter data - worksheet not updating

Cheng Kwee Chua (Hotmail) 14 views 1 comment 0 points Most recent by Andrée Starå 03/15/20

First post 03/15/20,Last post 03/15/20
Hi there, I am currently evaluating Smartsheet using a trial account and created a form to capture data from a Worksheet in Smartsheet. When I tested the form, the data filled-in do not show up in the Worksheet. I am not sure if that it…
Using Smartsheet141
Cheng Kwee Chua (Hotmail)
2 Forms, One Sheet, Help with requesting info from 2 different sources to 1 lineAnswered Question

Answered Nicky Urso 10 views 1 comment 0 points Most recent by Andrée Starå 03/14/20

First post 03/14/20,Last post 03/14/20
Hi, Is this possible? I am creating a vendor repository. Business owner will initiate The first few fields and a notification will prompt info from the vendor to complete. I want the info from the vendor to updated in the line created by …
Using Smartsheet101
Nicky Urso
Inconsistency in how contacts are displayed across sheetsAnswered Question

Answered Saurabh Maheshwari 35 views 4 comments 0 points Most recent by Alejandra 03/13/20

First post 03/12/20,Last post 03/13/20
Hi, I have noticed inconsistency in how same contact is displayed differently across sheets. In one sheet it is displayed as name whereas in other sheet its displayed as email id. I understand that in one sheet where its displayed as name,…
Using Smartsheet354
Saurabh Maheshwari
different color per row

Netanel yosef 149 views 14 comments 0 points Most recent by Paul Newcome 03/13/20

First post 11/04/19,Last post 03/13/20
how i can to do an automatic different color per row ? see example from excel: (Image)
Using Smartsheet14914
Netanel yosef
How to share data with external users and allow some editingAccepted Answer

Accepted Answer LisaB:-) 22 views 6 comments 0 points Most recent by Andrée Starå 03/13/20

First post 03/12/20,Last post 03/13/20
Hi, I'd like to share a sheet with an external user, and allow them to edit update one column only. If I produce a report, then that will mean they would have to have access to the underlying sheet, which will contain information I don't w…
Using Smartsheet226
LisaB:-)
Hyperlink in a cellAnswered Question

Answered Scott Rae 16 views 2 comments 0 points Most recent by Sean Morgan 03/13/20

First post 03/12/20,Last post 03/13/20
Hi there, I'm looking at hyperlinking a sheet into a cell. What are the limitations of doing this? (if the sheet is moved or/does the hyperlink expire) Many thanks in advance Scott
Using Smartsheet162
Scott Rae
Average a column with zerosAnswered Question

Answered Scott Verduin 19 views 2 comments 0 points Most recent by Paul Newcome 03/13/20

First post 03/13/20,Last post 03/13/20
Hello, How do you average column and not include the cells with zeros in them. Value 1 Value 1 Value 1 Value 0 Value 1 This column will grow larger and larger as more form data comes in. Thank you
Using Smartsheet192
Scott Verduin
Report on Tasks due including HeaderAnswered Question

Answered Andre Drinkwater 18 views 2 comments 0 points Most recent by Paul Newcome 03/13/20

First post 03/13/20,Last post 03/13/20
Hi all, Can someone provide me a workaround here. I would like to run a report that lists all the tasks due to start in the next 5 days. But what I need is to include the Phase name, even though the Phase has already started. I have added …
Using Smartsheet182
Andre Drinkwater
Workflows are not triggering, is this an issue with smartsheet today only?Answered Question

Answered Felicia Wilson 17 views 1 comment 0 points Most recent by Andrée Starå 03/12/20

First post 03/12/20,Last post 03/12/20
My workflows are not triggering and I have not had any issues with them on previous days. Is there an issue with smartsheet workflows or a bug?
Using Smartsheet171
Felicia Wilson
Private Comments

MikeCorvin 59 views 6 comments 0 points Most recent by Andrée Starå 03/12/20

First post 11/07/19,Last post 03/12/20
I am trying to figure out if there is a way to make a Private Comment in Smartsheet? Let's say I have a Published Report that is viewable to anyone with the link; however, I want to make a comment on a line that I don't want anyone to be …
Using Smartsheet596
MikeCorvin
Is there a way to auto-hide columns based on the value selected from a drop down cell?Answered Question

Answered Nikki Hopper 18 views 1 comment 0 points Most recent by Andrée Starå 03/12/20

First post 03/12/20,Last post 03/12/20
I have a main grid with several columns and a webform that feeds into that grid. This tracker is used by my team to track several job "types" defined in one of the destination grid columns as "Large Project", Medium Pro…
Using Smartsheet181
Nikki Hopper
Managing contacts is frustrating

Subash Sitaraman 19 views 0 comments 0 points Started by Subash Sitaraman 03/12/20

First post 03/12/20,Last post 03/12/20
Is anyone else frustrated with the contacts management within smartsheet? If I import contacts or add them to "My Smartsheet Contacts" , I am unable to add them to groups. So I add them to group first (email only) but then som…
Using Smartsheet190
Subash Sitaraman
Hyperlinks in Reports

Ginger Mason 53 views 6 comments 0 points Most recent by Ramsay Zaki 03/12/20

First post 05/01/18,Last post 03/12/20
Hi, On the first day of each month, I send a report listing all documents published in the previous month. The report includes hyperlinks to each document's location. Before the recent Smartsheet changes to reports, I would email the re…
Using Smartsheet536
Ginger Mason
Test logAnswered Question

Answered Stanley Paul 23 views 4 comments 0 points Most recent by Michele Thomas 03/12/20

First post 03/09/20,Last post 03/12/20
Can someone provide some insight to creating a testing log? Either point me to an existing Smartsheet template set that can be massaged to fit my testing needs or have a test log template set that you are willing to share.
Using Smartsheet234
Stanley Paul
Smartsheet Dashboard published within MS Sharepoint 2016

Michele Deo 395 views 4 comments 0 points Most recent by Joshua Bowers 03/12/20

First post 03/21/18,Last post 03/12/20
I want to take a Smartsheet Dashboard that is interactive and put it as a web part within MS SharePoint 2016 site. I use the page viewer webpart and provide the web page link offered up when I publish the dashboard, but once I apply it, a…
Using Smartsheet3954
Michele Deo
Using a dashboard as shared by our account manager - users are getting errors belowAccepted Answer

Accepted Answer Qadeer Parekh 16 views 6 comments 0 points Most recent by Qadeer Parekh 03/12/20

First post 03/12/20,Last post 03/12/20
https://us.v-cdn.net/6031209/uploads/952/C658H10D4W96.jpg Multiple users are not SS users but that shouldn't matter since we are sharing a viewable link. Why would we get this error? Submitted a support ticket too and kind of urgent for us…
Using Smartsheet166
Qadeer Parekh
Presenting attachments on a report widget in a dashboard

mikoker 251 views 11 comments 0 points Most recent by Andrée Starå 03/12/20

First post 04/12/19,Last post 03/12/20
I'm looking for a way to present attachments when placing a report widget on a dashboard. It looks as if this column is not presented although it is on the source report. Anyone with a suggestion on how to do that?
Using Smartsheet25111
mikoker
Open Update Form fields - cannot edit all fieldsAnswered Question

Answered steven.nienaber105336 22 views 5 comments 0 points Most recent by Andrée Starå 03/12/20

First post 03/03/20,Last post 03/12/20
I have a Go Live date field that I want the recipient of my Send Update Request to be able to update. As shown in the pic below, it's not editable. The field in issue in the Smartsheet row to which this is linked is editable; i.e., not a…
Using Smartsheet225
steven.nienaber105336
View completed formAnswered Question

Answered Heather Holderness 30 views 4 comments 0 points Most recent by Andrée Starå 03/12/20

First post 02/26/20,Last post 03/12/20
A completed form fills into a smartsheet for me to view, however I would like to view the form itself with the fields filled in. Other than the notification email I receive that says the form has been completed, is there a way to view each…
Using Smartsheet304
Heather Holderness
Updating reports directly from a Dashboard/Portal?Answered Question

Answered Doug M 27 views 5 comments 0 points Most recent by Andrée Starå 03/12/20

First post 03/05/20,Last post 03/12/20
We use a dashboard to display 5 different reports (task lists for 5 users). I want the users to be able to update the fields in the report (e.g. % Complete) directly from the dashboard, instead of having to go into the report itself (and …
Using Smartsheet275
Doug M
Diabiling Automations

Jenna_Doucette 18 views 3 comments 0 points Most recent by Andrée Starå 03/12/20

First post 03/09/20,Last post 03/12/20
Is there an easier way to disable all automatons at once if I have 41 rather than going through each one??
Using Smartsheet183
Jenna_Doucette
When Sending a Row, Can Row Attachments be Visible?Answered Question

Answered J Jones 20 views 6 comments 0 points Most recent by Andrée Starå 03/12/20

First post 03/09/20,Last post 03/12/20
We are trying to use Smartsheet for Site Reports on Construction Sites. We are currently using forms for this as it seems like the most efficient method and allows easy attachment of images. Unfortunately it seems like when sending a row o…
Using Smartsheet206
J Jones
Different font in Gannt header exported to PDF

Mattias 30 views 3 comments 0 points Most recent by Andrée Starå 03/12/20

First post 12/02/19,Last post 03/12/20
Anyone else seen this? Not sure if it has been like this since the start or if its a new thing... Is there a setting to correct this? (Image)
Using Smartsheet303
Mattias
Can a workflow be designed to reference a data field in another sheet?

William Lafferty 22 views 4 comments 0 points Most recent by Andrée Starå 03/12/20

First post 03/06/20,Last post 03/12/20
I am playing with the idea of creating a master reference sheet and using that as a cross reference for another. For example, I would have a master list of all leaders by geography. I am curious if I can devise a workflow based on select…
Using Smartsheet224
William Lafferty

Using Smartsheet

Using Smartsheet

Discussion List