-
#Incorrect Argument??
I'm trying to build an IF statement that will change the value in a Status column. The Status column has three values in the dropdown (Not Started, In Progress, Complete). I would like to leverage two adjacent Date columns (Scan Started, Scan Completed) to auto-change the values in the Status column, but can't seem to getโฆ
-
Smartsheet in Commercial Real Estate
My team is working on incorporating smartsheet for our landlord and tenant rep clients, as well as our team. Any suggestions on best templates, etc to use?
-
Combining IF formulas to Return Text Values
I have 3 columns; Start Date, End Date, Progress I can get the following formulas to work separately for row 17: =IF([Start Date]17 < TODAY(), "In Progress", "Not Started") Returns in the Progress column =IF([End Date]17 < TODAY(), "Overdue") Returns in the Progress column. I want to combine these 2 formulas in one cell toโฆ
-
Changing a Date (mm/dd/yyyy) to Month Year (January 2019)
I copied this from another post and simply substituted my date range (from another sheet) and It is returning "UNPARSEABLE". Any suggestions? =IFERROR(IF(MONTH(@{Quality Database Range 1}@row) = 1, "January ", IF(MONTH(@{Quality Database Range 1}@row) = 2, "February ", IF(MONTH(@{Quality Database Range 1}@row) = 3, "Marchโฆ
-
IF and OR Formula
Hi, I am trying to write a formula that returns a flag ifย one of column 1,2,3,4,5,6,7 isn't checked. I have tried using the IF and OR formula together but am getting #Unparseable. Any ideas/help will be appreciated. Thanks
-
VLookup - Multiple Searching Criteria
Hi all, I am struggling to find a way that allows Vlookup to search with multiple criteria in two columns. Referring to the screenshots - On the worklist sheet my aim is to VLookup into the Forms Testing Sheet and the criteria be both the agent name (Row two on the Worklist) and The Week Numbers above (Row one on theโฆ
-
Look up blank cell and add a value in another column on the same row
Can someone show me how to write a forumla that will look up if a cell in the column "Critical date" is populated enter 1 in column "CD2" on the same row. Essentially what I'm trying to do is run a report that summarises all my critical dates but I can't select that date column in my report. If there is a better way I'mโฆ
-
Help with Flag formula
I've tried a few different formulas using IF and ISBLANK but can't seem to figure this out, even after looking at a few post on here. Hoping you can help. I need help with creating a formula for the following: If a task is incomplete and the due date is in the past, aย red flag will appear BUTย if theย 'due date' cell isโฆ
-
If Statement Comparing Date of Text Entry Between Columns
We work from a running tracker were there are a series of dates (entered as text, not an actual date) are entered into different columns to signify when certain steps have been completed. I am trying to find a way to automate a flag or alert or something to designate how many days go between each step so we can easily seeโฆ
-
#INVALID DATA TYPE adding MONTH to COUNTIFS with cross-sheet refs
Hello all, using the following formula: =COUNTIFS({TACTICS design resource}, AND(@cell <> "", @cell <> "N/A"), {TACTICS status}, AND(@cell <> "Cancelled", @cell <> "On hold"), {TACTICS status}, <>"admin", {TACTICS project number}, <>"*N/A", @{TACTIC actual delivery date}, MONTH(@cell) = 12) I'm getting an #INVALID DATAโฆ