Manufacturing
Discussion List
-
=ROUND(SUMIFIn Formulas and FunctionsHi =ROUND(SUMIF($[Pareto Category]$32:$[Pareto Category]558, Predecessors21, $[Actual (MHrs)]$32:$[Actual (MHrs)]558), 0) The above is my formula. It says, "IF the value in the Pareto Category column is the same as the value in th…
-
Update Confirmation email limitationsIn Using SmartsheetHas anyone figured out a way to disable the update confirmation email that is sent following an update request? The email is confusing my user community because it links to a sheet they don't have access to. Is it possible to even change t…
-
SUMIFS & FIND functionality with Summary SheetsIn Formulas and FunctionsHi All, I checked the archives and couldn't find a solution to my problem so I apologize if this has already been asked. I am trying to create a formula for my Summary Sheet that will provide the sum of dollar amounts but only if they are…
-
Reporting like pivot or sumif. How to roll up values by name or category?In Formulas and FunctionsIs there a way to combine cell entries and give the total assigned to that category? Ex. Project Lead Cost savings John $100 Mary $500 Bob $400 John …
-
Forms that need to incorporate multiple line entriesIn Formulas and FunctionsWe currently use Jotform for some of our forms here and would like to be able to bring more of them over to Smartsheet if possible As you can see from the attached files, the form is set up to add a new line after each previous line is fi…
-
Returning last entry in a database columnIn Using SmartsheetI have created a database that adds a new line against a date each day. From this I am building some metrics and then a dashboard which will show Daily Performance but also week to date, annual etc. I am struggling to reference the databa…Answered - Pending Review 170 views 12 comments 0 points Most recent by Adam Kinney Using Smartsheet
-
Can I hide predecessor lines in a gantt chart?In Using SmartsheetI have a complicated project with tons of predecessors. The predecessor lines connecting tasks in the gantt view are so numerous that is makes the gantt visually hard to use. Is there are way to hide or turn off not the predecessors, but…
-
Is the Email Notification highlight color yellow definable?In Using SmartsheetIn a standard email notification for sheet updates the changes are shown in yellow in the email body, is there a way to define that color to something other than yellow?
-
Digital SignatureIn Using SmartsheetHi all, I've searched for this topic, but i could not find directly what i was looking for. Is there on Smartsheet any functionality for digital signature that doesn't require pairing our service with another software? All the solut…
-
How to set recurring remindersIn Using SmartsheetI have been searching through the posts and found this formula: =IF(Complete4 = 0, TODAY(), “”) using my own column names. Each time I've tried to accept the formula, I get this error message: unparseable. Am I missing some of the formula …
