-
Auto Filling a cell from data in another samrtsheet
Good afternoon I am creating a bid invitation sheet and need to list GC bidders per each job (row). * How do I create an autofill for these cells based on a directory I have created? * and once the GC is selected in this cell how do I autofill the column next to it with one of their many estimators at their company that is…
-
Merge & Center
Hello, The "merge & center" is a formatting option I am quite fond of inside excel and curious if I can replicate this in SmartSheet. I would welcome any feedback. Sincerely, Scott
-
Is it possible to take text from Grid View and present it in a 2x3 format?
Hello, I just received a Smartsheet license today, so very new at this. I developed a form to gather information from users and automatically plug into a sheet. This will work nicely for capturing the data, but not so much for presenting the info in a meeting. Does anyone know if it's possible to take the text fields from…
-
Published Sheet View
We have a Published Sheet that displays on a large monitor. Up until recently, the sheet displayed the Gantt view. In the last several weeks however it is displaying the Grid View. We can change the view on the monitor to Gantt however when the sheet refreshes it goes back to Grid View. I checked the Publish Settings and…
-
Redirect smartsheet links to the published link.
Hi there, Hopefully you guys can help me with this, as it would be something that would really help me out with the way my company uses smartsheet. I have a template workspace I've put together that contains portals / dashboards with links to other portals / dashboards, that are also within the workspace. The way copying a…
-
Print Card View?
Is there a way to print card view, or even share a link of it to a non-SS user? Love the flexibility it's given me to sort in new ways, but can't figure out how to share it with anyone else.
-
Capturing multiple statuses, reminders for recurring tasks, form
Hello SmartSheet community, perhaps someone can give me ideas on how best to set up the following: I have 30 customers and 30 different reps (one for each customer) who need to provide a status on that customer on a regular basis, at least once every two weeks. The requirements: * Use a simple form to collect the data,…
-
Scheduled Reports Not Generating
I have set up several recurring scheduled reports to be run this week, and NONE of them have run. I am using the "Send as Attachment", "PDF", "Schedule to send later or on a recurring basis", I set it up, then hit "Send", and the recurring event appears in the "Sent to" field with the circular arrow icon to its left, but…
-
Published Sheets
I understand that Published Sheets are dynamic and will reflect any changes to the sheet. However, what about in terms of the Project Settings? We have a published sheet that is displaying on a common monitor. When the sheet was published, the Timeline Display was set to "Open to today's date". Since then we have unchecked…
-
Publish sheet without comments
Is there a way to have the indent feature but to hide comments on a published sheet? I have a sheet that I want to share by publishing but I don't want comments to be visible because they contain sensitive data. I am using the indent feature which allows rows to be expanded and collapsed to show/hide rows. I see that I can…
