-
Smartsheet synced with Google Calendar
I have my Smartsheets synced with Google calendar. I get about 30 to 100 emails a day telling me my SmartSheet is disabled and I need to reable but when I go the worksheet in question the publish option says "ON". Please help me.
-
How to Group data in a Report by Year
Hello, I have exact finish date for each project in the roadmap. But I would like to create a report that can group these projects together by year only, not by specific date, how can I do that?
-
Unable to Down Part 2 of the Product Certification Exam
For some reason, I'm unable to download the Exam Folder to complete Part 2 of the exam - Feature Manipulation Exercise in Smartsheet. When I attempt to download I receive the following error message "Your account has reached the maximum number of sheets allowed for your edition." However, I have confirmed that I have not…
-
Sum if checked help
Can someone help me with this formula? I want to sum Net pay if approval is checked I have tried =sumif(payapproval1:payapproval9, 1, netpay1:netpay9) =sumif(payapproval1:payapproval9, =1, netpay1:netpay9) =sumif(payapproval1:payapproval9, "yes" netpay1:netpay9) And a few other variations and I get "unparceable"
-
Two workflows in one automation?
Is it possible to have two workflows in one? For instance, if someone is filling out our intake form, and they select a marketing tool called "Emma", I want the specific marketing person who handles that tool to be assigned to that ticket and to receive an alert that someone has submitted a ticket for it. Can I make both…
-
Two messages for one update request
Hello, My question involves an Update Request . The process is this: we request an update from a contact in a cell. That contact receives an email with a custom message in the 'customize message' field. The problem we’re having concerns that message. We would like the language that the person receives in the update request…
-
SUM of COUNTIFS totals in Checkbox Column
Hello! I am hoping someone can help me. I am building a sheet that has several layers of parent and children sets using many different column properties to meet a specific client need. I have to use checkboxes to signify the type of business and then need to show total numbers by region, by country, and then by category. I…
-
Include Previous Value in Workflow Notification
I have a sheet that has all of our current projects, and one of the columns is Ship Date. We have a workflow so that some of us are alerted when this Ship Date changes. Currently, we just have the message saying "The ship date is now {{Ship Date}} for {{Job Name}}." Is there a way to include the previous value (date) that…
-
Populating a PDF from smart sheet rows, instead of columns
Hi there. I am creating an intake form, that captures data "vertically" vs. horizontally. The data is collected this way for both esthetics and ease of use. So, for example, I have a single column, that collects different types of data, e.g. Column 1 row 1 Your name row 2 Their name row 3 Someone else's name What I would…
-
Password Complexity
I see that Smartsheet passwords must be 10 characters. Is that currently the only requirement? Is there any other complexity required such as special characters, caps, etc.?
