-
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.
-
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…
-
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
-
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) +…
-
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…
-
Automation Not Triggering On its Own When Trigger Criteria Met
Hi - I am using Smartsheet to manage our cutover plan for a software deployment. I have 2 columns that populate a Yes/No value automatically based on a formula calculation. Those columns are called 'Trigger Date' and 'Trigger Time Comparison'. The 'Trigger Time Comparison' is always the last column to flip to Yes, so I set…
-
Quick question about submission not showing up on record
Hi all, Part of our workflow for documenting tasks is submitting a form to a supervisor, which they then will approve as completed. This has been done for months with no problems Today I submitted multiple of these, all of which said either "submitted" or "approved" like normal. However, two of them are blank, telling me…