-
Percent Rollup Working Inconsistently
We are tracking Open Enrollment for several clients in two major categories - MED and FLEX - with tasks necessary for each. In the screenshot, the percentage for the client at the top is rolling up, but the the bottom is not. Is this because the first item has a duration of ZERO? I would still think marking it as 100%…
-
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)…
-
Day of Week instead of short date
Hello, I would like to have a formula in place that automatically selects a day of week based on the date we paste in the "Bid Date" Column. When 3/26/18 is loaded into [Bid Date] Column it produces "Monday" in the [Day] Column, and so forth... Is this possible?
-
Notifications to unshared users?
Is there a way to set up notifications for users who aren't shared to a smartsheet? Our HR team is trying to set up automated emails to send to employee/manager email addresses in cells for the Status Change Form SmartSheets that we have and for the new Education Reimbursement SmartSheet that we have so that we can keep…
-
counting multiple select column
Hello, I have a project plan that I'm trying to report on. I have a column for health check and a column for assigned team. I want to see a total count of each status per team. That is the easy part and I figured that out by doing a =COUNTIFS({HealthCheck}, "Red", {Team}, OR(@cell = "FI", @cell = "FIT")) My issue is that…
-
=ROUND(SUMIF
Hi =ROUND(SUMIF($[Pareto Category]$32:$[Pareto Category]558, Predecessors21, $[Actual (MHrs)]$32:$[Actual (MHrs)]558), 0) The above is my formula. It says, "IF the value in the Pareto Category column is the same as the value in the cell Predecessors21, then count all of the values in the Actual (MHrs) column". However, I…
-
Multiple User Views on Dynamic View
I am creating a dashboard that contains Dynamic View. Is there any way to create multiple views for different contact lists? I know that dynamic view can be based off of a contact list or group, but is it possible to have a "view all" for someone higher level? So a manager can see the entire list while a lower level can…
-
I need help with our messaging strategy for a team 20 plus people. Slack? Google Chat?
I just watched a great webinar called "Make remote work more productive with smartsheet" Very informative. I was happy that we are already doing a lot of these strategies. However, I was hoping to find a little more insight on how and why we might, or should be using messaging apps. We currently use gsuite. We do not…
-
Develop formula to break up project ranking figures into 4 quadrants
Hello! I have developed a format for my team to utilize a ranking process for incoming continuous improvement ideas. The methodology is called RICE Ranking which you may or may not have heard of. Within the ranking, we want the info to automatically designate which quadrant the idea falls into based on it's rank which…
-
Update Confirmation email limitations
Has anyone figured out a way to disable the update confirmation email that is sent following an update request? The email is confusing my user community because it links to a sheet they don't have access to. Is it possible to even change the text in the confirmation email to ask the team to ignore the link on the email?
