-
How do I make formulas automatically carry down to the next line when a new form is submitted?
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 automatically to each line as new forms are submitted. How do I do this?
-
Automate checking a box if date column is less than 2 weeks?
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 you!
-
Using Workflows to Populate Cell Values
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, Quinn
-
% Complete in Project Template seems to be off.
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 19% Does anyone have a logical explanation for this?
-
Making automatic links between sheets
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 and Cat There is an sheet called Dog. If the person who completes the form chooses the Dog option, the some new entries in…
-
Row Copying Issue
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: When a Row is Changed When: <Field> Changes to Any Value Run Workflow When Triggered So, everything pulled into the sheet…
-
Automations - Enable field and status updates in Card Templates
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: Status(s): Backlog, Current, Complete Field(s): Description, Due Date, Done (check field) Now let's assume I want to make sure…
-
Copy rows in automation leave original sheet but don't appear on new sheet
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/appeared in the sheet they were meant to be move to. Help!
-
Multi-Select & Automated Notifications
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. My question is - is there a way (using Conditions, Formulas, etc.) that I can setup one Automated Notification that would…
-
Quick Auto Pop-Up Form As Part of an Automation
We have a sheet where all our RFQ's are entered. I have created an automation where as soon as the Status of the RFQ is changed to Sent it automatically copies the sheet to a Quote Register /Pipeline. I wondered if it was possible that as part of the automation, when the status is changed a quick form pops-up where the…