-
Resource Planning: Calculating Weekly Hours Remaining for a Project
Hello, Goal: To view estimated hours per resource per week. I am looking for a way to calculate the weekly hours remaining on a project, per person. I am referencing my project plan as the source sheet which has: Resource Name, Estimated Hours, Start Date, Due Date, Week Start, Task Name, etc. In a summary sheet, I would…
-
Can't Create a Single Grid Sheet anymore? Why did this change?
I am unable to easily create a grid sheet unless I do it through the Workspace panel. I used to be able to right-click anywhere in my sheets folder, for example, and add one, or hit the create button, which offered options. Now, the create option directs me to the same location as the left navigation, and there are so many…
-
Smartsheet Icons for Flowcharts
Hi all, I'm trying to make a simple flowchart explaining how a solution I built works. Smartsheet does it this way, and I'd like to replicate it: Does anyone know where to get these icons?
-
How do assets within a Collection appear to end users?
I have external users who can't be shared to a Workspace because there is confidential information regarding other external users within the Workspace. A collection seems to be a good option, but how do these users see the assets within the collection? I tested it this out on a secondary account, and can see the collection…
-
Change Dropdown Column Value for Multiple Rows at One Time
Simple question here: I want to change the Dropdown value of multiple rows at the same time. Select Rows, 3, 5, 6, and 8. Change these rows' Column B (dropdown) value to "Value X". Right now I can select multiple rows by clicking while holding shift. But then when I try to change the column value for them all, it just…
-
upgrade plans
Can you please ask my account manager to send invoice for Pro Plan for my account to the email ID: karthikeyan@bkstextiles.in to enable me to process the payment through wire transfer
-
Hyperlink Color on Dark Background
Hi, I'm new to SmartSheet so I may have missed something. When I add an hyperlink on a cell with dark background, is there a way to make the text white or any other color that would allow to read it? I thought the automatic mode would change the color, but it does not let me do so... any ideas? Do I have to stick with…
-
COUNTIF Formula for Checkbox Column Not Working in Sheet Summary
I'm trying to create a formula in the Sheet Summary that shows the number of checked items in a Checkbox column named Pending, out of the total number of rows that have either a checked or unchecked box (i.e., excluding blanks). =COUNTIF([Pending]:[Pending], 1) + "/" + (COUNTIF([Pending]:[Pending], 1) +…
-
I'd like to generate a weekly report from smartsheet.
I use Smartsheet as a trouble ticket tracking tool and need to generate a weekly emailed open ticket status report that list selected fields from open tickets in the report. What is the best way to do that? I understand Smartsheet has a mechanism to do that.
-
Report Grouping: custom sort order of groups
Current limitation: When grouping by a column in the report, I’m forced to choose either Ascending or Descending order. This prevents me from grouping without altering the original sort order based on another column. Request: Please allow grouping by a column without forcing a sort order on it. (Also would be great to…