-
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…
-
AI Tool for Business plan users
Will the AI Tool be made available in some form for Business plan users at some point? This would really benefit me creating formulas, I've always struggled with them! 😣 Please consider!
-
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. Thanks