-
Using COUNTIF and OR Function
i am currently using the following formula to control a parent reporting "Ready" or "Not Ready": =IF(COUNT(CHILDREN()) = COUNTIF(CHILDREN(), "COMPLETE"), "COMPLETE", "Not Ready") I would like to add an "OR" function to this to allow both "COMPLETE" and "NOT REQUIRED" to trigger the parent "Ready". Can you help me…
-
Max(Collect formula
I'm trying to pull in the most recent date of a file, and it looks like =Max(Collect is the way to do it, but I'm having trouble with getting the formula to work. Currently, I have =MAX(COLLECT({Date of Recent Update}, {Parent Folder}, [Delivery Path]@row)) where Parent Folder and Delivery Path would be the reference to…
-
Create Percentage Based off # of Checkboxes Checked
1) Creating a percentage to tally how much out of each section is checked completed. 2) Then also need to setup a formula to do the same for the overall sheet including all subheaders. This is the formula I have so far for the individual subheader sections. But I keep getting Invalid Operation errors. Not sure what I'm…
-
Status Symbols from Multiple Date Columns
I'm looking to have a health status (green, yellow, red) populate by checking multiple columns with differing expiration dates. I'm trying to come up with a formula that will return the following status': IF[Orientation Date] is in the past and [First Aid Ex Date], [OTS Exp Date], [BBP Exp Date] are at all least 30 days in…
-
IF Function not returning as expected
Hello I have an IF function I am trying to run that evaluates a cell, and then returns one of two indexing formula results I have verified that each indexing function and the If function itself with different results all seem to work. But when I plug them together, my IF function stops evaluating "3100" properly, or it…
-
How to reference entire column from another sheet
Hi, I'm new to smartsheet and i would like to know how can i reference an entire column from another sheet, no criteria needed. I just want to return the data from sheet 1 column 1 to sheet 2 column 1, is there a simple way to achieve this? I have tried to use =INDEX({SHEET 1 RANGE 1}, 1), it will only return data from the…
-
Timestamping
Hello. Is there currently anyway to do timestamping in Smartsheets? For instance, timestamping a cell when a tick box cell is ticked? Thanks Andrew
-
Looking to auto populate red flag for overdue invoice
Im having trouble figuring out a formula to create a flag in the overdue column when the due date is in the past and the status is pending or delayed. Flag needs to disapper once status changes to paid Picture for reference
-
Concatenate formula with IFBLANK
We are trying to move some of our more complex templates into Smartsheet but we're having trouble converting the concatenate with blank formulas from excel into smartsheet. For example we have this formula in excel =IF(M2="","New",M2), and all I can seem to get to in Smartsheet is =IF(ISBLANK([If nothing is indicated,…
-
Is there a Formula (Set of Formulas) that can check multiple dropdowns from other data column?
I have a Metrics sheet in which I'm trying to populate a dropdown list (multiple values) with building types from client portfolios. As an example Client A could have 5 buildings: 3 Office, 1 Industrial, and 1 Warehouse; Client B has only 5 buildings as well: but all are Office. The client buildings are in a sheet with all…
