-
Workflow and cell linking.
I have two sheets that have linked cells. I want to use the workflow to make the tasks from the second sheet disappear if the Status column says complete. Is this possible? I know how to set up a workflow to move cells to a new sheets but it does not seem to be working. Is this because I have the cells linked to another…
-
How to create a time gauge or something similar?
Hello, I am trying to create a widget to display on a dashboard. This widget will give the viewer an immediate idea of where the project is in the project timeline. Ideally, the widget would look like the time gauge image attached. There would be 4 segments instead of 3. The needle depicts where the current date falls on…
-
Can a Smartsheet form populate a PDF, and then send that PDF to Slack
Hi My company has a logistics driver that delivers sets to theatre. He usually fills in a paper form of what he has dropped off and then takes a picture of that and posts it on Slack. We have decided to move over to a paperless system and have made a smartsheet form to track which sets are delivered. Each time a new row is…
-
Kanban style dashboard
Hello, I would like to build a kanban style dashboard from a project plan or any other sheet that contains an action/owner/status. The second step, is I can create this Dashboard to bring together actions from multiple sheets. e.g. I can have action list 01 and action list 02. Bringing them together could show me the…
-
Baffled......Circular / Blocked Reference (Vlookup)
This one is baffling. I have a problem with 2 sheets reading each others data through a Vlookup. Each sheet has Vlookup ranges from the other sheet. I understand why formula and Vlookup may return a #circular or #blocked reference, but I don't understand why my sheets work perfectly for periods of time, and then start…
-
Tableau Online
I have a license for Tableau Online and I created a Dynamic Dashboard in Tableau Desktop. When Shared the dashboard to create a Link and put it in Smartsheet always for user and password for tableau. How can I add a widget link of Tableau in Smartsheet Dashboard for my Smartsheet users without asking me the Tableau…
-
Populating external Reports with Smartsheet Data
Hi, Is there any way that I can export my data from smartsheet so that it automatically populates/merges into a template that i have (word document) Thanks in advance, Scott
-
Need Help to Archive Completed Projects Offline
I have an Individual account that only allows 10 active projects. I would like to be able to archive completed projects offline and preserve the task notes, attachments, formatting, etc. I was hoping to find a best practice on this for SmartSheets. I wasn't able to find any information on this in the forum or with a few…
-
Approval Workflow
Hi there ; I would like to learn that ; as you know when we create a approval workflow system is taking an action about one row , and sends form atc. according to that considered row, but i wonder is it possible to send one form but includes many row's information and approver can approve those many rows at the same time ?…
-
Sum Column Divided by Two Summed Columns
This is the formula I'm using, but I'm getting unparseable: =(SUM([Actual final door count]:[Actual final door count])) / SUM([Inspection & minor repair labor hours]:[Inspection & minor repair labor hours] + [Repair labor hours (return trip)]:[Repair labor hours (return trip)])) Here is what the data looks like: I need the…
