-
Trying to use IF and OR in combination for given scenerio
Hi, I have a requirement were I am checking values in 2 column using IF and OR and basis that the formula should return date after pre-defined days. I tried following statement but is it giving #INVALID ARGUMENT error. =IF(OR(Level@row = 1, [New/Existing]@row = "New Request"), DATE([Start Date]@row + 17), IF(OR(Level@row =…
-
#DivideBYZero
Good morning, I have this formula that is displaying this error as noting is filled out yet in the columns How to I not get this error and just have a 0 or leave it blank so it does not look bad? Thank you =SUM(BAE@row / (([HRS/Day]@row) * [Crew Size]@row))
-
Finding the earliest delivery date based on Material code as the criteria using MAX(COLLECT
I have a source sheet which is basically a delivery schedule for all materials with multiple delivery dates, what I want to pull to the target sheet is the earliest delivery date of that material code. Currently I have the following formula which doesn't seem to work! =MAX(COLLECT({EDD}, {STYLE}, [MATERIAL CODE]@row), 1)…
-
Can VLOOKUP Column_num return an answer from a colukn which is auto numbered?
Ive got a VLOOKUp to another sheet to work when the lookup_table is a single column, but when i extend the lookup_table to 6 columns, and the 'column-num' is 1, so left column of range, the formual doesnt work. It returns 'NO Match' when i know there is a match? If i do a lookup_table range of just the column i need to…
-
Using Or to Reference to Different Columns
Good Evening: Not sure how to add an Or to my Formula that Reference 2 Different Columns. I would like to add to my Count if the Id Column has Analysis or If the Issue Type Column has Task Current Formula which Returning an Error: =COUNTIFS({Sprint}, "ACAMS 2.0 SF - Sprint 9", {Bus Status}, "Done", {ID}, "Analysis", OR(…
-
Countif + Date Range
Hi I am looking to put together a dashboard, I'm currently working on my aggregation sheet - I'm trying to count how many times a persons name appears in last 7 days in the selected reference column from my main smartsheet, I'm happy with how to specify the range and the person however I can't quite figure out the date…
-
COUNTIF with Range
Hello! I'm using a COUNTIF formula to reference the number of times columns from a form are answered yes and no in the last two weeks. =COUNTIF({Range 3}, "No") The problem is when new forms are completed, the responses appear at the top of my sheet. I only want the range to be entries from the last two weeks (28 total),…
-
How can I only have an attachment sent via a workflow
At the moment I receive pay statement requests from staff. I have already created the workflow where if I make the attachment it will trigger the message. My problem is that it also sends the link to the page, and the recipients continue to request access to the sheet. I do not see any other options that do not include the…
-
Formula to auto calculate due date
I want to auto calculate the due date for monthly stock inventory. For February it will be 28 of the month, for the rest of the month to be 30th. Would appreciate your assistance. Thanks.
-
Referencing a Lookup Table
Good afternoon, I am rather new to Smartsheet formulas. I am trying to reference a lookup table column. Please see screenshot. In the main table, I would like e.g. "MM" to autopopulate when Mickey Mouse is entered in the FULLNAME column. Whether I try VLookup or Index/Match in the FULLNAME column of Main Table, I receive…
