-
Vlookup on reports
Hi I'm using a report to pull together a number of different sheets. I'm looking to do a vlookup on the report. Is this possible? If not can I select multiple sheets in one vlookup? Thanks
-
Simple Division formula resulting in error and should not be
I am having an issue with a simple averaging formula providing an incorrect outcome. In the example above the dollar amount in the DATA column is a result of a SIMIF formula. Additionally the results in Column4 are the results of a COUNTIFS formula. In Column 6 is a simple average formula that I wrapped in an if statement.…
-
Auto-assign # based on parent or child (sub-item)
I looking for a formula to auto-assign a number based on the parent/child level. For example, first level parent would be auto-assigned zero (0). Any sub-items would then be 1, 2, 3, etc. based on what level the item is listed under the parent. I've provided an example of how this would look, but I've manually entered in…
-
How do I count the number of stars when using the symbols columns?
How do I count the total number of stars when using the symbols columns? I have tried the count formula and it is only counting the number of cells and not the total number of stars, I have tried the sum formula and it is returning 0.
-
Formula to Count Criteria from Multiple Cells
Hi there, I have a reference sheet from which I need to reference two full columns... I need to write a formula to count the number of records where Column 1 equals A, and Column 2 equals B, C, or D. I have been working with =Countif and =Countifs but have been unable to find a suitable method of writing this formula. It…
-
Getting correct number of months between a date and today
Hello, I'm trying to work with a formula to find the number of months between a static date and today for a PTO sheet (see attached). I thought I had the formula worked out, but can't get it to seem to work.. Thanks, -Devon
-
Mandatory Fields on Smartsheets
Hi, Is there any way to make the category field and the risk level field mandatory for users to complete before they can change the status from open to closed in my Smartsheet? Currently we have users who are just closing the status without inserting an applicable category and risk level which is not desirable. I was…
-
Cross referencing formula
Hello, I am trying to reference cells from one sheet into another. My main sheet has a column where only some cells have a value. If the cell has a value, I want it to pull into my other sheet. Is there a formula for doing this? I could simply link the cells, but ideally I'd like it to update automatically every time a…
-
Formula Help
Hi All, I have an approval column which which clicked on, would like to have a tick/cross at the beginning of the row.. Essentially, if CSG Approval (Column 1) is approved, a green tick (as yes in column properties) should appear in Project Approval (column 2) vice versa, if rejected, should have a red cross (as no in…
-
MAX Function Error (#INVALID COLUMN VALUE)
Hello, I am working on creating a project plan. Instead of having the singular Status Update field that comes with the project plan template, I wanted to keep a log of status updates, then reflect the most recent info from that log in my project plan. I created a new sheet/grid with 3 columns. Weekly Comment, (automatic)…