-
Automated Update Request Form Changes
I have built a tasklist. It is set up with a grant name being the primary field. We do monthly update requests via a form request. The form request is going to the resource name for the grant task. When the resource name receives their request, the forms are in grant order and not due date order. We would like the…
-
Dynamic SmartSheets an Option?
First-time poster and amateur SmartSheet user here. I have an existing Excel spreadsheet for our association's Marketing Schedule. Each month has a row and each marketing medium (newsletter, magazine, social media, online ad, etc.) has a column where I list all of the programs and services that will be featured in that…
-
REFRESH A SHEET
I linked two sheets (A and B) On sheet A are the name of customers from all country with other informations about them. Sheet B is the active sheet, I choose a country in a cell with a dropdown list. On other cells, I use VLOOK link to the dropdown list cells. Finally, by choosing a country name in the drowdown list I have…
-
IF and VLOOKUP?
Hi I'm not sure if should I use IF and VLOOKUP or maybe COLLECT with IF formula. What I would like to achieve: Smartsheet A - with list of the application name and ID Smartsheet B - with results of the evaluation, where is application name and ID as well and Repsondent Role, and Result I would like to collect the…
-
Question regarding guest accounts
Hi All, I am a member of my organizations IT Support team and I am currently researching an issue reported by one of our internal users: We have a user outside of our organization that has been invited to work on some smartsheet documents with some of our users. I believe this is through a guest account that was given…
-
Export Entire Folder to pdf and include gantt charts
Hello, I like how the feature to export an individual sheet to a pdf view gantt chart view. However, if you try to export several sheets from one folder, the gantt charts will not show. I would like the ability to export all sheets into one document that will display gantt information. Thanks in advance on possible…
-
Default Open to Bottom of Sheet?
When I open a sheet it always opens at the top (row 1.) Is there a way to have my sheets open at the bottom of the sheet or where I last left off instead?
-
Set up Review Request button grayed out in proofing
I'm giving the new proofing tool a try, and am stuck. I've enabled proofing on a sheet that I created in a workspace with numerous users with different levels of permissions, and have uploaded and made a couple pinned notations on an image (I have not yet @mentioned anyone). However, the button for Set up Review Request is…
-
Dashboard "Project Information" window: how to edit/control the information
Hi ! I am new to Smartsheet- trying to create good Dashboards. Need to know ways to edit/manipulate data in the window- the system does not allow me to do anything in the Edit mode, as expected. Any hints ? Will appreciate, Gary.
-
I Need assistance with Formulas in Smart Sheets.
Hello, i am having difficulty with formulas in SmartSheets, Index, Match, and IF Statements. If anyone is an expert, I can get the formula to work in Excel but not in SmartSheets. I have used the help desk, all the formulas they have tried have not worked, I found 1 expert in the Pro Desk who could help the other could…
