-
autopopulate the percentage complete based purely on the time passed
My goal is to have the percentage update automatically each day. If the task has a duration of 45 days and we are 3 days in, I need it to show the percentage complete. It would cap at 100% once it has reached the end date
-
I created a date column to generates dates by adding few fields but I am getting an invalidoperation
my formula is returning number of dates, as in adding dates.
-
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…
-
Formula to count # of tasks overdue based on date
What is a formula to count the # of tasks that are overdue, based on a date?
-
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…