-
Create a user tasks sheet, but restrict users to only see their tasks
Hi I'm trying to work out the best way to assign and manage tasks to staff, where they can only see the tasks that are assigned to them. I'd like to create a single sheet where all tasks I create are recorded, but some of these tasks may be confidential and I don't want other staff being able to see all of the tasks…
-
Sheets disappeared
All sheets in my workspace disappeared unexpectedly; I am the owner and did not delete them. They are not in Deleted Items. I need help restoring them.
-
Automating Monthly Bar Chart Updates - Is There a Better Way?
I have a bar chart on an executive dashboard showing intakes assigned and completed by month and the bars are side by side instead of individual widgets for assigned and completed each month. Currently my process is: Add two new hardcoded COUNTIFS summary fields in my sheet summary each month (Month Assigned, Month…
-
Download List of Saved Automation Workflows into Excel?
Are we able to download a list of all our saved automation workflows within our workspace? We currently have many saved automation workflows within our workspace with some under sheets, some under reports, etc. and want to provide a list to our audit team so they can sign off on the new process. The only way they can see…
-
Smartsheet equivalent to a popup window or pivot table?
Is there anything like a pivot table in the smartsheet ecosystem? I am looking for a solution that is somewhat like a sheet reference, but perhaps saves the time of double entry? Case in point: those of you that use Concur travel or something similar, how do you organize the data and make it retrievable but also something…
-
Merged: Revert Sheet to [Time]
This discussion has been merged.
-
Using a reference sheet to bring in reference dates (e.g., 6 months ago, last month, etc)
I thought it would be easiest to create a reference sheet to house dates so I'm not constantly creating timeframe stipulators in my sheets, especially now that I am trying to create portfolio level rollups. When I observe the switch over from Mar to April, it seems like in order for the reference sheet to show April 1, I…
-
Guest access set to Edit, but cannot attach files to sheet.
I have a vendor that is helping our company with a deployment. We have given their PM access to our sheet as Edit cannot share, but when they try to add attachments to the sheet it comes up stating they do not have access to upload to that line. Why?
-
ADA Accessibility Design in sheets
We have a Smartsheet accessibility concern. We have employees with vision disabilities, for whom the gridlines are difficult to distinguish between cells, and the gridlines literally vanish when using some cell background fill colors, such as grey or brown. We have attempted to use conditional formatting and alternating…
-
Skip WBS vs. Deleting Task
Is it best to Skip WBS or actually delete the task? Are there benefits to either?