-
Update Requests: Automatically Ask for the Latest Info.
Dear all, I want to let my colleagues edit an existing row on Smartsheet by asking them to fill in an update form. However, the tutorial link is broken. Could anyone share the method to do that? https://help.smartsheet.com/articles/504779
-
How to sort a column without sorting all the columns
Hello, I want to sort columns alphabetically but not have all the other columns sort at the same time. Eventually, I want each of my columns sorted alphabetically but as if they are a stand-alone column and not impact other columns. When I try to sort a column, all the rows associated with that column also sort…
-
Use data from a form field in the alert email title.
Setting up an alert system that sends out notifications when a form has been completed. To streamline the process I would like to use a field from the form in the email title to differentiate between the emails rather than a range of emails with the same title. Is that possible and if so, how? Cheers
-
Bugs: SUMIFS does not find multiple users
Scenario #1 Multiple Resources assigned to Contact List type column (new release today) This =SUMIFS(Amount:Amount, [Assigned To]:[Assigned To], CheckName@row) does not match the [Assigned To] when the Contact name in [CheckName] matches. (It does for single instances) Scenario #2: It is possible to possible to get into…
-
Build an automation that creates a new row once a month
Hello! I did some searching but could not quite find what I'm looking for. I'm wondering if Smartsheet (now, or in the future) will have the ability for me to create a workflow automation that will run periodically (once a month) to create a new task/row. The use case is to create a new task on a monthly basis to have a…
-
3 unique automations pointing to 3 different sheets
Ok, I need some help from you SS wizards. I have crated a new form. This forms allows follows the logic path for 3 different request selections (job, project, video). I have 2 different automations set-up approval / decline project If approved copy row to separate sheet (job, project video sheets), depending on what the…
-
Sheet Summary Report and Dashboard Widgets
Hi! Can I use a Sheet Summary Report to drive a Metric widget? I have 25 project sheets that I would like to roll-up into a sheet summary report. I would then like to create dashboard metric widgets using this data. I am currently driving the metric widgets off of the individual sheets, but this is getting cumbersome as we…
-
Platform-independent icon for PC, smartphone to direct to specific Smartsheet url?
Greetings, all, complete noob here. I have created a Smartsheet form for reporting product defects to our company in an attempt to make the system paperless. The link works and the database works. But now I need to publicise the form. It would be nice if I could make this work like an app, where you click on the custom…
-
Changes to a resource’s allocation percentage do not affect duration
Hi all , As a project manager , I am trying to use smatsheet and project settings functionality . But resource management appears to be undevelopped . Is there any enhancement about this big issue : " Changes to a resource’s allocation percentage do not affect duration " . I can see that all the community is expecting a…
-
Barcode Scanning (Issuance and Receipt) using smartsheet forms
Hi , I am currently working on a requirement that came from central stores, they would like to track their inventory by using barcode scanning option, whereas, following applies: 1) Scan code, issue out material 2) Scan code, receive back the material Is this something that anyone has worked on , or who can help me to know…