-
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:…
-
INDEX No Match Issue
Hello, I have set-up a Smartsheet that links to another Smartsheet through INDEX matching. I use the same formulas for multiple drop-down selections that work properly on most but not on two of the selections. Do you have any recommendations to fix this issue?
-
Ghost workflow sending messages for old completed records
A team member received a workflow message from our main sheet last night for old completed records. I went through all the workflows; no workflow has that ID # (5968732796282756) or name. I can only assume this was one of the many workflows I deleted years ago when I took over managing the database. How do I stop a…
-
COUNTIF multiple criteria
I have two different data sets. One running over a year and one month to date. Some individuals have multiple entries with but used different names. For example John Doe and Johnny Doe. I need to count both as one so my formula for all data entry (which works) is: =COUNTIF({RangeName}, "John Doe") + COUNTIF({RangeName},…
-
Countifs Formula with 4 ranges is giving me a zero when there are 2 items in the raw data that match
I am using the following formula and getting zero for my result. When I filter the raw data there are 2 items that meet these criteria. I cannot find the error. =COUNTIFS({Current Performance}, CONTAINS([Primary Column]@row, @cell), {Job Family}, CONTAINS("Sales", @cell), {Month of Entry}, CONTAINS("Jan", @cell), {Year of…
-
Double Booking Dates
I am looking for some help on a meeting calendar for double booking the same date and time. I currently have it set up with this formula =IF(COUNTIFS(Date:Date, Date@row, [Start Time]:[Start Time], [Start Time]@row, [End Time]:[End Time], [End Time]@row) > 1, 1) This works for activating the flag in the column of the…
-
Hey everyone, does anyone know if there is a way to automate the go live date in Smartsheet's?
To be more specific, I am trying to adjust go live dates in our project plan, but I want to ensure that no matter how the dates are changed throughout the plan, that the go live date automatically adjusts to a Tuesday or Thursday date.
-
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…
