-
Lock Cell until conditions are met
Hello, I have a checkbox column called Ready for Production which notifies the relevant persons when an item is checked and ready, I would like to lock or leave cells on this column empty until a number of conditions are met, the conditions are; Drawing Status Column is A - Approved or B - Approved (with comments) Site Dim…
-
Alert Notifications Not Sending Because of Attachments Added to Row
Hi, i have an alert set up for when a specific field has any value entered it sends an notification to recipients. This works fine but only when no attachments are on the row. If an attachment is added to the row (before) the trigger cell has been populated with the logic of any value then no notification alert is…
-
Automated workflow change cell not trigerring
Hi all, I am trying to set up a workflow in a very basic way in a Smartsheet. Basically that would be: When the tickbox is cheched in a field called "done", then change status to "closed. Despite all my efforts the status field remains the same. I am attaching a workflow configuration screenshot: Thanks for your help !
-
Form not working
Hello everyone, so my issue with the form - I have several forms (I am not the owner for all of them) that do not work correctly. Everytime that I try to submit it, it loads for a long time (15 minutes average) and then a red error message pops up : I am not sure where is the problem? It tells me to contact the owner, but…
-
Core App Skills Badge not visible
I have completed the Smartsheet Foundations Path and have passed the Quiz; but I don't see my Core App Skills Badge anywhere on my profile. How do i get it? I have checked for the badge by logging to the community too. In the notifications section, there is a comment saying, "Congratulations! You've been promoted to Level…
-
"When Triggered" Automations Behaviour
A colleague of mine has sent me a question that has stumped me and has got me thinking my understanding of how automations work has been wrong. She sent me the following: We have automations that are set up to send when triggered that send emails to support when someone requests access to one of our products and also a…
-
Automating Document Generation and Print
We would like to automate the following: "When a row is added, generate a specific document, and print to a specific printer". The idea is that the visitor to the office fills in a form with their details and then those details are printed on a label using a specific printer (using "Document…
-
Report Notification
Hello Smartsheet community! We’re hoping to get some guidance and see what's possible. Our staff would like to get notified of all past due tasks in a single aggregated email reminder (they get too many emails, so aggregated information is essential). Here's what we think our ideal scenario is, but any guidance would be…
-
Unable to create bar chart from two columns that are not adjacent to each other
I have a smart sheet that has in its first column ( the primary column) a list of widgets, A, B, C, D, and so on. The next column is titled August and across from each widget, August column shows how many widgets were sold. ie 8, 2, 16, 30, and etc where 8 corresponds to Widget A, and 2 corresponds to Widget B and so on.…
-
Setting up a Project Portfolio- next steps
Hi all, I am new to the community and pretty new to Smart Sheets. I have been tasked with creating a project portfolio with a hopper of projects ready to start when resources become available. I have built the project portfolio linked to the individual projects but it is static at the moment. To get the next phase I have…