Technology
Discussion List
-
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…
-
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…
-
Editing multiple update requestsIn Formulas and FunctionsIs there a way to filter/sort by rows with pending update requests or even mass delete all pending requests? Pulling together a list of pending requests for follow up as well as deleting all stale pending requests before the next automati…
-
Formula to Change Harvey Ball Color Based off of a WordIn Formulas and FunctionsI've seen so many examples of "Nesting IF" formulas for changing a Harvey Ball to a different color based off of multiple numeric or date scenarios. What I haven't come across is a way to change the ball color based off of verbia…
-
Need Formula: Per Facility per Model #, how much +/- from par level.In Formulas and FunctionsI need to add a column formula within the Stock Inventory Sheet, in the Qty. Above/Below Par column, that calculates per Facility per Model #, take the quantity from Order Type Stock Order Row – Facility Specific Part(s), how much above or…Answered - Pending Review 21 views 5 comments 0 points Most recent by Mark Cronk Formulas and Functions
-
Another automate RYG balls for parent based on childIn Formulas and FunctionsHi, I have a project plan with multiple levels of children. Currently, the RYG automation is as follows: =IF([email protected] = "Done", "Gray", IF([Due Date]@row > TODAY(+7), "Green", IF(AND([Due Date]@row &…Answered - Pending Review 79 views 5 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Smartsheet not saving consistentlyIn Using SmartsheetI have multiple Smartsheets this has happened to, although I save and make sure prior to closing the SS it has been saved, and triple-check by the "save" icon being "shaded" prior to closing the SS. From time to time wh…
-
Email as form field and for copy of responsesIn Using SmartsheetMy organization has just started using Smartsheet and I created my first form. I have a required "Email" field. I also enable the submitter the option to receive a email copy of their submission, which also requires an email. I a…
-
Counting number of tasks per Assigned To contactIn Formulas and FunctionsMy task list contains parent, sub-parent, then children tasks. The workstream leader is assigned to both the parent and sub-parent tasks, and possibly sub-tasks as well. I need to count the number of tasks per "Assigned To" …
-
Automation: "Copy Rows to Another Sheet" Isn't WorkingIn Using SmartsheetHi, I am the owner of a project that has several Smartsheets. When someone (owner/admin) changes the "Status" column to "Req. Not Met," I want the row to copy to another Smartsheet. I set up this automation. Then, I u…
