-
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…
-
resource time calculations
Hello, Is there an easy way to sum the time tasked to specific resources. I want to populate an estimate based on my schedule I created but I don't see a way to easily determine how much time each resource has been allocated. I can export to excel and manipulate columns, filters etc. but it seems that there should be some…
