-
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…
-
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.
-
Burndown Chart
Hi Everyone, I have a question about how to drive a burndown report in a Project summary: I've built a burndown sheet that contains the Application Name, Baseline Finish, and Actual Finish dates. (Those three columns are linked to other project schedule sheets.) I've also built a Cutover Date column that lists every…
-
Need both Text and Contact List versions of people on same sheet
I have a PowerBI report that pulls data from a Sheet. When I use a contact list on the sheet, the email address shows on the report, not the name. The customer wants to see names, not email addresses. I need the contact list column because I have reports that filter on logged in user. I don't want people to have to enter…
-
Edit Smartsheet or Excel Template (can't locate)
I started using this smart sheet for study planning. I work FT and have a demanding study schedule. I needed to add time to the sheet (15 min. intervals would be preferred) but I can't figure out how to adjust it. I also can't locate this template anymore. Uploading for reference. A tally at the end (sum) for total hours…
-
construction cost estimate for installations
Can someone help me and give me an idea on how to create a cost estimate for installations, with a total for each chapter by groups, subgroups and types of work, but at the bottom of each chapter. https://us.v-cdn.net/6031209/uploads/0OSH46KSC2LH/cost-estimate.xlsx Thanks