-
How to exclude the dates of a Person's PTO dates from scheduling dates
-
Can input from one form separate to two rows when they input to sheets based on conditions?
We currently ask people to select one form per one need for referral into a program. For example, I want to submit a referral to a community health team and another one to behavioral health team. I need to submit two separate forms because each form submission will create one row to master task list where it then auto move…
-
Language Translation Process
Hi Smartsheet Community, We are trying to develop a process within Smartsheet, that essentially allows us to create a repository of processes in English, and once english is entered, it then translates into French, German, Spanish but all on separate sheets. I was thinking about reports, but it doesn't really give us the…
-
Hubspot Integration for .EU instance
There is currently a Hubspot integration readily available to connect data into Smartsheet.com We have received an increased need to be able to also connect Hubspot data into smartsheet.eu Is this on the roadmap? If not this would be a great enhancements for many customers.
-
Automation to change cell value based on checkbox not working
I've set up an automation to change a cell value to "Complete" when a checkbox is checked. It either changes all cell values (whether the checkbox is checked or not) OR doesn't make any change at all (when checkbox is checked). I've tried a start from scratch automation and a template. Can someone explain what I'm doing…
-
Automations
Looking to see if anyone else has experienced a similar problem or might have some insight into why the below isn't working right for the team I'm working with. We've setup a grants tracking database that will send automated alerts for various things including if an end date has passed and the grant manager hasn't updated…
-
Fix Errors Due To Managed References Within Collections
Sheets/reports within a Collection that have managed references to sources outside of the Collection will fail with errors for those formula cells. What's the point of Collections if you can't pull source data into it from outside the Collection in Workspaces you don't want people to have access to? I didn't have this…
-
Some clarification to clarify
I have a few questions that I need clarification on: This is a question about multiple selection able to run report and auto counted and group in report I asked this question before, but hope things might be updated, we currently only can run report based on a single section in the column, correct? or can we run report in…
-
Customize Success....Entry Submitted Message from Automated Update Request
Hello, When creating a form, you can customize the message at the end of the survey. "Success. We've captured your response." I'd like the ability to customize this message when sending automated update requests & include links to other Smartsheet items. I have the link in the message in the automation, but once the form…
-
Control Centre push an update to all provisioned worksheets
I have a large number of assets that have been provisioned through Control Center. I want to install a formula in one cell in a specific column. I thought I could update the template in the source folder of the blueprint and publish it, however, that functionality has been removed or I can't quite figure out how to do it.…