-
Mandatory Columns in Table / Grid View
Extension of the functionality within the forms, ability to toggle a column to be mandatory for data capture purposes. The benefit of this would be to increase data quality by ensuring that people not using the Forms or updating items are required to populate / update fields to maintain good quality data.
-
I don't understand my Sheet Summary formula
I've been using sheet summary formulas for a week but have been struggling with something I don't understand all afternoon. I have a summary field called % Planned Complete. For simplification, I'm testing this formula: =INDEX([% Planned Complete]:[% Planned Complete], 21) * 100 But it won't return the value for row 21 in…
-
Merged: Function to duplicate columns
This discussion has been merged.
-
Reaching Cross Reference Max error prematurely
I Saved as New an existing Project Metadata sheet with 90+ cross-references. When I removed the old cross-reference formulas. I was only able to add 6 new cross-references before getting the "Unable to create cross-sheet reference, because this sheet already contains the maximum number of different cross-sheet references"…
-
Rows disappear while editing my sheet.
My colleague have been working on a sheet for the last hour+ and while some changes have saved She is saving every couple of minutes) loads of my changes have disappeared. Do you have any idea why? more info: Editing - directly into the card view. Rows disappearing immediately after saving - No. I'd been making changes for…
-
Cross Sheet Counting
Hello, I have two sheets. One one Sheet I have a column with a drop down of names. I have another column with a dropdown of yes and no. On another sheet, I have all the names as rows and 2 columns. One column is named Video Missed and the other column is named Video Grace. What I need to happen is this: On the first sheet,…
-
Smartsheet Gov- Data Shuttle
I have Smartsheet Gov and am having issues successfully authenticating via smartsheetapps.com to link my OneDrive or SharePoint account. I'm seems as if the page has been removed. Any suggestions?
-
I am getting an error message when attempting to export to excel
I am attempted to export to excel. I have two different smartsheet documents to export. One of them exported to excel fine, but not the other. This happened a few weeks ago. I make sure all columns were the correct size & no cells were hidden. "We have found a problem with (file) Do you want us to try and recover as much…
-
Can I copy/paste summary fields between sheets?
I've just added six sheet summary fields to a sheet. But I have to add the same six fields to another eight sheets. I've been looking in the posts here, and I don't see anyone addressing whether there's any way to copy/paste the
-
Pulling Original Due Dates from updated Due Dates Cell
I am wanting to track, months into a project, where I originally had set the Due Dates. I have 300+ line items and I would prefer not to go in manually to update a new column with "Original Due Date". Is there a formula to pull that information from cell history so I don't have to manually do this? I sincerely appreciate…