-
How to build Charts from Reports
I am curious if anyone is aware of any documentation on building charts from reports. I am actively learning as I go, but I notice that sometimes a report format works for building a chart and other times I get an error that the data cannot be charted. Is there documentation or best practices on the report format you need…
-
Filter: can I select all fields at once and apply the same critera to all?
Hi, I created a report which is linked to a sheet. The sheet has 40 columns. Since I can not filter or sort in the sheet, I created this report. I would like to see all content where I actually have data. Meaning, I would like to select all fields columns and set the criteria to "is not blank". I don´t want to check 40…
-
Need to retrieve sheets from Project Management Office Template Set
Hello, I downloaded the Template Set - Project Management Office and have been actively working in it and noticed that I accidentally changed a few formulas or settings from sheets. Therefore, I wanted to download a new PMO set to cross-reference, but it won't allow me to...I receive the error message below. The suggested…
-
How do you Sign Out of the iOS Smartsheet App on the iPad?
I just installed SmartSheet 9.7 on an iPad and while I can login, there doesn't seem to be ANY way for me to SIGN OUT when I am done. I am planning on using SmartSheet on factory floor iPads that are used by several people and expect that a user can pick up an iPad, Sign In to the SmartSheet app using their email/pwd and…
-
Auto Save Options
Just checking in to see if I have missed anything. Been out of touch a bit lately. Is anyone aware of any changes to the auto-save option for sheets? Is it possible to turn auto-save off or on on a sheet by sheet basis, or is this still a user based function? Just covering all bases..... Thanks!
-
Smartsheets for Inventory Management
Hello, We've switched over to Smartsheets right now for inventory management. Right now there's just a bunch of spreadsheets within smartsheets and we're basically doing things like we were in excel with a few added benefits. I'm researching smartsheets templates for purchase orders, tracking, inventory management etc.…
-
Attempting to get sum of values from two sheets. Sumifs w/ Vlookup?
This question has been asked in a number of ways before. I have two sheets. All I am trying to do is get the total amount of pieces of equipment based on different criteria. Here is the first sheet: The first sheet is showing Requesting Garage as in the garage making the request for the equipment and "Garage" as in the…
-
Input without access advice
Community, Seeking advice (a solution) for the following problem. I need an automation of a priority planning (business input) with only comment access rights (Can't change this for several reasons). However after an approval is provided the requester of a specific smartsheet line, needs to update a value (priority). Is…
-
Publish Link - Not Updating
Hi all, I have linked my an excel sheet that pulls data from one of my Smartsheet. I did this via Publish -> Get Link -> Paste Link to Excel as Sources -> Set refresh to every 1 minute on Excel so it updates alot Problem is, the Published form on Smartsheet isn't updating but the sheet itself is updated. Please see…
-
Use Predecessors for a Shared Start Date and Extended End Date
I am working on a marketing project plan template, and some of our campaigns spend multiple days in market. Tracking the performance of these projects happens for the duration of the project plus the duration of an attribution window. Example: An email campaign launches on 4/1 and runs through 4/7, and any email leads…