-
Row Attachment: Link (URL)
I use Smartsheet to track video production in my department and there is a request to associate video links (vimeo urls) to each project row. I've tried creating a whole new column containing a hyperlink, but that clutters up the master sheet and its information is not benefitial to sorting or report generating. The other…
-
Time Tracking - Formula needed to total time spent
Has anyone used SS to track actual time spent? I am using the "Time Track for Client Projects" template modified for simple tracking of time spent for individual tasks by client or department. I cant seem to get the formula needed to add the columns for Start time & Stop Time to calculate and provide a Duration for actual…
-
Checkbox checked, cancel RYG
Hello, I have created 3 columns for the RYG, if the project is in the early stages the color green will show, if it is due within 4 days, yellow will show, and when it is due in 2 days red will show. Now I have a checkbox for the employees to click if the work is complete and I want the RYG colors disappear when they click…
-
restrict users from editing curtain fields
Is there a way to restrict certain users from editing curtain fields? For example, we are using Smartsheet so users can enter info waiting for approval, but we want only admin should be able to mark off "check box" for approvals.
-
Alerts/Notifications based on cell color
I would like to create an alert. If a cell turns red in a delivery date column, email PM assigned to PM column and another editor within the sheet. Do not see how to establish an alert just based on change of color.
-
Default sheet opening each time I open Smartsheet
One of the users here at my company asked me a question and I wasn't sure how to answer it. So I figured that perhaps someone in the community may have encountered this question and found a way to make it work. She has a report that I created for her and what she is asking is if there is a way that this report can be…
-
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…
-
Needing an "If, Than" formula for multiple variables
I am pulling together stats for a project using the JIRA connector and I need to be able to SUM all "Open" issues + "Reviewed" issues into one cell. I have the beginning of the statement and it works just fine, but whatever I tried to add the last part, "Reviewed" I get an unparseable error. Here is what I have:…
-
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…
-
Enhancement Request: Sights Auto-Refresh
We have created a departmental dashboard and we're displaying it on a 40" LCD. It looks completely awesome and we are now the envy of all other departments... BUT, the screen doesn't automatically refresh. We created a script that automatically refreshes the screen every 5 minutes and that is working to update the data,…
