Technology
Discussion List
-
Auto populate data in FormsIn Using SmartsheetI am trying to auto populate the data in Forms for example if we select ID the corresponding fields will get auto populated with required values. As per the attachment if we enter any ID in the CUS ID field it should populate the PSS Firs…
-
Card View for ReportsIn Using SmartsheetAll, Has there been any progress with adding card view to reports? Has this been an approved feature and scheduled for a release? Our company has been pushing a move to JIRA because of the gap with smartsheet in allowing our teams to vi…
-
Calculating Average Time for each member of a teamIn Formulas and FunctionsHi everyone, I am new to SmartSheets and Excel formulas in general and would like some help please. I would like to calculate the average time in months that it takes for a team member to complete tasks. For example, I have a date created …Answered - Pending Review 11 views 3 comments 0 points Most recent by Henry Tam Tran-Quevedo Formulas and Functions
-
Find the row with the earliest Created (Entered) date that matches certain criteriaIn Formulas and FunctionsThis one was a challenge. I thought I had it solved, but an erroneous value showed up, necessitating taking the formula back to the drawing board. The requirement: Show me the oldest Bill of Lading number that does not have a status of &…Answered - Pending Review 217 views 4 comments 1 point Most recent by Prime George Formulas and Functions
-
Automation - How to Send One Email Notification for Each Changed RowIn Using SmartsheetI am using automation for one of our request approval processes, and need to be able to notify our help desk support team anytime the Completion Date column is updated with a date. I know how to do this, however, I can't figure out how to…
-
How to return more than one value with multiple serach values with vlookupIn Formulas and FunctionsHi, I have two columns ID and C. Based on a vlooup formula in C with the search value in ID and need to show the value in C. My Question here is when I need to show multiple values based on multiple IDs. Example: If ID1=Result1 ID2=Result2…Answered - Pending Review 52 views 7 comments 0 points Most recent by Andre Ramos Formulas and Functions
-
Why won't my COUNTIF formula not count anything from source sheet?In Formulas and FunctionsHi all, I currently have a system for three spreadsheets: 1) Masterlist for open/closed actions that feeds a 2) Open Actions sheet, and a 3) Closed Actions sheet. The formulas for the first two sheets work perfectly, however, when it come…
-
Quickbooks & SmartsheetIn API & DevelopersSo. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use. It has many application & the proof of concept exists and we use it. We use it for an approval process (for in…
-
Duplicate Notifications and to Everyone in the WorkflowIn Using SmartsheetIssue: The notifications for the CD level and RVP level are duplicating and sending to everyone in the workflow. 😬 Something is wrong with the workflows I created. Sheet Design Each row has someone assigned {Response Assigned to} to add t…
-
% AllocationIn Using SmartsheetAs a new user, I found that the % Allocation column does not respond to input from the Duration column, as seems intuitive to me. After reviewing community comments, I find that the % Allocation functionality in Smartsheet does not actual…
