-
nested groups
Does Sheetsmart allow me to create hierarchical groups? In other words, can I add a group to a parent group? Google Workspace allows for nested groups. https://support.google.com/a/answer/167100?hl=en
-
Auto updating an image in a Dashboard
Situation: I'm creating a dashboard where I'd like to pull in a chart/image created from another platform. I can save this chart as an image, PowerPoint, or even excel file. Problem: I'd like the Smartsheet dashboard to update this image when the dashboard is open or even at a set cadence (1x per day or week), is this…
-
Publish SS dashboard weekly
Hi Team, Currently I am pasting the published (view only) link on the email and sending out one on a weekly basis to internal team Is there a way to automate the same via SS alert or Workflow or other functionality which triggers weekly notifications of the same published link
-
Dashboard creation from Portfolio Metrics sheet
Hi everyone, I am trying to build a dashboard of metrics and charts, I discovered that it is easier using data from sheets than from report and summary reports. I came across portfolio metrics as source sheet for dashboard - I am thinking it was created by linking cells from different sheets. How can I go about creating…
-
Formulas
I am trying to easily auto populate a column based off a Job ID I type in. For example, if I were to type in a Job ID, could I have that same ID auto populate the next 5 rows of that Column. If I were then type in a different Job ID on the 7th row, could I have that new Job ID auto populate the next 5 rows and so on. Is…
-
Edit Multiple Attachment Descriptions at the Same Time (bulk)
Hi I have a sheet with over 400 documents that need to have the same attachment description - is there a way to edit them in bulk?
-
Workflow - Add a condition to Move Row / Data Shuttle move instead of delete
So, I'm trying to write a workflow that will move rows not updated / added from a Data Shuttle import. I've added a custom expression that adds a helper column with a "1" if the row is added or modified. That part works great. Moving the rows not touched is the problem. I created the workflow below which I'm now learning…
-
Manual Workflow Trigger for Time Base Automations
Hello all, I was setting up a Workflow to trigger based on a condition at a certain time of day. It did not work, which is fine it was a test, but now in order to run that same test again, I have to move the trigger forward an hour and wait for it to reach that time. (Function is to clear a checkbox daily) Since I am…
-
publish content on a whiteboard (like Miro)
Hello community, I tried to publish some content of smartsheet (schedule) on an online whiteboard solution (e.g. Miro). If I use the option "read only - HTML", everything is fine. I can see all tasks and I can modify the size (see pic - middle section). Only the gant is missing which is ok as far as I understand. When I…
-
Automation - Run Workflow Daily
When an approval workflow is set to run daily, will the approver receive a single email each day containing all rows that need to be approved? Or will they still receive an individual email for every row that needs to be approved?