-
Is there a way to have a date change in autofill within a formula?
I am looking to shift the way my data is displayed so I can place it in a dashboard. To do this, I'd like to shift the information within to do a specific date and return that. My formula works fine, but I have to change the date for every single line. Wondering if there's a shortcut or something that I could do to avoid…
-
Workflow automation for when a cell in a column does not change status
Trying to see if there is a work around for setting up a workflow automation to trigger when a status column does NOT changes status from planning to in progress after 14 days. I only see triggers for when a column or row has changed, but nothing for when a column doesn't change. Any suggestions?
-
What is the date format applied when using a data placeholder in the message body of an alert?
I have a date field in the sheet and have formatted the date column with dd-mmm-yyyy. This format does not flow through with alert messages. Please advise what the standard format is that is applied as I would like to include information in the body of the message that informs this as my stakeholders are from all over the…
-
Separate Email Notification per Form Submissions
Hello, Is it possible to have a separate notification per form entry? I've setup a form where people are submitting a ticket and, sometimes tickets are entered within a couple of seconds within each other, and Smartsheet automation creates one Email notification for both the line items. This can cause us to potentially…
-
copy rows automation with date formula
I have two sheets - one with routine tasks, the other with a list of assigned tasks. I have an automation built into the first sheet to copy rows to the second sheet on a regular basis. The first sheet has a date column which uses the TODAY() function. I'm having a problem with items appearing on the second sheet with the…
-
Managing Move/Copy Row Automation
Hello I have an employee database stored in Smartsheet. I've connected an onboarding form to a separate sheet which gathers sensitive data. I want to move that information over to the database, but not have some of the sensitive data come over with it (other people need access to the database). I know it'll drop all…
-
Assistance w/ automated Checkbox based on multiple conditions
Hi All, I'm after some assistance regarding a formula to automate a checkbox based on multiple conditions. These are; Column "Requested by" is populated with a date. Column "Site" is populated. Column "Site contact" is populated. Column "Quantity" is populated. Column "Product" contains the word "Device" Then a sum is used…
-
Row/Column Level Access
I have sheet on which people from multiple departments will have access to. A couple of my requirements: 1) I'd like certain departments to be able to see only the data in specific columns only relevant to them. Is this possible? 2) There are 3-4 attachments that will be added to the rows. I do not want departments having…
-
automation copying rows when conditions should send update request instead
Hello, I have a scheduling sheet where users update an existing row to reserve a meeting time. My automation workflow states to copy rows changed IF three fields are NOT blank Otherwise send an update request for missing field info. The issue: Rows are copying even when one or more of the three fields are blank AND even…
-
Reporting Hierarchy
I have a sheet with several parent, child and grandchild rows. I'm creating a Report from this sheet but I am unable to filter and see child or grandchild wise. I have created a WBS System (1, 1.1, 1.1.1 -> Parent,Child,Grandchild) as well but unable to group/filter using this. Is there any work around for this?
