-
Saving and exporting
I am a new user of Smartsheet with some questions: 1. Can we save the project plan on a local storage device? 2. When sent as Excel, only tasks, dates, and duration of the task are sent. How can we send the complete view showing the days and weeks on which the tasks are marked? 3. Can we work on the file off line? Thx.
-
Link limits regarding Vlookup
My question is regarding this statement: "There's a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet in total." If a cell on the inbound sheet is reading a range from another sheet, do all the cells in that range count against the inbound sheet, or is it just the one cell that is…
-
Is it possible to keep my original sorting order when pasting in Excel data?
When I paste in Excel data Smartsheet automatically sorts by the first column. Is there a way to prevent this?
-
Is there a way to Center things on forms
Is there a way I am able to center the headings and information or does it always have to be on the left side of the form. I have attached a copy of the form I am using and now I want to be able to center all the information or move around things on the form to have it linear where an email address and phone number would…
-
5000 max rows for a "spreadsheet" program? Can i get an upgrade to at least 65,000 rows like the 35
SEE SUBJECT 5000 max rows for a "spreadsheet" program? Can i get an upgrade to at least 65,000 rows like the 35 year old Microsoft Excel Version minus1.0? God forbid you allow a million like the latest version of Excel version 46billion.99999.84. BR549
-
Making a Date Column N/A unless needed to for a specific row
I was wondering if there is a way to make a date column go N/A unless needed for a specific row or rows. For Example: I only want the Delivery Date Column to be active when it comes to Deliveries. Is there a way to do this or no? Please Help Thank You.
-
Finding a SmartSheet
I'm trying to find a SmartSheet, that I know exists, but isn't shared with me so I can ask the owner to share it. How do I find it?
-
IF AND trouble
I am trying to create a formula that assigns "Yes" to a cell if a result is within range and "No" if it is not. This formula worked for only one of the columns in the range: =IF([High Control Result]1 > [High Control Range Minimum]1, "Yes", "No") I tried to use AND without success: These formulas didn’t work =IF(AND([High…
-
SmarSheet Expiring for shared user and requiring subscription
Team! One of my clients is reluctant to use SmartSheets because she claims that when I share access and a certain amount of time has passed that she is required to purchase a subscription to SmartSheets. Is this true? I cannot find any documentation that supports this. Thanks.
-
Can't Print PDF of Gantt View
This project printed fine 2 weeks ago... now I can't print a PDF of the Gantt view. Grid view prints OK. Export to Excel and PNG work fine. It's not all that big... 67 lines. I've tried print entire sheet, selected rows, scaling or not scaling. Any ideas?