-
Date and Time Separator Formula
Hi Community, I'm looking for assistance with creating formulas in Smartsheet to separate a combined DateTime value into two distinct columns: one for the date and one for the time. "Date" Column: Contains both date and time values "Date Only" Column: Should display only the date "Time Only" Column: Should display only the…
-
Creating a report frm several sheets to assign tasks without adding an assigned column to each sheet
I have a collection of sheets (10-12) that all have projects in various stages that need a status review/update. This is a temporary process and I need to be able to assign each project to an employee, but these sheets don’t have an assignment column already built in them. Is there a way to set up an assignment system…
-
Basic Logic for Data Updates
System logic used to 'prompt' users upon data entry to validate that the user is doing something on purpose despite it being illogical. An example would be - entering a date within a date column that is in the past (or future; depending on the actual column).
-
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?