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 …
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 i…
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 fin…
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. With…
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 acc…
Hi there, I'm currently using a SUMIFS formula that is as follows: =SUMIFS({v4 Hours}, {v4 end}, MONTH(@cell) = 12, {v4 Group}, OR(@cell = "AD", @cell = "Freelancer")) I want to sum the task hours col…
I'm trying to find a project plan for implementation of a new phone system. I know every system and every company will vary but something to start with would be so helpful to me. Thank you
I have a project that involves building fences in a number of locations. Each location has a budgeted lineal distance of fencing, and we will need to track progress of distance completed against budge…
I'm trying to count the number of items in a column where part of the text shows. Is there a way to do this? For e.g., I'd like it to count up the number of rows from a column in which the words "ids"…
Hi all, I have three columns which have the same drop down options: requested, received and pending. I would like the "pending" column to have all options from the "requested" column except for what's…