-
Share a Smartsheet folder to auto update added sheets/reports on Sights
Hi, Is there a way that I can share a folder with my team? I want to add the folder on Sights so that when new sheets or reports get added in that folder that it is already accessible in that sights folder without me have to go and add it manually everytime? Or any other suggestions on how new sheets/reports can be…
-
Automatic email notification link when comments change or are added
The automatic email notifications based on the comments changing is nice, but the link in the automatic email notification does not take the user to the specific comment that was added or even the row it was added. It requires the user to go back to the email to look and see what row the comment was added to. This is…
-
Locking Cells/Columns in a Report
Hi Smartsheet - I recently created a series of report in smartsheets that pull specific pieces of information for departments so that managers can see their respective things and provide updates. However, unlike a regular sheet, where you can lock certain columns so as to prevent users from being able to edited field, we…
-
Keeping parent Task during filter search
I have been using the Parent Task as a header for child task below. The child task has an owner, the header does not. I'm in construction so for example the Contract header has child items such as site visit, develop scope etc. My owners don't want to see all the items that they don't own and I have a filter for each owner…
-
Publish Calendar Format - Hyperlinks Lost
Hello, I searched but didn't see an answer to this issue: I maintain a calendar, based off a SmartSheet template, whichI publish to our intranet. In the description field, I would like to include hyperlinks. In grid view, the hyperlinks are active and functional. When I change to calendar view, both for myself or looking…
-
"Send Row" opens Pop Up Window from Sight
Hello, I am trying to manage requests from a customer with my local team of people who work on the requests. I love the comments, attachments, that can be added into a row, and the ability to create a sight with different reports. I have created a web form for my customer to input requests, but I would like a clean way for…
-
Rounding ONLY Up
Hello, I have a construction equipment management sheet and I am trying to create a customized rounding formula for the "months rented" cell. Equipment rentals usually charge at intervals of 1-week, after that at 2-week, then after that at 1-month. Because of this, having a value like "1.3 or 1.6 months rented" doesn't…
-
notification to Onwer
I'd like to see if I a notification is sent to the Owner of a row when something changes on it it. For example if another owner or the admin changes the description or if a start or end date changes due to a Gantt or Calendar change, urgency changes etc. Also is there away to send a notification to athe oner of a new row.…
-
cell date recorded when adjacent cell status changes
i am wanting to capture the date when the status of a cell changes. is this possible? if so how do i do this?
-
1 Sheet on multiple worspaces
I am having problems trying to find a way to share 1 sheet to multiple workspaces, if this is even possible. Anyone have any ideas?