-
custom email message
Hello, can we have a customized e-mail message while we share the smartsheet with the collaborators? Thanks, Bishwo
-
Feature Request: timestamp() function
It would be great if there was a way to timestamp the value of a cell. To enter the exact date that an event occurred. Several people have volunteered a modified date column, but something like the following functionality in an if-statement would be really great. =IF(FieldName1 = "blah", timestamp())
-
Summary Fields: Percentage of Completed Checkboxes
I'm very new to Smartsheet and hoping someone can help me. I have created a checklist, with different categories divided up by parent rows, and the tasks listed as children under the categories. I have a checkbox column and each task (in the children rows) has a checkbox. I have figured out how to calculate the percentage…
-
Export Entire Folder to pdf and include gantt charts
Hello, I like how the feature to export an individual sheet to a pdf view gantt chart view. However, if you try to export several sheets from one folder, the gantt charts will not show. I would like the ability to export all sheets into one document that will display gantt information. Thanks in advance on possible…
-
Publishing only filtered list to google calendar
I'm having an issues with "Publish to Googgle Calendar". Every time I've publish some task in google from SamrtSheet, SmartSheet publishes everything in my Google calendar instead of publishing the specific tasks assigned to me. I've attached a detailed description of the issue I'm facing with screenshots. Does anyone know…
-
Apply Formula to Entire Column
I'm trying to automatically apply a formula to an entire column that concatenates info from cells in a given row into a document name, once data is entered into those cells. The only way I've been able to accomplish this so far is to just copy/ paste or drag the formula as data is entered in a new row, but I'd like it to…
-
Form Feed to one row?
Is it possible to have multiple forms for a SS populate to the same row if the same text is used in the primary column? I have a sequence of tasks that will be completed over multiple days. Each task has its own form. Or, will the form populate to a new row upon completion? If latter, I suppose the solution is to create a…
-
Hyperlink from Sheet clickable in Metric Widget on Dashboard
We are having people create a hyperlink in a cell on a sheet to a word document saved on our O365 sharepoint. I want this link to then be available on the dashboard. I currently have the cell linked in the Metric Wizard, but when viewing the dashboard, the link is broken and only the words are there. The users are not able…
-
Connecting Trial Information
Hi all! Beginner Smartsheet user here. Does anyone have experience with using Smartsheet to track product trials/experiments in their product development sheet set? What is the best way to create a visual of trial progress and outcome? Is there a template? Is an attachment the only option? I could use some guidance! Thank…
-
Gantt Print Problem - Can't choose columns to print
Anybody having problems with their "non-licensed" users not being able to select the columns to print in a Gantt view? The "edit" button for selecting columns to print no longer works. I'm wondering if the recent software update has broken this functionality.. We receive an error that says "An error has occurred in the…