-
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…
-
Automate sheet export to excel on workday 6
Hi, I am trying to automate the scheduled send of a sheet on the 6th workday of every month. I have explored two options: File --> send as attachment. Issue is that the 'send monthly' only allows you to select workdays 1-4, or the last workday of the month. Automation for 'alert when a date is reached' and work out…
-
Stop lower row automatically copying colours from row above
I have a ticket tracker template being used at the moment, and every time a new ticket comes through from the form, the new row is formatted like a header (dark infill, bold type etc.) - how do I stop this row from being formatted like a header, and instead having it formatted like a child row should be?
