-
How can I update this formula to exclude a column?
=COUNTIFS({Territory}, HAS(@cell, $Territory2), {Domain Owner}, HAS(@cell, $[Tech Domain]2), {Status}, HAS(@cell, "Not Started")) - COUNTIFS({Territory}, HAS(@cell, $Territory2), {Domain Owner}, HAS(@cell, $[Tech Domain]2), {Status}, HAS(@cell, "Not Started"), {Post TSA}, 1). I need to add to the formula (I am not good at…
-
count tasks "on fly" per work week.
Hello Gentlemans , Do someone can give direction on how to count tasks "on fly" per work week. Example; task start 28.07.20 finish 28.08.20, this task will include in count WW31,32,33 and 34 till its finished. task start 10.08.20 finish 20.08.20. ww31 ww32 ww 33 ww34 1 task 2 tasks 2 tasks 1 task
-
How do I get the % to stay at 100% and not 150%?
How can I get the Completion Rate to only show 100% rather than 150%?
-
Overall Total % completed
Sorry If this is a repeat but the first post seemed to have disappeared. My Goal is to have the Top row #1 Where that checkbox is to say what the total of completed of all the subtaks below. For example the Level 4 is showing 100% completed so the Top row should show 25% completed. But Not sure how to accomplish this? Each…
-
Why is my COUNTIFS formula counting more items than necessary?
Hi all! I'm currently using the following formula (with references) to count the amount of items that fit a certain criteria (91-180 days, 181-270 days, and >270 days): =COUNTIFS({Age Grouping}, "desired amount of days") The formula works perfectly for the first two criteria, however, when it counts ">270 days", it returns…
-
Copy folder error
I have created a folder containing 15 sheets with various links to reference sheets (outside of this folder) and datameshing. The idea is that I can copy the folder, change a cell reference (location) and the new folder will update with the reference data for that location. I've "saved as new" the folder and gotten an…
-
Formula for totalling specific options
hello! I have a sheet for a menu of options. We are building kits of different swag items and the sheet has 5 different options with different price breaks. I'd like a sales rep to be able to go in and select different options then see a kit price. I was thinking I could add a check box column then pull a report on that…
-
Auto-populate a value in the cell of a column, based on previous values
Hi, Appreciate your help! I have a sheet, where Auto-number is taken up for the first column. I have a Priority Column, which I want to auto-populate based on if the number already exists. Item # | Item Requested | Priority 21 | Test 1 | 1 23 | Test 2 | 2 24 | Test | 3 25 | Test | ---here the number should auto-populate as…
-
Trouble with Formula for RYG/Health/Status Columns
Hi There, I'm brand new to Smart Sheet and still learning the abundance of inner workings - hoping to find some help with what is probably an easy formula but I can't seem to get it right! I'm trying to change the color of the RYG ball under my 'Health' column based on the 'Status' column. For instance: Red = Canceled/Not…
-
Splitting form data from multi-select field into multiple columns on sheet
I am trying to use SmartSheet to send out a form to vendors that allows them to select choices in a Multi-Select field. I then need to have the choices the vendors selected in the multi-select field split out into a binary type of indicator on multiple columns in the SmartSheet in order to use the data in a meaningful way.…
