I have apt #'s in the primary column and an end date column. The form has both columns as well. I need the end date to be posted in the appropriate row based on the apt#. Currently, the form creates a new row. Any suggestions? Thanks
Hi @Jerry J
Here's 2 suggestions depending on what you're doing.
Option 1: you could use an Automatic Update Request instead of a Form. The update request could trigger off of some value in a row; for example on a certain date or status met. You could include the apt # in the message so the user updates the correct job/task/row. You could have an assigned to column containing the information of the person who would get the request or set it up to go to the same person or people in the automation setup screen.
Option 2: you could create a report and group it by apt #. Still use the form to feed the sheet adding a new row, and the sheet would talk to the report where the work would be managed. Also still using the Automatic Update Request to pull information if needed. This could be useful for maintenance issues where each apt could have several issues overtime. A running "to-do" list for the tech when he or she arrives.
I hope that helps.
Smartsheet PLATINUM Partner
When managing a PMO. is it considered a best practice to establish an individual workspace for each project? If this is advisable, is there a method for setting up an automated recurring backup for all projects without having to do them individually?
Hello all! I have an automation workflow set up to record a date when a particular column changes to a specified value. Essentially I need to record a date when the "Current Stage" column changes to "Reevaluate/Schedule Final". See the workflow trigger screenshot below. I created this workflow and tested it on 11/16. It…
I use Outlook with my company. When a tagged email comes in from Smartsheets, I click on the "reply in Smartsheet" and it won't take me to any conversation box. It just opens the page, but not on the line that I need. Why is this happening? I updated this morning. Also, I get an Error message sometimes.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.