-
Only Receive Notification When Log in
Hi everyone, I have set up a workflow that is sending notification reminder when task is coming to due. The trigger has been set up as once the status column shown as coming to due then the smartsheet will send the notification. But the user will only receive the notification when he open the sheet. If he doesn't log in,…
-
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…
-
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…
-
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?
-
New reactivation policy for deactivated users
Hello! I am trying to figure out how/why this new policy was started and how it makes sense. When we have users that are eligible for rehire, we deactivate them and then reactivate them when they are rehired because we use the same AD stuff (even if it's been a couple years). No issue, we're good to go. Now, the policy has…
-
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…
-
Users Submitting From Excel to Existing Sheet
Goal: I'm looking for a way for employees to copy/paste or upload new rows of data from Excel into Smartsheet without seeing the full sheet and ideally without needing a Smartsheet account. Project Overview: I'm building an expense report system where employees submit weekly expenses for review and approval. Currently,…
-
Track changes in a data element over time
A customer of mine would like to be able to see what rows in a project plan have changed their task status over a given period - probably a week. A scenario would be in preparation for a weekly team update meeting, the customer would like to be able to see a summary of what has changed from 'Red' to 'Yellow' or 'Green' and…
-
How to Display Clickable Links on a Dashboard That Update from a Metric Sheet
I need to add clickable links on a Smartsheet Dashboard that automatically update based on changes made in a Metric Sheet. I tried using a Metric widget, but the links appear only as plain text and are not clickable. Is there a way to have hyperlinks on the Dashboard that stay clickable and get updated whenever the Metric…
