-
Automation not working consistently
Hello everyone, I am getting inconsistent results with the following automation on some of my sheets. Some of these are working fine but here is an example of one that is not: The workflow itself is fine because I can manually run it and alerts will be sent. So my problem is really only that the Assignees above will not…
-
Duplicate Notifications and to Everyone in the Workflow
Issue: The notifications for the CD level and RVP level are duplicating and sending to everyone in the workflow. 😬 Something is wrong with the workflows I created. Sheet Design Each row has someone assigned {Response Assigned to} to add the response to the {Center Responses} column. The person in the {Response Approved By}…
-
How to make Networkdays formula display less than 0 values
Hello, I am having multiple issues with my calculations using MAX and NETWORKDAYS. In the “Invoice Variance” field my numbers are displaying as negative numbers using the following formula =MAX(NETWORKDAYS([Invoice Submission Due Date]@row, [Original Invoice Receipt Date]@row, [Resubmitted Invoice Receipt Date]1:[2nd…
-
Clear check-box, without clearing associated Due Date columns
Hi I'm setting up a sheet for reoccurring tasks that have different intervals. I have a task column, interval column, last check, next check and a check- box. When the checkbox is ticked the Last check updates to todays date and this updates the Next check date, calculated from the number of days in the interval column. Is…
-
How can I create an automation so the person filling out the form receives an automated email?
Hello! I have an automation already set up so that I will get an email when someone fills out my form. However I would like whoever completes the form to get an automated email saying "Thank you for your submission. We will respond within 3 business days." Is this possible? Thank you!
-
Update TODAY() function automatically improvements
Hello SS Community, I have been using the required automation to update my sheets automatically since I am using the TODAY() function on my rows. The current setup I have is to check an unchecked box and vice versa. Other solutions found here:…
-
Workflow - list historical values on cell(s) based on criteria
Automation option that will list the cell history in a similar format that is available with the cell view history.
-
Workflow- trigger and output inconsistencies
I've built out the following workflow to notify our PMs of any newly inserted row AND change cell value on two columns in added row. The workflow is not sending notifications during my testing, but has been populating the formulas as intended when I add rows to the sheet. When I manually run the workflow and notify myself,…
-
Simple lock row automation doesn't work 100% of time
I have an automation to lock a row once a check box is manually checked off in a report. However, it only works about 80% of the time. I have another automation to unlock the row when unchecked as well however, about 20% of the rows that are checked are never locked. I'm thinking a workaround could be a move row when check…
-
Automate applying contact to cell after using form to submit data
I am using a form to gather request information from users outside of Smartsheet. I cannot ask all of the target form users to create a Smartsheet account, which makes what I would like to do probably more difficult. Is there a way to have the cell that I am currently having users put their name into when they submit the…