-
Allow Gantt view to use Date columns with Column Formulas for Start/End
I'm kind of flabbergasted that this is not currently possible in a Sheet, and I'm struggling to explain to my users why. It is already possible to populate a Date column with a Column Formula and then convert it to a Cell Formula, and then use that column as the Start/End for Gantt view / Project Settings, so the issue is…
-
Request Snapshot not received. I am the sheet owner. Not on spam/junk.
I have requested for a snapshot, but I have not received the email yet. Any idea why and what do I need to do?
-
Tracking a 1-day project based on time not date
I am helping manage a 1-day Disaster Recovery exercise and we want to track the tasks by start & end based on time of day. Would also like to auto adjust the times with dependencies - Does anyone know if a template is available of has anyone ever done this before?
-
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…
-
Revert to previous versions of sheets instead of just the activity log snapshot
I just ran automation on an entire sheet instead of just the rows. I wanted to move tasks to a compact task repository, and it moved 364 subtasks that I wish it hadn't. Now, I have to go back and manually revert what I can. Luckily, most of the time, we upload comments and proofs to the parent tasks, which, because they…
-
Merged: Revert Sheet to [Time]
This discussion has been merged.