-
Countifs on percent complete, month, and year
Is it possible to create a countifs statement like the following: =COUNTIFS([% Complete]:[% Complete], =1, [Project Finish]:[Project Finish],AND(IFERROR((YEAR(@cell), 0) = 2018),IFERROR((MONTH(@cell), 0) = 2)) ? I am trying the following equation to search for 100% complete and during a specified month and year. I am…
-
Prioritization and Forced Rank
Hi all! I'm creating an intake form to help business leaders prioritize and force rank of dependencies. Example: Main project: Develop a recyclable lid for water bottles Owner: Barney Rubble I'd like to send an update request to Barney asking him to tell me what departments he is depending on to get his project done. For…
-
Workspace cleanup without admin burden
Here's the situation: I'm trying to cleanup workspaces that are shared to me without admin burden on other users of the workspace. Here's my specific situation: 1. I am not the Owner of the Workspace. 2. I do, however, own one or more objects in the Workspace. 3. The Owner of the Workspace is not available (on sabbatical,…
-
Breaking a full page of links.
I have an entire page linked to another page. I want to break the links. Do I need to do it one by one or is there a way I can break the entire page of all of it's links?
-
Charts - comparative data colors
I am having an issue with charts and my column colors. I am getting all the same color columns. I asked about this in the webinar last week and received this answer: "Colors are going to denote different comparative values (what's labeled in your legend). If you're not comparing more that one data set, you won't have…
-
Chart in Smartsheet
Hi, I am trying to create a new chart in my sheet, but the chart type is not available when I select 4 datas. There is no problem when I select 3 datas, well I don't understand why I can't create my chart with one more data. Could you help me please
-
Shared Sheet Admin Profile Cant Edit
I have shared a sheet and made the person admin He can not add any colums Im on a paid individual plan How can i get that person to be able to edit and change the colums on my sheets Please help Thanks
-
Client Invoicing
Hi, I just signed up to the trial of Smartsheet today, so I'm very new to all of this. I'm wondering if we can use this for client invoicing. As a start, I have set up a sheet that lists employees, which includes a "Client" column to whom their time should be billed. For each employee, I have set up a separate time sheet…
-
Resource Views Don't Line Up
I have a launch next week and I have been using Resource Views; today, it's all scrambled up/misaligned. How do I fix this? It's very important that I can keep track of this and this view is very hard to read. It shows the summary percentage a day off from the tasks that really have that percentage. I included a screenshot.
-
Date Dependency in a Form
Hello, I have a form setup for vacation requests and tracking purposes. In the form the requestor has to input todays date, which automatically defualts to today's date, but we're having issues with the start and end dates. I would like default date to be dependent and automatically to at least update to the start date to…