-
Change Cell Value Automation - flag or symbols
I am wondering why you cannot set the value of a flag or symbol using the Cell Change Value Automation? I cannot see how to do it. I have a flag column that I want to let the users manually set to highlight what needs to be looked at and also have the flag set automatically when certain conditions are met. I can't use a…
-
K-12 Education
Hello everyone, my name is Alan Miller and I am an Executive Assistant working in K-12 education in Grand Junction, Colorado. I would just like to introduce myself and share some of the uses of Smartsheet that I use within my industry. I have been using Smartsheet for 4 years now and just returned from my second time at…
-
Why don't automated and exported reports show groups?
I'm trying to send an automated report on a schedule, but the PDF that's sent does not show my grouping. It lumps all rows together regardless of what group they are a part of. Is there a way to set groups to show in PDF versions of reports?
-
Is there a limit to the number of notifications that can be sent at one time in a workflow?
Is there a limit to the number of notifications that can be sent at one time in a workflow? I am preparing a staff survey for approx 8000 employees. On a specific day and time, they will be sent an email via workflow that contains a link to the survey. Do you I need to be concerned about so many going out at one time? This…
-
Stack multiple saved filters
It would be helpful to be able to "stack" multiple saved filters, so that a user could apply multiple, orthogonal criteria at once without having to create a cross product of defined filters. For example, if records can be either "current" or "past" and either "material" or "immaterial," a user might want to search for…
-
Creating automations from reports
It would be super helpful to have the ability to create an automation/workflow from a report so that my team can get ONE comprehensive email/alert each week for a "request for updates" across all sheets that are being pulled into the report. It can be daunting for a user to receive a similar alert via an automation or…
-
Allow basic copy/paste in table view
Allow pasting a url into a cell in table view without throwing an error that I have to google to find the solution is switching to grid view, pasting, saving, switching back to table view. https://community.smartsheet.com/discussion/141068/issues-with-copying-in-the-windows-app-table-view?tab=all
-
Trying to add a year to this formula
So here is my current formula… =COUNTIFS({Date Completed}, IFERROR(MONTH(@cell ), 0) = MONTH(TODAY()), {Staff name}, =Staff@row ) This works. It gives me a number for all observations submitted in the month. The problem is it also counts the month for the previous year. How do i filter the count by month and year? Thank…
-
2 part automation delay question?
Greetings- I have a automation setup when I select the "status" column drop-down to "completed" I want the row info to be emailed to the contact to submitted it with a follow up then I want it to archive the row (aka move to another sheet). When I run the automation only 1 of the 2 requests happen. The archive happens…
-
Ability to set vertical axis scale on charts
I appreciate the feature in charts to scale to data values, however, I wish there were also a feature that allows you to set the scale for min/max. This would help viewers glean takeaways quicker, without having to reorient themselves to the scale for each individual chart.