-
Exchange values from SmartSheet to Resource Management
Hi all, Current situation: I have a sheet with budget data (Budget YAPed column) And now I want to have this budget in Resource Management. Normally this is how I do: Resource Management —> Projects —> Select project —> Project settings —> Add budget (screen below). —> My question: Is there any possibilities to migrate…
-
Is there a Limit to the Number of email addresses you can add to a workflow?
I created a workflow that if something is added to a field in the worksheet a workflow will trigger and send an e-mail to muptiple people that have been added to the workflow. I am trying to find out if there is a LIMIT to how many e-mail addresses you can have, I currently have over 40 and some people are getting this but…
-
I can't log in to Smart Sheet
Is the "500 Internal Server Error" message due to the problems the platform is experiencing today?
-
Bridge Workflows - Not able to add elements or states to workflow after adding Conditional Junction
Hi Community, I am building a workflow to automatically add 6 child rows to a parent row (which is entered by the user via forms). I am adding a conditional junction to check if the row is added by the bridge workflow or not. However, when I add that condition I am not able to add elements to the success state or fail…
-
APPROVAL SETTING VIA "ADVANCED OPTIONS" - APPROVAL WORKFLOW
Hi All, Need you support for the the issue. I was in the process of making an approval workflow for petty cash request, the problem was when i want to combine 2 different confirmation workflow by Requester to be appear in same column (Confirm), but mention notification like in the screenshot attached. The workflow consist…
-
How to delay the execution of a workflow whose trigger occurred much earlier?
I have a workflow that detects a row(date) that is changing its Fiscal Week Finish Date and send this row to other Sheet. Long story short: I collect delayed tasks in separate file & I tag reasons for delay for these tasks. It happens that plan are analyzed 2-3 hours and dates are being changed several times. I would like…
-
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
-
Issues with Attachments
Ok, I'm not new to Smartsheet but recently this simple automation has had me stumped. Pictured below is a simple automation we use to verify that an attachment has been added to each row in our system. IF attachment added or changed, THEN Change Cell Value. These worked beautifully all over our system until about a month…
-
New sheet created from template. Automated workflows being doubled/duplicated.
When creating a new sheet from a template that has automated workflows, the newly created sheet is duplicating each workflow. The result is that when using a template each automation is duplicated, resulting in double row copying, double notifications, etc. This seems to be a new behaviour as our team has been using these…
-
Automation Workflow "run once"
I have a date field that when reached I want to send a reminder email to the users. My question is will this automation literally run once when the next send reminder date is reached or will it run once each time one of those dates is reached.
-
Troubleshoot Workflows/notification not going to specific people (index/match formula driven)
Hello! I have a universal intake sheet to manage a variety of request. Assigned approvers are populated based on index/match formulas using a contact column. The notifications are working for everyone except one person. Oddly enough, when I push the notification as a test (and notify me), I don't get the notification…
-
Leave automation conditions in when workflows break
I recently got the "Workflow has been deactivated" email on a sheet that I inherited in a large workspace from a former team member. However, when I went in to troubleshoot the error, I was unable to because the name of the sheet it referenced was gone, replaced by "unknown sheet". It would be much more helpful if we could…
-
How do I have tiered authorizations?
https://us.v-cdn.net/6031209/uploads/9SX9INL2K24P/what-i-need-from-smartsheet.docx As noted in the attachment, what I am looking for is a system of sign-offs where each person can sign off on a document and then it automatically fowards to the next person in line OR if the have changes, it gets sent back to me.
-
AI to write sheet technical documents
AI should have the capability to generate technical documentation by analyzing column formulas and automations to produce a flowchart as well as a document explaining what the formulas do. This could save several hours of manual work. While platforms like Copilot can assist by analyzing formulas, the process remains…
-
Looking for Inspiration: Attendance reporting/matching
Hello Community, I am not sure where to start with this project: I have a class attendance sheet that I'd like to build further and I'm not sure where to go with it. Here are the parameters: I have several groups of participants (cast members for various entertainment productions). Each group has different numbers, as they…
-
Numbers in Form
My Regional Number Settings are: 2 500,00. In the Form, I have a field that only allows numbers. Form input rows to the worksheet. Unfortunately, the Form doesn't allow the "," entry. In the Form, the number must be entered as 2500.00. However, such a value transfered to the column (with setting as Text/number) in…
-
How do I include a hyperlink to a website in the "customize message" in a workflow?
I am trying to figure out how include a hyperlink to a website/resource in the "customize message" section of the "alert someone" filter in a workflow for people who submit content to our calendar. Is there a way to do this? Whenever I try to include, the link will not pull through when I paste in the box…
-
Copy Automation Workflows
When copying a workspace via API, I would like it to copy the automation workflows for each sheet, as it does when copying in the UI.
-
#Circular Reference
I am trying to create a workflow where if the "Pull Date" cell is in the next 14 days, the value in the Status column changes to "Upcoming". The workflow did not work. So, Smartsheet AI suggested formula =IF([Pull Date]@row <= TODAY() + 14, "Upcoming", Status@row ). I put this formula in the Status cell and get #Circular…
-
Workflow and attachments function (version control)
I have a workflow with approval request for several approvers in sequence. The email notification to the first approver shows several selected fields including the attachments. As the first approver has "editor" rights to the SmartSheet, this person will also have the option of "Upload Files" through the approval request…