-
Calculate Days Past Due and/or Days to Complete
Problem: I want to calculate the number of days past the End Date or the number of days until the end date. If the End date is less than today, it would be "Overdue by " X days and if the End Date is greater than todays date, it would be "Days to Complete ". If the Status is Not Started or Completed, then leave the field…
-
Formula error - Incorrect argument set
I am trying to write a cross sheet formula and keep getting the incorrect argument set error. The formula I wrote is: =SUMIFS({Total Poles}, {Vendor}, "ALLO", {Date}, >=TODAY(-30)) My formula is stating that I sound sum the amount of poles where the vendor column is Allo and where the date column lists dates within the…
-
Updating Health Formula to Include Blue Status for Completed Tasks
This discussion was created from comments split from: Multiple IF/AND Formulas - Need Nesting Help.
-
Cross Sheet Countifs w/ Checkbox
I am trying to write a cross sheet countifs formula. (COUNTIFS({Ref. Sheet Column}, [Requirement Name]@row , {Ref Sheet Checkbox Column}, 1 > 0) Something isn't right as I am expecting to return a checkbox on the target sheet where the formula is being written based on the conditions of the source sheet. Thank you
-
Drop Down List
I would like to have a dropdown list based on a dropdown list from another column. EXAMPLE: Column A = Main Category (Accounting, Collections, Payables) Column B=Sub Category (If Column A is Accounting I would like Column B to only show drop down options (GL, Transfer, Set up, Close) associated with Accounting. If Column A…
-
COUNTIF a cell is NOTBLANK
I need help counting the data in a column if a cell on that row is not blank. I want the count of Serial numbers from the "Serial" column if the actual completion date field is blank. This is the current formula I am trying to use that is not working: =COUNTIFS([Actual Completion Date]:[Actual Completion Date], "",…
-
Trying to calculate total savings (Budget – Actual) when Column B contains both numbers and text
I have a Smartsheet with two columns: Column A Budget (numeric) Column B Actual Spend (mixed: numeric values, Blanks, or the text “NA”) I need a single formula that: Subtracts Actual Spend from Budget Includes only the rows where Actual Spend is numeric Ignores any rows where Actual Spend is blank or contains “NA”…
-
Average duration formula
I'm trying to get a formula for a sheet summary value to calculate average duration of rows where Risk Type = "EDAM Risk" and Status = "Resolved - Mitigated" or "Resolved - Decision." Assuming: Duration is in a column named Duration Risk Type is in a column named Type Status is in a column named Status I've been using the…
-
Is there any automation workflow which saves the sheet after the trigger
I have a sheet where it have some formulas which works on present date. Because of using today function in the formulas, the formulas are not getting updated until I open the sheet and click save.
-
IF(AND formula
Hi, I am using this formula =IF([Warranty Status]@row = "Warranty Expired", IF(AND([Asset Status]@row = "In-Stock), "Out Of Warranty","")) Its says the formula is unparseable. I can't figure out the issue with the formula. Help is appreciated.