-
How can I have someone see only their data on a report without access to base sheet?
I would like something where people will fill out a form about their retirement plans and that info goes to a sheet. On that form, before answering the last question, i would like them to click a link and view only their previous entries. I don't want them to see everyone's entries because it's confidential. Here's what…
-
How do i create a report that only pulls in checked boxes from multiple rows?
I am trying to pull in only 3 rows into a report using a checked box feature, but when I create the report, it still pulls in 1000+ rows of information that I do not need to go into a chart on my dashboard. How do I get it to truly only pull in those 3 rows of information so that I can make an easy to read chart on a…
-
Gant Chart - How can we track the planned versus actual LAG days?
Hello Everyone, I appreciate any help on this topic. I am starting a study of our construction efficiency looking at our last 30 projects. One of the data points we are digging into is our "planned" LAG days between certain trade partners. (LAG days are inside of our defined working days, and do not include non-working…
-
Drop Down List (Report editing) not validating 00
Due to the lack of a Time Data Type I am using the Drop-Down field type for a preset selections of quarter hours (00, 15, 30, 45). The selection process on the form and sheet handles this 20th century work-around fine. However, when editing a row in the report I get the error, "This column is restricted to dropdown…
-
How can I recover deleted rows?
Greetings, I regret to inform you that we had an employee go rogue with our company. He deleted 6 files as he left. These files represent thousands of hours spent. Can we recover them somehow, please?
-
How to showing both Contact name and email when exporting to excel or report from Contact list cell
I am trying to export a Smartsheet tracking sheet for an audit request, when I do the contact cells displays the person name only. Can I export showing both the name and the email address?
-
All Update requests not on home page?
HI All, I might have just missed it in the threads, but used to be able to see the update requests for me and that I had sent to others on the home page. Can't see them now, are they somewhere else?
-
Sheet Summary Report - Exports in Completely Random Order
Hi - I have created a sheet summary report, in which the projects are sorted by a completion date. When exporting to PDF, the order is completely random and has 0 logical sense, not matching any other order that would exist. Not sure why the export can't match the sort input, or why grouping doesn't even matter when…
-
Adding details to a calendar
I have a simple sheet with primary column and date that will show in the calendar view - is there a way of showing notes and owner on the calendar?
-
Established Automations Suddenly Failing
Thank you for taking time to read my question! We have been using Smartsheet for over a year. We have several automations (triggers) that are well-established and that have not been edited. These automations trigger rows to be copied to other sheets, which are a very important part of our workflow. Lately, and often, the…