-
Formula to add check to checkbox based on several other checkboxes
Hi all, I am trying to create a formula that adds a check to a checkbox once a check has been added to 5 other checkbox fields in the same row. The other checkboxes are also automated and are checked based on other criteria (however, I don't think that matters here). Below is what I have so far, basically if ALL of these…
-
Countif value matching from multiselect cell
Please help, i have 2 sheets. One sheet contains week no. i.e. the week in which a member is absent. I wanted to count week numbers from that column only if week number is mentioned in other sheet under (multi select cell). Ì used this COUNTIFS({Team Vacation Planner Range 2}, [Assigned To]@row, {Team Vacation Planner…
-
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…