-
Calendar view of all Projects, the resources assigned to the projects, and their associated allocati
We are looking for a way in SmartSheet to present all projects (ideally, can be sorted/filtered by workspace) and the resources assigned to each project, and the associated allocation in a calendar view. I have created a quick mock up of the presentation attached. No capability to do Reports in the required Calendar view.
-
Automated send format question
Good morning, I'm setting up an automated weekly send for a report. I need send it in the vertical format, as though you are sending a row. As it is, it sends in a PDF which is a linear format, and not user friendly for our purposes. Is it either a: Possible to send a vertical format on an automated/recurring basis or b:…
-
How to Setup Formulas to Automatically Link & Pull Data from Other Sheets
I'd like to try and figure out how to most effectively and efficiently connect 2 separate smartsheets together, preferably through some sort of smart formula/code. I don't think doing a manual "cell linking" from a cell in one sheet to the next would be very smart or efficient for what I'm trying to do here. I have both a…
-
Multiple calendar dates in single row
I have a production schedule that list the issue in the primary column and then column headings with due dates for several items throughout the production process. I'd like to show all dates in each column individually and not with a start/end date. I lose the detail in the middle. Possible? thanks Donna
-
Turn hours (hh:mm) to numeric value (00.00)
Is there a formula to make a column with duration values like 1:30, 2:45, 3:15, etc etc (only ending in either :00, :15, :30, and :45) to 1.5, 2.75, 3.25 hours (again, only ending in .00, .25, .50, and .75, respectively)??? I am VERY new to SmartSheet so, if you could actually explain how to do stuff that would be awesome.…
-
"Pretty" PDF export -- Google merge, something else?
Hi all, We’re hoping to be able to export a fairly complicated styled PDF from Smartsheets. Imagine a sheet of movie reviews, where Column A is movie title, B is review, C is reviewer and D is date. Each movie can have multiple rows depending on how many reviews it’s received. We’d like to get a PDF that would look a…
-
Formula to move a row to another sheet?
Good morning, I'm hoping I can formulate a column so that if the checkbox is checked, it will move that row to another specified sheet. Can this be done? If column A is checked, move to Sheet B is the basics, but formulas always mess with me. Blessings, Loann
-
Sheet limit within Smartsheet
Hi everyone, I'm about to embark on a large scale server back up and am hoping to keep all of my data logs on Smartsheet for safety. There will obviously be a massive amount of sheets to hold and I was just wondering if anyone knew the limit on how many sheets you can host? I'm a licensed user and am part of a team…
-
Saving Errors
Hello, I am recently unable to save changes made in Smartsheet. I have tried everything that I can think of to get around this glitch, but nothing is working. Has anyone else run into this problem before? See screen shot attached. Thanks!
-
How to play back a GIF files animation
I read the article about inserting pictures and how smartsheet is compatible with the animated GIF format (Article Here). It says in order to view GIFs I have to switch the sheet out of grid view and go into "zoom" view. What is zoom view and how can you play back the GIF animation?