Other
Discussion List
-
Find Difference between two Cells that could be Multiselect Dropdowns or TextIn Formulas and FunctionsI am pretty advanced when it comes to smartsheet and formulas. But this one has me stumped. I am trying to find a way to report on the difference between two text or multiselect cells. Any advice would be much appreciated.Answered - Pending Review 34 views 10 comments 0 points Most recent by Thomas Bostwick Formulas and Functions
-
21 CFR 11 ComplianceIn Using SmartsheetI work in medical devices, and I have been trying to figure out whether or not Smartsheet meets FDA 21 CFR 11 requirements? Because I would like to use Smartsheet for our logsheets. Does anyone know whether or now Smartsheet meets FDA …
-
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…
-
Form Confirmation OptionsIn Formulas and FunctionsI have created a purchase order sheet and form which auto generates a number each time. How do I reference this number to pull it through into the form completion confirmation message and/or email?
-
Formula to Forecast Material Quantity Received vs ConsumedIn Formulas and FunctionsI am hoping there is a formula to see what I will need to forecast to purchase for material received vs consumed. Any help would be greatly appreciated!
-
How can I count distinct values under a same month?In Formulas and FunctionsHi everyone, I currently have a data set for which I would like to count all unique values that are under a same month and a same year. For example, the following table shows two duplicate values (TR ID's) on two different dates. In this …Answered - Pending Review 3 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
How do I set an automation without a trigger or is there a workaround to create a triggerIn Using SmartsheetHello! I am needing to set an automation to lock and unlock rows. I have the automation set to lock the row when it is changed from “open” to any other value. I need a time based function that will allow the cell to unlock a certain time…
-
Is there a formula in smartsheet that would create a 2 way link between cells?In Formulas and FunctionsHello, I have multiple sheets that I would like to link all into one Master Sheet. I want the cells to have a two linking methods between each other. If a cell changes in the Master Sheet, I want it to reflect to the other sheets and if th…Answered - Pending Review 15 views 7 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Calculating hours:minutes from cells with date and timeIn Formulas and FunctionsTrying to calculate total time (preferably in minutes) spent at a task/site. Arrival and departure "times" are written in date-time format - so (arrival) [2/28/19 9:15PM] in one cell/column and (departure) [3/1/19 2:25PM] in ano…
-
Mark Duplicate valueIn Formulas and FunctionsHello team can someone suggest a simple way to mark cell (or rows) that one of the columns with Duplicate value thanks in advance oded
