-
Engage Track Sneak Peek: How Smartsheet uses Smartsheet
I have the honor of partnering with a number of colleagues from across the organization to bring you the "How Smartsheet uses Smartsheet" track as part of our annual Engage Conference this year! Real use cases provide so much inspiration and practical advice. How are YOU successfully using Smartsheet to drive work forward…
-
Updating Date Column if Another Column has been Changed
I am trying to create a formula to change a Date column to update to the current date when another column has been changed. I have used the TODAY function within IF but this updates the current date every time the sheet is opened and saved. I only want the Date cell to change when a specific other cell is changed.…
-
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…
