-
Checking a box using an OR statement
Hello, I'm trying to check a box if either of these are true: Data Upload Status = Operational Data Upload Status = 1st Upload Done I'm using this formula but getting an "Incorrect Argument Set" error: =IF(OR([Data Upload Status]@row = "Operational", [Data Upload Status]@row = "1st HydraCor Upload Done", 1)) Thanks for…
-
Date or N/A in a cell
I am trying to figure out a column formula that will auto-populate a cell with either a date or an N/A: N/A, if the [TOTAL BUDGET] cell is under $100,000 or =[Final Report Due]@row + 15 if the [TOTAL BUDGET] cell@row is $100,000 or more (this would be the audit report due date) I tried this but it's not quite working:…
-
Sheet Summary Formula versus Sheet/Report Filtering
Hi all, I've been scratching my head on this for a while and I can't resolve why the filtering I do on a sheet/report is not matching my formula on a sheet (upon which the report is based on). Here it goes: I have an intake sheet for my projects that when a PM creates a project via Control Centre, it spits out the expected…
-
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
