-
👋 Hi everyone, I’m happy to be here!
🏥 Where I work & role I’m a Grant & Development Coordinator at a community-based organization that is also a certified culturally specific behavioral health provider. Our work blends behavioral health, community health services, public health programming, and a cancer support center. 📊 Background & Smartsheet experience I…
-
Trigger suggestions for blank updates request
Hi everyone, I have seen a handful of articles on this topic, but sadly none have made sense to me. I have a process where a student submits a form, which through automation is in turn sent to an employer using the "Request Update" feature. The employer is supposed to review the content and then complete a series of…
-
Formula to Capture Total Days Open with Status Changes
I hope that everyone is well! :) I have a use case where I need a formula that allows me to capture the number of days a request has been open but stopping and starting the clock when the status changes. From: In Progress to On Hold to In Progress to Closed. Also, I would only like to count weekdays. (No weekends or…
-
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.
-
Auto Colouring Gantt Charts
Hi, We use Smartsheet for creating schedules/programmes for a construction company, we use a lot of the same subcontractors across the different projects. We are trying to be more organised and Smartsheet is certainly helping with that. What I am trying to do currently is when I put in the title of the subcontractor e.g.…
-
Inserting A Single Checkbox In Smartsheet
Hi, I am attempting to create a column where there are only checkboxes in certain cells: I only want the checkboxes that are circled in red; the rest of the rows need to be blank. Is there a way to do this besides double-clicking a checkbox I don't want, putting in a character field, and setting the text background to…
-
Pulling dates across different Sheets
Hi, we are using Smartsheet for our construction company and are looking for some assistance. When I create a new programme/schedule I use a new sheet for each project. We use a lot of the same subcontractors across multiple jobs and are looking to avoid clashes of dates for subcontractors on different jobs. Is there a way…
-
How can I use Conditional Formatting for date in the past or future when a formula created the date
Hi Everyone, Thank you for your time in reading this. How can I use Conditional Formatting for date in the past or future when a formula created the date? The black columns are different dates generated. The 2 yellow columns are then selecting the relevant date based on different criteria. The white columns are me trying…
-
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…
-
Cant access the bell row reminder
Hi All, my row reminder bell function for rows has disappeared on one of my sheets. It has been with a padlock icon to lock/unlock the row. How to i revert back to being able to set a row reminder?