-
Counting and Dividing Certain Cells
I want to divide the number of requests that were completed on time by the total amount of requests submitted that month. I'm referencing another sheet in my formula. The following is giving me "UNPARSEABLE" =IF({On Time?} = "Yes", {Submitted Date}, YEAR(@cell) = 2023, {Submitted Date}, MONTH(@cell) = 1) / ({Submitted…
-
Check Multiple Conditions Until a Trigger is Found
I'm trying to set up multiple conditions to copy a row over once if one of those conditions is met. I have set up multiple workflows, but it's copying the row over for each condition that is met. What I'm trying to achieve: If condition A is met, copy the row over. If condition A is not met, but condition B is, copy the…
-
Can you stop automations from running on completed projects?
We have been getting hammered by an automation that runs automatically for all jobs that have been completed in the past month or older. Is there a way to stop these automations via global updates? We have a separate sheet for every project and the automations are getting triggered from those. I don't want to go in and…
-
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…
