-
Alert someone not sending notifications
Hi I have a very standard approval workflow set up, that is not issuing alerts as expected: The initial Approval request is sent through (the emails and Smartsheet alerts for that are correctly received) and the approval or rejection action is done, but the alert to be sent for "If Approved" or "If Declined", just never…
-
Reports and Conditional Formatting
Is it possible to set up conditional formatting that only shows up in a Report? Example: Creating a report that shows all the projects for each Analyst. Using the Gantt view, can we color code the task bar for each Analyst without having the task bars show up colored in the Tracker which includes many more Analysts than I…
-
Attachment appears in search but not on the sheet?
I have an attachment that I am able to find when searching in Smartsheet. I can click on it to view in the search box but I cannot locate it on the actual sheet. I reviewed the activity log for the sheet and see where the attachment was uploaded however but I cannot find any activity log entry that says it was deleted. I…
-
Hiding Blank Reports on a Dasboard
I have project level executive summary dashboards that have a number of reports on them that quite frequently have no data - Open Issues, Escalated Item, etc. Is there any way to hide / remove the widget when the report is empty. It is not the best looking report for an EVP to look at when it shows a heading "OPEN ISSUES"…
-
average metric using multiple criteria in one range
I have a sheet with risk scores for various projects. A project may have multiple risks in the sheet, with a project number that relates to another sheet. I want to create a metric that will show the average risk score for "project 1", "project 3", "project 4", "project 7" to use a simplistic example. I have been…
-
Why can't you share at folder level?
Hi, Is there a reason you cannot share at folder level? There are limitations with only being able to share at workspace or sheet level and I wondered if this would be considered for future releases? Thanks.
-
Auto Attach a File from Google Drive to a Specific Row
Hi I am wondering if the following would be possible. Auto Attach a PDF file from Google Drive to a Specific Row if the file name and Primary Column Name match. For instance. A file is uploaded to google drive called: SM-15C-PL0022-XFR-PIPE.PDF This name also matched the Primary Column name: SM-15C-PL0022-XFR-PIPE So the…
-
Will inserting a new column break references?
I think I know the answer, but my colleague wants a little more reassurance; She has a data sheet, and this data sheet feeds a number of single cell reference metrics to a dashboard. She wants to add a new column of data to the initial sheet, but is concerned that it will break the references the metrics use. I hvave…
-
Put two fields from a report on a dashboard, and just those two fields, no column headers
I have a dashboard that shows a bunch of information about upcoming publications. Things like who is contributing, submittal deadlines, approval deadlines, etc. I have sheet with the publication date in it. I want this date to appear at the top of the dashboard. Literally something like: Publication Date: 05/11/2021 Is…
-
Mitigating users deleting and accidentally sorting/saving rows - will this work?
With all the discussions with multiple editors accidentally deleting rows or sorting, then saving rows so that it messes up workplans, I'm a little scared of what could happen and have already seen it on a small scale, so can't image what will happen when we onboard multiple editors and projects. With my previous MS…
