Smartsheet Basics

Archives for May 2021

Email Notification unsubscribe option
Is there way to disable the unsubscribed option for recipients from a workflow email?
How to flatten Smartsheet with hierarchy levels into Table file for PowerBi
I have a Smartsheet with hierarchy levels in it. I need to pull this file into PowerBi for reporting. My understanding is that PowerBi needs a flat table file. I've done this successfully with other sheets but it's not pulling over the data correctly in a Sheet with parent/child relationships. I've seen the post were…
Filtering the sheet according to leftmost system column content: Comments, Attachments, Proofs, etc.
Hello, I need to put a filter to the sheet to see only the rows including "Comments" (Comments in conversation, not comment column added manually). The question may be extended to filtering: · Locked rows, · Including proof rows, · Including attachments, · Update requests, · Etc. (whatever available in the first (leftmost)…
Can we create a workflow to run daily and alert when due date reached excluding Saturdays & Sundays
We need to create a workflow to run daily and send an alert when due date (Due date = Created date + 2days) is reached, however weekends should be excluded, as when a request is created on Friday, so for due date it should count Monday and Tuesday instead Saturday and Sunday. Is this possible to set a workflow for this?
Conditional Formatting - multiple columns
Hi All, Hope you are all safe. Is it possible to apply conditional formatting to multiple columns (same condition). I have data in 10 columns. I want to highlight cells where the value is not equal to 0. Currently I have to apply conditional formatting to each column separately (cloning the rule). Is there a faster way?…
Moving Columns
Hello, I have a "completed" sheet that is the destination sheet for records that have been, you guessed it, completed. I would like to set up an automation that when rows are moved from that sheet copies certain columns to another sheet. The additional sheet is a template that we would use to upload into another system.…
Exceeded Maximum Limit of Emails that my Account can send
Hi, I have an Individual Account, does anyone know the email limit? Thanks ANC
Android photo upload problems in SS Forms
We are using a SS forms to have employee upload photos to a database, and are receiving reports from a couple of Android users that the can not see the files when they go to attached. Is there a SS/ Android compatibility issue? or something more user specific going on?
Any solution on data dislocation issue for stacked column chart?
Hi Team, When I am using bar chart I see the dislocation of the data label, I understand this is sort of at the outside end of bar. But this doesn't work well for stacked column. it could be a bit confusing for people who is using the dashboard. Hope there will be solution on this, thanks! -Alice
How can you set up a workflow to trigger on a variable date
In an onboading form for new hires, I want to set up a trigger to fire 160 days after the person's hire date but I'm not going to know what that is, so I can't use the date field to trigger because I'm being prompted to choose a date from my form. I tried to trigger on the hire =date +1 day to see if that would work, but I…

Trending in Smartsheet Basics

Creating Graphs
Is there a way to create a similar graph in Smartsheet? Thanks!
How can dynamic view users reply to an email notification for a comment
The typical email notification includes a link to the original spreadsheet row, but my business users will not have access to that sheet, only a limited dynamic view. Is there a way to send a link to that that view?
Activity Log Error for the past 3 days?
For the past 3 or so days, in the activity log, when trying to expand the view to see what cells changed, I receive an error message saying we are having trouble reaching Smartsheet right now. Is anyone else having a similar issue or is it just me?

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Smartsheet Basics

Discussion List