-
Link to cells in a different sheet
Hi SC, I need to link cells across two different sheets and I am looking for a way to avoid having to create the link one by one. The cells to be linked are located in adjacent columns so ideally, I would just need to create the first link for the first column and then drag the formula through all the columns. I tried it,…
-
Requirement Traceability
Hi there - We are struggling with some inadequacies with our internal requirements management system and are looking for a workaround or way to leverage Smartsheet for this purpose. Main goals being requirement traceability and bulk uploads. Has anyone leveraged Smartsheet for requirement management and repository…
-
Request - Find and Replace option in project sheets
While using my project sheet, I will perform a Save as New to copy my format; however I will need to do bulk changes. It would be such a time saver if I could perform a Find/Replace (all).
-
Date selector on Sight - going back to past snapshot
Hi Smartsheet Community I checked a couple of posts but couldn't really find an answer, here we go: Sights are technically always showing real-time status. As I need to submit monthly updates to our leadership team and we want to track status trends, is there a way to re-visualize a past view of a dashboard? Or is the only…
-
Sharing Sheet with Filter only
Enhancement Request: Our company needs the ability to share a sheet with two or more providers and due to confidentiality we need that information to be filtered and locked in the filter so they are unable to see the general sheet. But we still need for the provider to be able to make changes to the sheet with their…
-
Hyperlinks in Smartsheet
Is it possible to configure the Hyperlink in Smartsheet to open a local program in my computer like what we do normally in Excell ?
-
Set a dropdown value for all selected cells
For nested items especially, it would be nice to select multiple rows' dropdown cells, right click, and set a dropdown value across all those that are selected. So, 5 nested rows whose parent's dropdown for "status" is set to "complete". I'd like to be able to select cells from that same column for the nested rows and…
-
Submitting Product Enhancement Requests
I understand that by submitting a "Product Enhancement Request" it doesn't mean it will be actioned and even if it is, will materialize in the immediate future. I think that rather than it them seemingly disappear down a 'black hole' a published list and the status of requests would be useful.
-
Free Collaborators vs Non Licensed Users
Can someone explain the difference between a non licensed user and a free collaborator? e.g. * Do they need a smartsheet account? * What can and can't they do?
-
Formulas: Countif / And / Children Rows
H E L P! What is a simple way to formulate the "Evaluation" Chart in the Screen Shots attached, based off ONLY the children rows of the 4 Departments on the top of the sheet in both the "status" and "risk level" columns? I'm trying to avoid a "messy" formula but I'm receiving an error through all my attempts.