-
Formula to return different values
Hello, I am trying to write a formula to return one value if a certain criteria is met, and a different value if that criteria is not met. What I have is below. It's not working, but I'm not sure how to fix it. Any ideas? =IF(Dates@row <= $Dates$2, SUM([Actual Cumulative Labor]10 + [Planned Billable Labor]10), ""),…
-
FORMULA FOR IGNORING A BLANK CELL WITHIN A COLUMN WITH FORMULA SET
Hello, I want to count the number of days from task set vs the due date set. I know the formula for that which is NETDAYS however, on empty spaces that I don't want filled in, INVALID DATA shows. So I want to know how to ignore the formula on blank cells. Can someone help me please? Column names: Original End Date, New End…
-
Sheet Name within a Cell
Hello, I was wondering if it is possible to write the current SS Sheet name to a cell that you are working on? The reason that i am checking this functionality is due to how certain project plans are created within a Workspace and i need to filter out within a report. Thanks, Anthony
-
CountIf with Multiple Criteria + Mutli-Sheet Reference
Hello, I am trying to count total items in "Medium" item in PRIORITY Column that also have a status of "Done" in the STATUS Column. Both PRIORITY and STATUS columns are in the SCRUM: Communications sheet. Here's my current formula (which is reciving a #INCORRECT ARGUMENT SET error): =COUNTIF({ SCRUM: Communications…
-
IF Statement
Hello! I was wondering if anyone could help get me started on carrying out what I think will be a very long IF/AND statement. See attachments - I've created a formula to read the department column and the output will be the employee that has been entered into the top grey section in the Assigned To column. My issue is that…
-
Using AND with IF to check two text fields
Hi All, I am trying to create a formula in a sheet that references a range from another sheet to work out IF 2 text conditions are true but not sure of the syntax. Can I get some help please with my attempt below; Range 1 is a single select drop down using text Range 2 is a single select drop down using numbers 0-10 I want…
-
Return Column Names AND values from row in a reference column
I'm trying to figure out how to return the columns and values found in them for any given row. I have approximately 200 unique columns that are populated from a web form if/when the column is relevant. individual rows track construction items completed. Each row identifies crew, date, job number, etc., and the remaining…
-
Formula Help, conditional formatting/If statement
I need a calculation to occur when criteria are met in another cell. For example, I want column D1 to reflect the following: if column A1 contains "Yes", I want the sheet to multiply column C1 by .10. If A1 contains, "No". I want either no action or a zero to be entered into D1. Any guidance would be appreciated!
-
Solution for spreadsheet VLookUp type function from another sheet to populate drop down?
I'm looking to populate a dropdown based on "VLookUp" values from another sheet. Is there a clever way to mimic a dynamic drop-down based on another sheet in Smartsheet?
-
CountIf Status Last 30 Days & Next 90 Days
Hello, I have a sheet that has a columns that include Status, Start Date & Finish Date. I need a countif formula that will pull back how many Completed (Status) have fallen within the last 30 days (Finish Date). I need a countif formula that will pull back how many Not Started (Status) will fall within the next the 90 days…