-
Template form link and Roll Up sheets
Has anyone done this? Can you add a form link (status update form) to a roll up sheet automatically once the project is provisioned in Control Center. Essentially the end goal is that already created template form, I would like the link to auto populate the form link from the status update sheet after provisioning so users…
-
Add Centralized Date/Time or Changeable time zone on System generated columns
Please use UTC or a changeable time zone for columns which are system-generated. I have a sheet where I transform the "Created" column which is in UTC to a date in EST for readability. The discussion user however is in PST. That changes the "Created" column which in turn changes the transformed column. Normally, this would…
-
I did a "Save as New" on my sheet and the new sheet is missing all the Proofs. How do I get that back?
Hi All, I thought I was being smart and did a "Save as New" to my Smartsheet to preserve all the information on all my rows and create a "Completed Projects" sheet. Then I deleted the open project from the newly created "Completed Projects" and then deleted the Completed projects from our main sheet. I noticed this am that…
-
Report adding and removing sheets
I have a report that consists of 27 sheets. Shared sheets and report with 3 people. These 3 people do not have the ability to add or remove sheets in this report. Is that normal? I would like for them to remove sheets as they complete a project. Attaching an image - the selection option is grayed out for them.
-
Subtracting Months from a date, Error #Invalid Value
I have three columns. One with a date 7/1/2027 in date format. One with a number representing the number of months I wish to subtract from the date column. Third column is a date column with the following equation: =DATE(YEAR([Column4]@row) - INT((MONTH([Column4]@row) - VALUE(Factor1)) / 12), MOD(MONTH([Column4]@row) -…
-
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.