-
Is there a way to perform addition to an integer via an automation, workflow, or a formula?
I have a worksheet that tracks yearly tasks for technicians for potential raises or to track areas of focus. The problem: I need to track how many years a technician has met all the yearly checks. If they do then we want to perform add 1 onto their [Years Complete] value. [Current Year Potential] is a basic formula that…
-
Is there a method to determine which automation generated email?
I am receiving automation email, however I can't determine which automation created the email. I need to make corrections to the email. Is there a method or a clue within the email to determine which automation created the email?
-
Automation erroneously triggered
My question is how can the ZZ 10 Day Indicator col (see below) become starred if the Package Complete Date column and the ZZ Completed 10 Days Date is not populated? When this is starred it moves the row t an archive datasheet - and in this case it moved it prematurely, erroneously, and I can't for the life of me figure…
-
Transfer attachments between sheets
Is there a feature available to set up a workflow rule that triggers when a new attachment is added to the source sheet, the rule would then automate the transfer of that attachment to another sheet?
-
Configure Primary Domain in Safe Sharing
When we configured Safe Sharing this week, we added all of the domains in our organization except for the primary domain cswg.com. This did not limit any internal sheet sharing , but it did cause a firestorm of automations failing. Multiple licensed users suddenly received emails from SS saying one or more automations had…
-
Safe Sharing Awareness When Configuring Automations
If you have configured Safe Sharing, so that sheets cannot be shared outside of your organization(s), there is an option to prompt/lead users to a custom URL. This could be your own internal company policy or form. We have set up a custom dashboard where we have embedded both the text of our policy and a Smartsheet form to…
-
Replacing rows with automation
I have a sheet where I automate importing new rows whenever there is a change in spend. I want it to replace the previous row(s) that was imported with the same placement name so only the most recent one is visible. I'm thinking of some kind of formula that would populate on rows that have the same campaign name as other…
-
Removing the "Comments" tab from exported Excel reports
Hello, everyone! I have an automated Report that exports as an Excel file attachment to a team leader every week. He uses this report to upload info into a different system (not project management, a totally different thing). Each report comes with the report on one worksheet tab and a second worksheet tab called…
-
Can Smartsheet auto save immediately instead of after 1 min of inactivity?
Hi, My company is currently using Smartsheet for Onboarding tracking and workload. There are 10+ people working on the sheet and I wanted to know if there is a more immediate process to have the sheet auto save instead of saving after 1min of inactivity, that way everyone can see what is being worked on in real time?
-
Is there a way to troubleshoot automated emails not being sent consistently?
I have a smartsheet for accepting new work orders. I have an automation that emails the submitter know once their work order has been assigned. I am getting complaints from the submitters that they are not always getting the emails. I am not sure how to approach the problem. I cant figure out if the Activity Log records…
