-
Number of Days on hold from date entered and current date
I am new here, please be kind. I am trying to add the correct formula in my 'Days On Hold' column. To calculate how many days something has been on hold from the 'Date Entered'
-
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…
-
Automatically generated number
Hello, I am trying to build on Smartsheet a column that print a new consecutive number each time a request from a form is received. I want the following property for the numbers: consecutive numbers when 999 is reached, start again from 1 when the month changes, start again from 1 I have managed to build the feature with…
-
Vlookup and return only if no match
I'm having trouble. I want to do a cross sheet VLOOKUP and return the value from another column ONLY if its no match. Details: I have a "HRC code" column and a "status in HHAX" column on sheets 1 and 2. If the code on sheet 1 matches code on sheet 2 then I want to get the status in HHAX value from sheet 2 ONLY if it…
-
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…
-
Unparsable
Hello all, So, this is my formula; in excel it works and gives me the value that is correct, but in Smartsheet it says unparseable =IF(AND([Supplier Name]@row = [Supplier Name]1, [Funding Occurrence]@row = "Annual", [Paid (Yes/No)]@row = "", [Billed (Yes/No)]@row = "", TODAY() - [Billing Date]@row = >"320"), "Bill"…
-
25m Outbound Links Limit
Hello Does anyone know if there is a way to see what is the current amount of outbound links in the sheet (with reference to the information I found elsewhere: "there is an outbound cell limit of 25-million. This includes cross-sheet references, in-sheet cell references, column references, and range references."? This…
-
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…
-
How to split cell data from a drop down menu and add to another sheet to count totals
I have a sheet1 that staff from 3 locations uses to choose items they donated. in the drop-down item column, they can choose all the items they donated (in the same row). Ex: Merlin Ono from location TNP. on a separate sheet, I need to calculate the totals for each item donated from the dropdown column by store. so sheet 2…
-
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…
