Technology
Discussion List
-
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…Answered - Pending Review 141 views 4 comments 0 points Most recent by Emily Eberle-Levine Using Smartsheet
-
Why are charts appearing very pixilated and low quality?In Using SmartsheetUsing latest version of Chrome, just updated it and cleared cookies/cache then restarted my computer. This has never happened before not sure what is causing it: I am zoomed in 100%, even at 50% or 150% the problem is the same.
-
Cross Sheet reference/"assigned to" allow multiple contacts per cell LIKE formula?In Formulas and FunctionsSS community - I need help. I have created a Sales Pipeline sheet for my sales team, sales stages etc which is basically it's own CRM. I am trying to gain metrics in order to keep the sales team members honest and report the truth to the l…
-
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 49 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 419 views 4 comments 1 point Most recent by Prime George Formulas and Functions
-
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 54 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…
-
Created Date Formula for FormsIn Formulas and FunctionsIs there a formula that will capture the created date for new entries on a form? Once the form is completed, I would like a column to automatically populate the day that row was added from the form so I can track response times. Is there…
-
I need help so that I can calculate a percentage of completionIn Formulas and FunctionsGuys, I need some help. I am struggling with calculating the percentage of completion of the whole sheet based on how many tasks are Complete in the Status column, or maybe better said to calculate the completion percentage based on the Pa…Answered - Pending Review 33 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions