Community Platform
Discussion List
-
CAPA - Industry Standards (benchmarking)In Using SmartsheetI am in the Medical Device industry. I am looking for some bench marking information around what a well rounded CAPA system Metric should look like. For example: What is the typical percentage of CAPA types in your CAPA System. For e…
-
Volunteer AllocationIn Formulas and FunctionsHi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
-
Warning message when Duplicate entry is done through formIn Using SmartsheetIs there a way to get pop up message saying there is a duplicate entry of the line u entered through form. Something avoids duplicate entry.
-
Formula to count of items in a multi dropdown listIn Formulas and FunctionsHi The drop-down multi select is very nice and useful. I started to use it yesterday, but I need to use the formula =countif(range, criterion). I want to count how many times a value is repeated in a range that has multi values. I use …
-
Multiple selection on a drop down listIn API & DevelopersHi, I read in another tread that the ability to select multiple items in a dropdown list was in development. Does anyone know if that is available now?
-
FORMULA NOT WORKINGIn Formulas and FunctionsHI, I have a formula =IF(E3>0,E3-C3,TODAY()-C3) this works great in excel but in smartsheet it comes back with #INVALID COLUMN VALUE can anyone help fix this issue?? Please see attached excel with formula in Column D Thank you …
-
how do I add a calendar view in a Dashboard?In Using SmartsheetHello - I have searched the community and have found a "work-around", but it doesn't work. I am trying to show a calendar view of a clients project on a client dashboard. I only want them to be able to see it. I don't want them…
-
Managing user permissions for OneDrive folders in SmartsheetIn Using SmartsheetHello - I am new to Smartsheet, so I have A LOT to learn! (Image) Since attachments are not stored locally in Smartsheet, I need to save files requiring updates in OneDrive. Rather than maintaining OneDrive access separately, is there …
-
Can Formulas Reference Reports?In Formulas and FunctionsI'm trying to see if formulas can reference reports or just root SS. I ran a report for all late tasks assigned to all people in a department. I then wanted to use a COUNTIF formula that would sum up all the late tasks of a certain person.…
-
Add Actual start and completion date based on status columnIn Formulas and FunctionsAll, I want to fill date column based on status column. 1) If status is "In Progress" "Actual Date" is filled by today's date. 2) If status is "Completed" then "Completion date" is filled by t…
