I can see that a form will populate data into the next available row in Smartsheet. Can forms be used by other Team members to to gather and add info to pre-existing rows, governed by a specific date as an example?
Hi @Richie ,
I don't believe there's a way to use a form to update existing rows - only to add rows. However, you can use Update Requests - either manually issued for a specific row, or through automations - to request updates to specific fields or all data in a row.
Hope this helps!
Can update requests be automated, i.e. sent to the same person or group of people at the same time every day?
@Richie Yes, I believe! You can schedule them to be sent at scheduled intervals or when triggered (for example, when a date in that row is reached). Additionally, if you have a contact column where contacts are assigned to specific rows, you can set it to be sent to the contact for that specific row.
I'm sure this is super simple but myself and a colleague could not figure it out. I have some very simple data I need graphed for a project: Not Started, In Progress, Complete and then % Complete using the total. The pie chart for the Not Started etc. comes out correct: But when I ask it to graph just % complete, it does…
Hello, I am working on a training log for our company. I am trying to get the status color to turn green if training is completed, yellow if it is due in the future, and red if it is incomplete. I keep getting an incorrect argument. I had it working correctly when I was just doing red and green, but I really need that go…
Hi, I have a sheet that collects data from several forms. I have an automation that kicks off every Thursday at 5:00 AM to move all the data in the sheet to an archive sheet, I have another automation that is supposed to kick off at 8:00 on Thursday to check if the column is blank, then alert someone via an email to enter…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.