I am trying to add a "data validation" to check that a serial # entered has exactly 10 characters (letters or numbers). I saw someone reference using a LEN count, but I do not see a way to use this function in a workflow. Is this possible?
So currently if I send an update request it sends a unique URL https://app.smartsheet.com/b/updaterequest?ux=Wg-0K6UjB-ez37UYkK5dM1aOEibFCPmn.... Can I somehow attach each of these unique URLs to the specific row???
Hello Smartsheets Community, I am having an issue getting an workflow automation to run completely. High level, someone fills out a form and submits it. The order of the workflow is as such: The workflow is triggered based on when the requestor is filled in. Next, there is a condition that states if the director name is…
Hi, Hopefully there is a possible solution to what I'm trying to do: We have teams who have their own project lists I've created a project intake form/sheet and want to set up an automation that copies the rows to their individual project lists I know that if there's common columns across all sheets, then it'll move over…
I know Smartsheet offers some professional service like this - but is there a way to learn how to do this independently? Here is what I am trying to do. When a new project comes in (a new client) we ask them which software and hardware technologies that we are going to provide for them. Each one they choose, has a unique…
Not sure how to explain this. I have attached a photo of how its done in Excel and the actual smartsheet. I have a migration state date of July 28th and several tasks after. I need the cell in start time to change if I decrease or increase the lead time. I cant figure out any formula or if its even possible. Excel Example…
If you run your schedule out of Smartsheet, how do you hand attaching checklists to certain tasks? For instance, we might want to add a Q/A checklist to a flooring installation task to check for items like finish, correct item installed, clean/well-done, etc. I would rather not add additional rows to the sheet to…
Several years ago I could trigger a Smartsheet email notification when the value in a cell changed. Under the current automation capability that doesn't seem possible anymore. I use automated workflows extensively and I trigger them from reports or from within a sheet that contains the workflows. What I'm trying to do now…
I have a bar chart (below) where i have positive and negative numbers. How can i have the bar representing the negative number to be red, while the others blue?
Is it possible to nofify/alert someone using an automation with these characteristics: Send an attachment in the notification Not sending the link to the sheet Thanks for your responses!!
I am trying to have a sheet that reports multiple sheets. I have merged cells and that works but I am looking to merge a whole row of dates to a single cell with the most current date featured.
Our whole operation has ground to a halt as the cell limit of 500,000 has been hit. I reduced the number of columns such that the total amount of cells is now well under 500,000. Yet the sheet and form attached still remains inactive. How do I reactivate? Thanks for any assistance from the Smartsheet community. Rgds, Dave
Good Morning, I am having a difficult time trying to find a solution for the following: I have built a Smartsheet and form to collect data from my clients. Many of the fields are pre-populated with data that does not need to change. This would include the client's contact information and other data points. I need to send…
Help shape the future of Smartsheet. Share your ideas and feature requests.