-
#Invalid Operation Error subtracting days from another Date field
I have a sheet that has a date field that is link in from another sheet (actually 2 other sheets) that is not working as expected and I cannot seem to root cause the issue. I have a column 75%/SD Date that I want to get 14 days before it in another column. Below are some things I have put in for the formula and the result…
-
Can I include a date from another sheet into a formula for my current sheet?
Hello. I'm pretty new to Smartsheet and can't find an answer to today's dilemma. For example, I have a two sheets: ABC Project (belongs to me) and XYZ Project (belongs to our vendor) I want to be able to calculate a start date on one of my tasks in ABC Project by pulling a finish date from XYZ Project? Basically like this:…
-
Date updating to Next Day using Index, Match, Max, Collect Formula
Hi, I'm working with two Smartsheets. (1) One sheet collects the data from a Smartsheet form. I added two columns to this sheet using the Auto-Number/System Feature (under Edit Column Properties). This features stamps new row entries with a date/time (Created) and by whom (Created By). I'm curious about the cell surrounded…
-
Problem with vlookup calculations
I am having a new problem with an existing Smartsheet that has worked fine until now. Existing workflows have stopped working. The problem does not appear to be workflow, but something else going on. We have a workflow that triggers off of a calculated field that is based on data in another Smartsheet. Users enter data…
-
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…
