-
Index Collect Formula Showing #Invalid Value
I've been searching around and my formula looks correct. I even saw on a previous discussion that you should erase the formula and then log out and log back into Smartsheet and maybe that will help (unfortunately it didn't for me). I've also tried to make the formula manually multiple times. The only thing I can think of…
-
Automated Reminder for Approval Request?
Hello, Is there an easy way to send an automated reminder based on an approval request? We automate approvals from some of our Smartsheets and would love for a reminder to be sent x days later if the approval status is still "Submitted". I can't find where I can build a reminder based on the status change plus a number of…
-
Count Collect formula assistance needed
Hey all, I'm using a Count Collect formula I grabbed from the PMO template as a baseline. Here's the original formula: =COUNT(COLLECT({Task ID}, {Task Status}, "In Progress", {Task Health}, $Label@row)) Only thing I changed from the PMO is instead of "Project" I changed it to "Task". I'm trying to get similar metrics on…
-
What formula do I use?
I have 2 sheets. Sheet one is a grading sheet that goes over appearance, aroma, feel ect. of a production lot. Sheet two is a stock list showing all production lots. Both sheets have the primary column set at Ample number (ID #'s). I want to use a formula in sheet two that copies the final grade from sheet one if the…
-
Combine two rows based on a unique identifier?
So my smartsheet randomly receives two entries with the same unique identifier with different rows filled out. For example, my smartsheet has the columns "machine", "material", and "program". entry 1 has the identifier xyz and fills out the "machine" and "material" columns. entry 2 has the identifier xyz and fills out the…
-
#NO MATCH Error when using VLOOKUP to look up the text displayed on a hyperlink
Hi! I'm trying to use vlookup to return data (a version number) using match data (document numbers). I have the VLOOKUP formula as =VLOOKUP([Document Number]1, {OP - Smartsheet Master Document List Range 2}, 7, false) where [Document Number]1 is a text/number column on the sheet I am working in {OP - Smartsheet Master…
-
Count from another sheet
Hi, I have 2x sheets OTIF-Sept and Report I am trying to Count the total KER -111111 orders and is incremented by 1 every new order. The count would count all orders in the Sept sheet so on a spare line if I use the following formula =COUNT([Order Number]:[Order Number]) I get the value I require. But if I run the below on…
-
Formula Help!
Hello! I have been working with this formula for hours and cannot figure out what I am doing wrong. I am trying to automate the health bubbles to turn Red, Yellow, Green and Blue based on where the task is in the start and due date. I got that part figured out. BUT I also want it to turn red if the "At Risk" column is…
-
Distinct/Index/Match with additioanl condition of having a box checked
Trying to use distinct index to pull in information to display the running total cost of an employee, but I only want it to pull in "Current Employees" Currently this formula works for ALL employees past and present. =(INDEX(DISTINCT({EMPLOYEE}), Number@row) I would like to add on to this formula to ONLY include employees…
-
Start Dates Are Earlier than Target Dates
We have a project that was pushed up on the timeline so the target dates are later than the actual dates. This is causing a negative Schedule Delta & a negative Schedule Delta (working days) due to the formulas. Is there a change I should make to the formula to reflect that this work is actually on time since it's before…