-
Is it possible to have a report that is editable by people who dont have access to the source sheet?
Within the company I work for we have a source sheet with all our projects in. We need to be able to enable external (sub contractors) people to sign a report which auto fills information into the source sheet. (check boxes) This is so we have an audit history of them accepting projects. However, we not not want them to be…
-
Scrolling on a mac
Having a problem using a mouse to scroll down on a sheet in grid view using Safari browser on a mac. When I use the mouse to try to scroll up or down, it jumps me to a different screen. I have to click on the sheet and use the arrow keys to move around. This is very frustrating and causes me to avoid using Smartsheet,…
-
Use case / best practice how to build a resume form?
Hi there, this is my first post, and I am confident it will be a lucky one :D I want to build a form where external users (freelancer vendors) to input their resume data. Basically, they will receive a link to SmartSheet form where to input: personal info, experience, education, languages, technical & soft skills etc. Do…
-
Text not wrapping in Form
Hello, I am working in a smartsheet form. The text is not auto wrapping and instead is cutting words off. How do I correct?
-
How to manually delete Update requests that were sent by automation
When I open the log of Update requests, the option that is available to me to impact the Requests is limited to "Details". The options to "Delete" or "Edit" the Request is greyed out. I am the owner of the sheet. Now that we are preparing to go live with the sheet, I would like to remove the Update requests related to our…
-
Gathering data from 1000 sheets
Hello, i have this question: We have more then 1000 sheets with some project progress calculated in certain cell. Then we have one master tracking sheet with 1 line = 1 project. What i need is: Link this progress number from each sheet to every corresponding line Use that number for further calculations (which is not a…
-
Creating separate charts on a dashboard using the same report
Hello, Our team created a large sheet that collects data from Smartsheet forms that vendors complete. We then score those answers and send them to a Vendor Vetting report that only shows the scores and some basic additional info (fake data below). Is there a way I can create charts in a dashboard that only shows data based…
-
Auto population of words like in Excel
In Excel you can type a word, then go to the cell below and start to type the word again and it will automatically populate that cell with the same word above. University Unive - then it will fill in the rest of the word University I can't seem to make that work in Smartsheet?
-
Dependency based on prior line item with auto change when sorting?
Hello! New user to Smartsheet here; was wondering if there is a way to make tasks change dependency automatically as they are moved in the sheet. Specifically, I manage team where all members can close similar action items, and I have a queue of open actions. I want the ability to drag an open action into someone's queue…
-
Automation - Alerts for External Users
Hi there, I am having trouble with the automation in Smartsheet, specifically around alerting external users. The automation is for an issue control sheet, with automation that if "status" = resolved, alert user who logged (via form) with custom message. The automation works soundly, and when I test it with an internal…
