-
Workflow Delivery Alert
Hi All, In my Smartsheet I have over 100 workflows to notify the user if certain task need to be completed. One of the recipients no longer works for us and his account had been deleted. Now I receive over 100 emails to notify that one of the recipients will no longer receive the notification. The only way to fix it is to…
-
Move rows - Automation
Hi All, Apologies if this had been asked already but I couldn't find the answer to my question. I have a smartsheet where each row will have a date, I would like the rows to be moved to another Smartsheet if the date is two days ago. Can this be achieved with automation? I tried it but it doesn't seem to behave the way I…
-
Can't view PDFs any more
Until yesterday I had no issues viewing PDFs, but I just get a blank grey screen now. I can view them on my PC before I upload, and if I download them, it's just if I view through Smartsheet! Is anyone else having this issue, or can someone tell me what's changed? Thanks!!
-
Approval Request after a modification
We are working with an approval workflow. In this approval flow the user has the possibility to change important things in the approval request. Problem: approval request is already sent We solved this by generating a new approval request when something in the request has changed. Problem: the persons who gets the approval…
-
Sheet automation with a mix of relative dates and date ranges
Hello, One of our teams is using Smartsheet for team calendars, tracking things like time off, travel, working from home days, etc. Key notification criteria is based on start and/or end dates. Currently, their notification is setup to trigger when the start date is today. This doesn't catch when there is a date range…
-
(2) Reports in a Dashboard Showing the same answer?
I have 2 reports sitting next to each other in a dashboard. One shows a summary of what was due yesterday. One shows a summary of what is due in the next 5 days. "Due Yesterday" report is set to show anything with an End Date in the last 1 day(s) "Due in the next 5 days" report is set to show anything with an End Date in…
-
Poor Quality Outlook Emails from Smartsheet Automation
When receiving emails from smartsheet.automation.com, we are experiencing very poor quality emails that have large spacing between paragraphs, and sometimes the text is stripped from a sentence and moved to a different row. I had our IT look at it because I had a feeling it had something to do with our "Warning Label"…
-
Not able to get Countif to work with Contains
I have sheet that has a column called Legal Tasks. I'm trying to write a Countif formula that counts the number of times the word in Column2 appears in the Legal Task column. As the formula stands it is trying to do an exact match, however my intent is to include in my count everytime the word appears by itself or with the…
-
Removing Page Breaks from a Cell
The addition of Dropdown (Multi Select) has been very useful, but the page breaks that it includes between each selection has made formatting the strings problematic. Is there anyway to removed page breaks or replace them with a space or another character?
-
Best way of Counting a given number of States
Hi there, I am trying to have a graph display the count of some things across multiple sheets (~40), as shown in the screenshot. The only way I could think of for now was to get the data by cell linking and doing some calculations on it in an extra sheet. As it turns out now, doing all of this "manually" for multiple…
