-
How Can I update certain cells in a another sheet when a row is added to original submission sheet?
Hi, I'm new to Smartsheet I have two sheets. The first sheet holds information submitted via a form The second sheet holds similar information but its data is used for a dashboard ( Usually, an employee will submit a form and a new row will be added to the submission sheet (first sheet). I will take certain data points…
-
Inventory Management (relationship workaround)
Hi, I haven't actually started this in Smartsheet because I don't know where to start. I have an inventory list (excel) that itemizes on multiple rows against one PO#. Like this: Line 1. PO# 12345 Item: Desk Qty 5 Line 2. PO# 12345 Item: Table Qty 4 Line 3. PO# 55555 Item: Chair Qty 3 I am trying to see how I can get that…
-
Re-occuring "Row" event reminder
Allow a row reminder to be set to repeat, I.e., every 3rd Thursday, every Sept 1st, etc.… over a more extended period vs. one at a time and having to recreate it. The current process is a more involved task of creating a workflow and setting conditions for EVERY row that needs a reoccurrence.
-
Contains function
I am having trouble with a formula that contains multiple "If(contains)" function. The following returns unparsable. =IF(CONTAINS("52", [Account #]@row), "52", IF(CONTAINS("53", [Account #]@row), "53", IF(CONTAINS(“54”, [Account #]@row)”54”, "")))
-
Data Shuttle Formatting for Multi Select Fields
In a world that looks at automations and limit human intervention to reduce risk and resources, the standardization of how data is imported and exported through Data Shuttle is inconsistent forcing human intervention as a work around. It would be helpful if the export/offload of multi select fields through Data Shuttle can…
-
How do I send an immediate update request followed by recurring update requests until completed?
My current attempt: 1) When rows are added, update 'Status' to 'Pending Update' 2) When rows are added or changed AND when 'Status' changes to 'Pending Update', request an update (this is the immediate/initial update request) 3) When rows are added or changed AND when 'Status' changes to 'Pending Update', record a date in…
-
Clear a Sheet on a Schedule
Hello lovely community, I need some help figuring out the best mechanism for clearing a sheet on a schedule. It really should be easier than this! I have tried the following methods, and outlined the limitations and issues below. I would LOVE to get some suggestions for other methods! Problem: I need to fully clear (delete…
-
Can index+match be used to add values together?
I'm in the process of creating a series of sheets to track weights submitted by a variety of people. The people are going to be categorized by 'team', and I already have an index+match formula that takes their submissions and automatically organizes them to like a main row per person, each value going into the column for…
-
Issues with Automations on Calculated Fields
I have a task tracker for our team that I want to auto-archive tasks 5 days after they are complete. I built a checkbox column that compares the completed date to todays date (using a reference rather than TODAY() formula so the formula works when I'm not in the sheet) and if it's been 5 days it checks the box - which in…
-
Autofill Form
So if I have a purchase request form I want to select Item A, for example Once I select that, I want it to give me than a list of budget numbers to pull it out of (Item A for engineering, Item A for software, etc.) Then autofill with a set price, and I put how many I need and/or show me how many are currently budgeted for…
