-
If Cells not blank equal max date
I have a sheet with 7 columns that have dates (was checkboxes but could not get it to work) I want an 8th column to populate the max date from the 7 columns ONLY if all columns have a date entered. Basically I am tracking when people submit multiple documents, once all are submitted (i.e all dates entered) I issue them a…
-
Change column cells based on different column input
Hi, I'm trying to create a formula that will change a cell in a particular column if the value in another column is Yes or No. For example, I have a column of statuses and another column confirming if it's an issue or not. If the issue column says Yes, I want the cell in that row in the status column to say Assigned. Been…
-
How to make % frequency chart in dashboard (reasons for QC failure)
Hi, I am trying to make a chart in my dashboard that displays the reasons for QC failure as a percentage of overall frequency. The input is from a sheet with a column as shown below. You can select the mode of failure from a dropdown menu, and can select multiple items if there are multiple modes of failure. "In Dashboard"…
-
Column Formula with VLOOKUP using External Reference
I love the new column formula functionality! I'm converting to it whenever possible. I am trying to create a column formula that includes a VLOOKUP that uses an external reference for the data set. =VLOOKUP($ROWID@row, {~ Master List Range 1}, 2, false) I am getting an error message, and I think it's because of the…
-
Inventory Status: Reordered (How do I do it?)
Hello, I am developing an inventory reorder system and I need the status of the line item to show "Reordered" when the check box is checked under "Order Status" I recognize that there are multiple true statements within my formula so how can I show "Reordered" while the stock quantity is below the ROP? I have been trying…
-
Gathering data from 1000 sheets
Hello, i have this question: We have more then 1000 sheets with some project progress calculated in certain cell. Then we have one master tracking sheet with 1 line = 1 project. What i need is: Link this progress number from each sheet to every corresponding line Use that number for further calculations (which is not a…
-
URL Query string did not move with "Save as New" How to remedy?
I used a test workspace to create 2 data base sheets. One to hold existing info and one to hold newly created info based on existing. Users create this new data by clicking a URL to get to a form. I created a form and appended a query string to the form URL such that when a person clicks the URL, information from the URL…
-
Compiling Inventory Data Living Across Multiple Columns
Hi everyone! I am in the process of creating an inventory tracking sheet. Long story short, i built a form to keep track of inventory being taken out, and it offers 5 chances (so they drop into 5 different columns) to track any products counts taken out. I would like to be able to take those 5 numbers and compile them into…
-
Formula cross referencing sheet via template
Hello! I have a workflow created using Zapier so that when a new row is added to my master project sheet via a form entry it will update the first row in a template sheet and create a new project sheet from that sample sheet. This all works great with the exception I have one formula that uses a vlookup to tell the status…
-
Where can I find a smartsheet's consultant??
Looking for a consultant to help our business maximize how we currently use Smartsheet. Needing someone with expertise in offering opinions and solutions for our needs. We are wanting to revamp our processes and utilize the dashboards, reports and automations. Would love someone that will offer guidance and that will build…
