-
COUNTIFS for specific Months
Hi All, I have tried to read previous answer to similar questions but still just don't get it…. (excel is so much easier in some ways..) So far I have this formula: =COUNTIFS ({Push-In Job requests Range 2}, "Extrusion", {Push-In Job requests Range 3}, "Yes") But I want to break it into Months based in the Date received…
-
Logo Assistance
I have updated our company logo in smartsheets and the colors, but they do not change in any of our smartsheet, even when I create a new smartsheet template. It goes back to the old one. Anyone can assist with this?
-
Set Target End Date first and have predecessors fill in
Is there a way to set the Target End date in a project sheet first and have all the preceding dates backfill? When I tried it, an alert comes up that says "…will result in the removal of all predecessor relationships in this row". I've looked into the Workback Schedule using the Project with Hard Deadline and Gantt…
-
Parent/Child row formula
I have a project plan where the status can be any of the following drop downs - Complete, On Track, At Risk, Behind Schedule, Not Started, Discontinued. I need help with a formula that will adjust the parent status based on the children. If all children are complete = "Complete". If all children are On Track or Not Started…
-
Help!! :) IF, IF(AND(, IFERROR(INDEX,MACTH(
Trying to figure out the formula. I'm looking for 3 conditions here IF cell is "0" true insert "-" IF cell is "-" true insert "-" IF(AND cell is > "0" AND cell = "-" true insert "-" IFERROR(IDEX(MATCH Here is the formula: =IF([# Phones]@row = 0, "-", IF([# Phones]@row = "-", "-", IF(AND([# Tablets]@row > 0, [Phone MDM…
-
Dynamic drop downs- possible in smartsheets?
My boss recently challenged me to see if I could add some logic to our project plan smartsheet templates where if a user entered in an Assigned To column can dynamically narrow the values available in a Role column to show only the roles the person selected in the Assigned To column is eligible for. For example, let's say…
-
Notification Preferences reverting
Personal Settings -> Notification Preferences -> Sheet Change Notification setting continues to revert back to unchecked after some time, making automation testing challenging. What could be causing this?
-
Auto Assign to Created By
Hello, I'm looking for guidance on how I might auto assign a task to a person that created the task. Basically on create, assign the task to the person that created it. This way when in "Board View" grouped by status and filtered by "Assigned To" any new tasks would automatically show in the view. Currently the newly…
-
In the "Card View" is there away to auto apply the filter I currently have selected to a new card?
For example, I have a filter of all "tasks" for a specific project manager, so in the "Card View" I only see tasks/projects assigned to that specific Manager and nothing else, which is great. However, when I go to click the "+" sign to add a task/project quickly it doesn't auto apply the manager (aka the filter) to the new…
-
Rows Seemingly Moving by themselves
We have been using SmartSheets in our workshops for around 5 months now as a schedule but there is one issue we have not been able to figure out why it is doing it. The smartsheets I am referring to are schedules with parent rows as our "Job" and the children as steps within that job. We have an automatic locking on the…
