Hi, we've been using a format where once a form is submitted, a row is copied to another "master" sheet that the team can manage off of. Recently, I've made some changes to the process (around when th…
I have a sheet that is being fed by a form. I am using a vlookup to add contact data from another sheet dependent on the email of the person who submitted the form. I want those vlookups to be added a…
I have a check box column (can be changed to symbol if needed), and Id like the box to check if the date in another column is less than 2 weeks from the current date. What would the formula be? Thank …
Hi, I'm trying to use workflows to auto-populate a Date Column. Example: When "Work Order State" changes to "Scheduled" populate a system time-stamp in "Scheduled Date". Is this possible? Thanks, Quin…
Working in a Smartsheet Project Template. I've put in my % complete info for each WSB row. The Parent % complete is reporting back 21%, while a selection of the rows shows that the average should be 1…
Hi there, here is the workflow: User enters data into a form (done). Form populates a sheet called Master_sheet (done). One of the entries of the form is a dropdown, lefts say for example: Dog, Fish a…
Hi I have a sheet, and in it there's a VLOOKUP to another sheet. I set a Copy Row Automation so that when the vlookup cell is filled, it should Copy the Row. I setup the Wrokflow like this: Trigger: W…
It would be wonderful if Automations could make specific updates to field and status values when using a Card Template. For example, let's use assume I am using the following template structure: Statu…
Hi- I set up an automation to copy rows with any value added in a specific column to a new sheet. When a value is added, the rows have disappeared from my original sheet however they have not moved/ap…
I'm trying to create an Automated Workflow for Requesting Budget Updates. We some times have to send out Update Requests for Monthly Budgets - obviously the number of months will vary client to client…