Using Smartsheet

If I would like to share a Gantt view sheet with non users for a meeting can I just provide URL?Question

Answered - Pending Review Alison Antisz 16 views 1 comment 0 points Most recent by Paul Newcome 08/03/20

First post 08/03/20,Last post 08/03/20
If I would like to share a Gantt view sheet with non users for a meeting can I just provide URL? Or do they have to become SS users and I have to add them as viewer access to the sheet?
Using Smartsheet161
Alison Antisz
Smartsheet Wont let me save or taking forever to saveQuestion

Answered - Pending Review Michael Heisler 18 views 6 comments 0 points Most recent by Michael Heisler 08/03/20

First post 07/27/20,Last post 08/03/20
Hello, I am working on a big project with 70,000 rows so I am splitting it into multiple projects of 8000 rows which has a total cell count of 464,000 I believe which is below the 500,000 limit. I put data in 20 columns all the way down b…
Using Smartsheet186
Michael Heisler
3 Conditions FormulaAccepted Answer

Accepted Answer Jennifer Flanagan 17 views 6 comments 0 points Most recent by Jennifer Flanagan 08/03/20

First post 08/02/20,Last post 08/03/20
I want to have a flag turn red if 1. A task is considered a milestone, 2. The Planned End Date is today or before, and 3. The task is not done. The below formula is not working: =-IF(AND([Is Milestone]@row, 1, [email protected], 0, [Planned End …
Using Smartsheet176
Jennifer Flanagan
Automatic Deletion

Lboud 217 views 4 comments 0 points Most recent by Mike Yeats 08/03/20

First post 09/05/19,Last post 08/03/20
I am looking for a way to set up an automation for deleting rows in a sheet. My firm is unwilling to go through security testing right now and is wary of putting sensitive data on Smartsheet, but is wanting to use a form to collect the dat…
Using Smartsheet2174
Lboud
Search for a Number from a Master Sheet across Multiple Sheets and Return Sheet NameQuestion

Answered - Pending Review KathrynLindsay 27 views 2 comments 0 points Most recent by KathrynLindsay 08/03/20

First post 07/31/20,Last post 08/03/20
I have a Master Sheet tracking new enquiries by a unique number, once they are logged here they move between several sheets moving through our divisions until they are finalised. I would like to be able to have a "tracking" colum…
Using Smartsheet272
KathrynLindsay
Custom Date Range bugAccepted Answer

Accepted Answer gparadis 21 views 8 comments 0 points Most recent by Isaac Jose 08/03/20

First post 07/15/20,Last post 08/03/20
Hi, I am trying to export our office task table for ongoing projects with a custom date range from now to end of year 2020. The exported sheet always shows task scheduled in 2021, 2022, ... Is there a bug with the custom date range functi…
Using Smartsheet218
gparadis
Gantt chart that overlays multiple projects

DanielleElise 209 views 2 comments 0 points Most recent by James Robitaille 08/02/20

First post 02/06/19,Last post 08/02/20
We are trying to see if there is a way to view a Gantt chart that overlays projects that are in multiple sheets so that we can make sure our department is not spreading itself too thin/which projects have overlapping timelines. Is there a …
Using Smartsheet2092
DanielleElise
How do I change session timeouts?Question

Answered - Pending Review Christer 11 views 1 comment 0 points Most recent by Genevieve P 08/02/20

First post 08/01/20,Last post 08/02/20
My sessions keep timing out so that I have to sign in again even if it's been less than a week since I last used smartsheet.com. Having the timeout shorter than 30 days is definitely a hindrance for having an optimal experience but I haven…
Using Smartsheet111
Christer
Version Control of Project Plans/Sheets?

Ivana 443 views 4 comments 0 points Most recent by Riyaz M 08/02/20

First post 11/04/19,Last post 08/02/20
Hello, I am wondering if there is a way in Smartsheet to version control the sheets. Basically, we are using each sheet as an individual project plan. However, as projects progress, the plan will (usually) slip and/or have to be updated, s…
Using Smartsheet4434
Ivana
Proofing - Office Documents

Michael Lockwood 159 views 9 comments 0 points Most recent by Douglas Jerum 08/02/20

First post 10/14/19,Last post 08/02/20
Is there a plan to include Office documents such as Word Docs or PowerPoints into the functionality of proofing without having to convert them to PDF for uploading them?
Using Smartsheet1599
Michael Lockwood
Contact ListQuestion

Answered - Pending Review Nigel Michell 42 views 2 comments 1 point Most recent by Nigel Michell 08/02/20

First post 07/31/20,Last post 08/02/20
Hi Another newbie question! I have updated the details for a contact in Accounts / My Smartsheet Contacts, eg I change the details for 'Nigel' to 'Nigel M' . Likewise, I also deleted a Contact. However, when I go back to my Project, the A…
Using Smartsheet422
Nigel Michell
There was an issue connectingQuestion

Answered - Pending Review Chyslain E Nsufeu 33 views 1 comment 1 point Most recent by Гайко П 08/02/20

First post 07/31/20,Last post 08/02/20
Hi , I am using smartsheet-csharp.sdk version 2.101.0.0. When I consume my web application on my laptop and on a UAT, everything are working fine but I am having problem in production. The utility returning "There was an issue connec…
Using Smartsheet331
Chyslain E Nsufeu
Internal Stock System for businessQuestion

Answered - Pending Review Michelle B 27 views 1 comment 0 points Most recent by Matt Johnson 08/02/20

First post 07/27/20,Last post 08/02/20
Good day, I am currently building a internal Stock system for our company, but I am running into a couple of issues. I need to assign stock to various technicians. I am currently doing this by moving the stock item row in the Technician…
Using Smartsheet271
Michelle B
workspaces and templates not appearing in ZapierAccepted Answer

Accepted Answer brianmorgs 12 views 6 comments 0 points Most recent by Andrée Starå 08/01/20

First post 07/28/20,Last post 08/01/20
I am the owner of the workspaces and templates - (File) Admittedly I do not know if this in on the Zapier side, but I seem to be missing several options when using Zaps to create new sheets from a template. The system does not see the d…
Using Smartsheet126
brianmorgs
Workflow only showing column headers not dataQuestion

Answered - Pending Review Pamela Wagner 14 views 5 comments 0 points Most recent by Andrée Starå 08/01/20

First post 07/29/20,Last post 08/01/20
I have an invoice that has 2 levels of approval on it but when I get a test email from the workflow I see that it only has the the column headers on it but no way to see the actual data without going out of the view request and into the sh…
Using Smartsheet145
Pamela Wagner
Populating Drop Down list from column of entries in another sheetAccepted Answer

Accepted Answer Dennis Hoshield 34 views 4 comments 0 points Most recent by Andrée Starå 08/01/20

First post 07/01/20,Last post 08/01/20
I would like to set up a single call log, where I could put information into a sheet that would have a cell with a pull down that would populate with unique client names (or ID's) from a column in another sheet. So, when I put a log entry…
Using Smartsheet344
Dennis Hoshield
Show both parent and child rows in report, even if the Parent doesn't meet the criteriaQuestion

Answered - Pending Review Netanel yosef 133 views 11 comments 0 points Most recent by Andrée Starå 08/01/20

First post 02/09/20,Last post 08/01/20
i have sheet with parent and children tasks and in my report i want to see the children tasks with the parent row. when i try to do this i show only the children.. there is any way to show chldren tasks with parents in report>??
Using Smartsheet13311
Netanel yosef
Mobile forms link is requesting login/free trial even though security is not enabled.Question

Answered - Pending Review Christianne Schrobilgen 27 views 9 comments 0 points Most recent by Andrée Starå 08/01/20

First post 07/13/20,Last post 08/01/20
Hello, I've created a form and have the security setting disabled so that anyone can submit, from anywhere. It works fine on desktop, but if trying to submit via mobile, it is sending users to an "explore what Smartsheet can do" …
Using Smartsheet279
Christianne Schrobilgen
Combining Two Sheets into a Report

latsyrcg3 617 views 11 comments 0 points Most recent by Andrée Starå 08/01/20

First post 05/13/19,Last post 08/01/20
I have two task lists with slightly different columns, but there are some overlap - like status, completion date, & targeted completion date. I would like to run a report or some how combine all the tasks into one report/view/sheet - w…
Using Smartsheet61711
latsyrcg3
Constantly being kicked out of Smartsheet account and (saved work lost)!Question

Answered - Pending Review awollam105821 12 views 1 comment 0 points Most recent by Andrée Starå 08/01/20

First post 07/31/20,Last post 08/01/20
Over the past few weeks, I am frequently being kicked out of Smartsheet while in the middle of doing work. Saved (either auto save or manually saved) work are lost when I get back in. What is the fix for this? I asked other users that sha…
Using Smartsheet121
awollam105821
Calculated % CompleteQuestion

Answered - Pending Review Nigel Michell 15 views 2 comments 0 points Most recent by Nigel Michell 07/31/20

First post 07/31/20,Last post 07/31/20
We use three fields to indicate effort: Planned Effort Actual Effort Remaining Effort I created a column called '% Comp" with the following formula: =IF(ISBLANK([Remaining Effort (Hours)]@row), 0, IF([Remaining Effort (Hours)]@row = 0…
Using Smartsheet152
Nigel Michell
Free collaborators cannot see contentQuestion

Answered - Pending Review Alexander Gerasimenko 16 views 3 comments 0 points Most recent by Andrée Starå 07/31/20

First post 07/31/20,Last post 07/31/20
I wonder if anyone else experience this issue and if Smartsheet changed access terms for Free collaborators. I recently created simple smartsheet and shared with 2 people, but they only see empty sheet. no content. any ideas ? how do i lo…
Using Smartsheet163
Alexander Gerasimenko
VLOOKUP Based on Name and Date

Art Kliatchko 12 views 2 comments 0 points Most recent by Paul Newcome 07/31/20

First post 07/31/20,Last post 07/31/20
Hello, I am having some trouble with a query allowing me to look up values based on the name of an individual AND within a certain date range. The data table is weekly updated with new values, and has multiple fields, including name, date …
Using Smartsheet122
Art Kliatchko
Why does Smartsheet not bring all columns of excel file when the document is imported?Question

Answered - Pending Review Alison Antisz 11 views 2 comments 0 points Most recent by lewis hamilton 07/31/20

First post 07/30/20,Last post 07/31/20
Why does Smartsheet not bring all columns of excel file when the document is imported? I noticed that the the first 7 columns came over fine but the next 7 did not appear at all. Some of the omitted columns have drop down menus and formu…
Using Smartsheet112
Alison Antisz
Frequent "Aw Snap" errors in one of our sheets when trying to saveQuestion

Answered - Pending Review SammyMorey 9 views 1 comment 0 points Most recent by Andrée Starå 07/31/20

First post 07/31/20,Last post 07/31/20
Hey community - we are constantly getting Aw Snap errors when we are trying to update and save one of our sheets. It does have a few conditional formats, but not many and same with automations. It is quite a large sheet with 5563 rows, bu…
Using Smartsheet91
SammyMorey
Card View for Reports

Jess Evers 808 views 14 comments 0 points Most recent by Mat Watson 07/31/20

First post 01/17/19,Last post 07/31/20
All, Has there been any progress with adding card view to reports? Has this been an approved feature and scheduled for a release? Our company has been pushing a move to JIRA because of the gap with smartsheet in allowing our teams to vi…
Using Smartsheet80814
Jess Evers
Publish calendar excluding summary tasksQuestion

Answered - Pending Review ilene_healy68056 17 views 1 comment 0 points Most recent by Ben G 07/30/20

First post 07/30/20,Last post 07/30/20
I would like to publish my calendar as read only "for anyone with a link" without showing the summary tasks. I have this set up correctly on the calendar settings, but when I publish all of the summary tasks display. Is this po…
Using Smartsheet171
ilene_healy68056
Does anyone have experience geocoding addresses within Smartsheet?Question

Answered - Pending Review Allie McDougall 12 views 1 comment 0 points Most recent by Ben G 07/30/20

First post 07/30/20,Last post 07/30/20
We are looking to geocode street addresses that are entered into Smartsheet.
Using Smartsheet121
Allie McDougall
Importing MS Project files to Smartsheet

Roy Turner 603 views 10 comments 1 point Most recent by Bridget Ley 07/30/20

First post 06/22/18,Last post 07/30/20
When I import my MS project files into smartsheet it appears to lose information and change some of my start and finish dates. I have project but others in my company use smartsheet to view the schedules but the dates they are seeing are d…
Using Smartsheet60310
Roy Turner
How does SimPRO compare to Smartsheet?Question

Answered - Pending Review TeeM 15 views 1 comment 0 points Most recent by Ben G 07/30/20

First post 07/29/20,Last post 07/30/20
Has anybody had any experience with SimPRO? I have a client that is currently using SimPRO who I want to convert to Smartsheet. They are fairly happy with SimPRO as it appears to be a total Business Management solution including Project M…
Using Smartsheet151
TeeM

Using Smartsheet

Using Smartsheet

Discussion List