-
All technicians preferred old Grid view...
Since smart sheet update new version. We are used to able to look details with Grid view.. Now we have to review with grid view and then go to list view and able to see detail...it makes more longer time operate n more comfusion..please we prefer before version smart sheet
-
30 60 90 Initiative sheet
Does anyone have a good/great template/report or dashboard already created that you are willing to share. I am new to smartsheet and have ideas....but limited time to put something together. It is for and acquisition project. Currently have a WBS by functional area...need to quickly strip strip key tasks & milestones out…
-
Report showing resources and assigned projects
I'm looking for help developing a report. I've got multiple projects and multiple resources working on those projects, and I'd like a simple grid - resources in a column, project names across the top, and an x indicating which project each resource is working on (or something like that). This view will give a snapshot of…
-
Stale time/date
Hi, I am trying to setup a "Stale" notification for a help ticketing system. When a support ticket (row) ticket has not been modified when compared to the current time and date in over an X amount of hours, then send a notification. I can compare two different date columns like this: =Modified1 - [Created Date]1 But if I…
-
Removing duplicate types in an output report
I have a report that shows the output of staff within a department. It shows all the publications and events they are working on. I am looking to build the report so that it does not show duplicates of the same type of output by the same person. For example, Staff member A is running 10 roadshow events throughout the year.…
-
Smartsheet and JIRA integration
Hi, I have two questions related to Smartsheet and JIRA integrator and I'd like to know if somebody here could help me: ** Question #1: Is it possible to insert a row (automatically) within a parent structure from JIRA integration? For example, suppose I have this smartsheet: Marketing Team Tasks Task 1... Task 2... Task…
-
File Upload from Customer into their Designated Row
I was hoping somebody could help. I have a form set up where customers can upload their artwork directly to our sheet and once checked I send an approval request as a proof. However if the proof is declined or we check the file and it isn't print ready we require customers to upload a new file (artwork). I have tried this…
-
File Upload from Customers
We have recently started using smartsheet to organise our print jobs and workflow through the production line. I am curious to know if a customer that doesnt use smartsheet can upload artwork into our sheet? Can we send them an upload link where customers can upload their artwork (PDF) into their specific row on the sheet?…
-
Smartsheet's Error in % Complete Rollup
Hi, I recently realized that Smartsheet has a major flaw in rolling up % Completion. In Smartsheet %complete for a Parent is calculated as a weighted average of %completion of the immediate children times the duration of the Parent. For example in the following Project, the overall % complete shows 50% where the correct %…
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…