-
High Level Project Report
Hi Everyone, I'm looking at creating a high level/overview report for around 10 ongoing projects which are all on their own Grids in Different work spaces with what stage they are at, who is assigned to the project and the date they are due to be complete. Can anyone recommend how I can do this, as I am very new to…
-
Workflow Notification Not Sent when Trigger Reached
I created my first workflow and apparently I did something wrong. Please see the attached image of my criteria. I created four tasks that met my criteria and should have received an e-mail as I understand it. Please help! Thank you!
-
Date stamping when moving between sheets
Hi, I have a task list and a list of finished tasks. I want a column that stamps the date when I moved it to the list of finished task (purpose is to get stats over finished tasks last 30 days, 360 days, etc). Attached you can see Cell history when the task was moved to list of finished tasks(19.08.19). Created date for…
-
issue applying conditional formatting to "% Complete" column
I am trying to write a formula that will change the symbol in the status column based on the percentage, as indicated by the "Complete" column. I cannot get my sheet to respond to any of my parameters. I have tried these formulas: =IF(Complete@row < 30, "Red", IF(Complete@row < 60, "Yellow", IF(Complete@row = 100,…
-
Issue using % complete
I am using the % complete feature which enables the parent cell to automatically calculate % complete based on the % complete indicated by all of its child cells. I am having an issue where "direct marketing", the parent row, is not accurately calculating the % complete based on the % indicated in the child rows. If I…
-
Is it possible to use QR codes in Smartsheet to track inventory?
I have a project that requires tracking inventory and instead of barcodes we are looking at utilizing QR codes. Does anyone know whether it is possible to use the Barcode Inventory Management template that is available in Solution Center but do QR codes instead of barcodes?
-
Editing the Layout in Dashboards
I've created several dashboards where the content/widgets are not static. I'm frustrated by the tedious way I have to move widgets around on the page. I would love it if there was a way to "group" several widgets so moving them around could be easier. Or maybe be able to create a "corral" of sorts, so that items could be…
-
Best way to group rows in a report?
Hello, We use Smartsheet as a task tracker, adding subtasks and milestones as a child row on the sheet. I understand that Smartsheet does not currently recognize the parent / child relationship in reports but I was wondering if anyone had any suggestions on how to group tasks together within a report? As it stands now, if…
-
How do I paste smartsheet data onto Confluence, Word, or Email and retain the formatting?
I'd like to copy my sheet contents which may have bold, colored, linked text and format onto another status report such as Confluence, Word, or email.
-
Notification
Hi, I have an action plan with an action column, a delay column, a referent column, and a progress column. I would like to create a workflow that sends a notification (mail) to the referent of the action 3 days before the date entered in the column "delay" if the progress is not "finished" in order to remind him to finish…
