-
Printable and Readable A3 Gantt Chart
Hello, Could anyone advise on how to print a readable gantt chart in A3 format? I've managed to export it to PDF and select the rows needed, however it is barely legible. Exporting to excel has not helped as it deletes the gantt format. Would be grateful for any tips or solutions! Thanks
-
How can I merge two schedules for a project into one all-encompassing schedule?
Hi Everyone, I am working on a project that consists of two schedules, and there are tasks that will be done onsite for products being built for our company here in the US and for a location overseas (to be shipped out later on in the schedule). We have a schedule planned out for the US location, a separate schedule laid…
-
Why isn't our column formula updating on its own?
In our column formula, we have a date formula based on TODAY(), however, it does not seem to update automatically when the month changes. How do I get it to update automatically at the beginning of the month?
-
Cross-sheet VLOOKUP maximums
With the new cross-sheet VLOOKUP function, how many VLOOKUP cells can exist in one sheet? Does the limit change if there are both inbound and outbound VLOOKUPS in the same sheet?
-
Owner/Admin View for Workspaces (Hide unused Workspaces)
As our company admin for Smartsheet, I typically deploy all-new Project Workspaces - this provides me with the opportunity to assist team members if they become stuck, or have an issue; I can then problem-solve with them within their workspace. This leads to an issue where I have many, many Workspaces visible, of which I…
-
Can I create one:many and many:many relationships between two SmartSheets?
Hello, I have two related SmartSheets covering different aspects of my data. I would like them to refer to each other so that I can ultimately pull certain aspects into a report. I prefer to use SmartSheet over SQL in order to take advantage of the workflow and approval capabilities. However. I cannot figure out how to…
-
Merged: Views/Filters - Display specific columns
This discussion has been merged.
-
Join columns from 1 match
Good evening, I'm looking for some assistance :) I've been trying to find the formula that alows me to join 3 columns value of the same line of the match. This is between 2 smartsheets. I made a quick draw of it. I would appreciate any help :)
-
Creating horizontal view for existing sheet
Hi, I'm trying to get sheet A (vertical view) into sheet B view (horizontal view). Sheet A: Sheet B: the helper column date is in txt/number so it would match sheet A. Could anyone help? Thanks. :)