Solution Center
Discussion List
-
Vacation & Time-Off ManagementIn Using SmartsheetHas anyone used smartsheet to manage time-off requests and/or vacation for a pool of staff (approx. 200)?
-
ODBC Connection with VisioIn Premium Apps and IntegrationsHi All, I am attempting to automate the creation of my Agency's Organizational Charts via Visio and the smartsheet ODBC connector. We have our "reports to" information stored in smartsheets and have used the ODBC connector to c…
-
Dual parameter formula to capture last entered date versus last date of column?In Formulas and FunctionsCurrently have a sheet that allows an end user to utilize a drop down and date column to quickly input their activity related to a row. Once entered, a workflow copies the date and activity to a separate sheet with dates placed into indiv…Answered - Pending Review 34 views 12 comments 0 points Most recent by Leibel S Formulas and Functions
-
Populating external Reports with Smartsheet DataIn Using SmartsheetHi, Is there any way that I can export my data from smartsheet so that it automatically populates/merges into a template that i have (word document) Thanks in advance, Scott
-
Using Smartsheet FormsIn Using SmartsheetI have this schedule above (took out the names/privacy) for weekly schedules with my team. Normally there is a time frame in each cell for thee week like 9:00-5:00. Each week pulls down, I just have week 3 as an example. And this form: …
-
How to create metric from timestamp in sheetIn Formulas and FunctionsI am trying to create a metric in my dashboard that shows the average time of day that each contact submitted their request. The specific date is not relevant. Please help Thanks!
-
Problem with vlookup calculationsIn Formulas and FunctionsI am having a new problem with an existing Smartsheet that has worked fine until now. Existing workflows have stopped working. The problem does not appear to be workflow, but something else going on. We have a workflow that triggers off of…
-
Backups/Excel exportIn Using SmartsheetHi all, Would it be possible to backup/export a spreadsheet on a scheduled basis more often than daily? One of the Departments on my company asked if it would be possible to do it hourly or even every 10min, but the smallest period i can…
-
How to make % frequency chart in dashboard (reasons for QC failure)In Formulas and FunctionsHi, I am trying to make a chart in my dashboard that displays the reasons for QC failure as a percentage of overall frequency. The input is from a sheet with a column as shown below. You can select the mode of failure from a dropdown menu,…
-
Create cell reference based upon horizontal axis positionIn Formulas and FunctionsIs there a way to create a cell reference based upon a horizontal axis? For example, for a given column, I want it to always represent the cell directly to its left. For this example scenario, a new column will be added for every date an…Answered - Pending Review 15 views 1 comment 0 points Most recent by Genevieve P Formulas and Functions
