Technology
Discussion List
-
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…
-
External Mass UpdatesIn Using SmartsheetHi! I am working with an inventory style Smart sheet, that tracks the location of monitors and desktops. i.e is the computer checked out to an employee, or is the item available to be shipped. I am "checking out" assets in gro…
-
Change status if progress bar changes (help w/syntax)In Formulas and FunctionsHello I want the status to change if the progress bar is changed. I tried a formula but only have it half working. =IF(AND(Progress1 > "Empty", Progress1 < "Full"), "In Progress", IF(Progress1 = &quo…
-
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…Answered - Pending Review 402 views 5 comments 0 points Most recent by Andrée Starå Using Smartsheet
-
Embedding from the Calendar AppIn Apps, Integrations, and Add OnsIs there a way to embed a calendar you created from the calendar app without placing it as a widget in a dashboard?
-
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…
-
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 87 views 5 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
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…Answered - Pending Review 1.1K views 5 comments 0 points Most recent by Genevieve P. Using Smartsheet
-
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" …