-
Overlapping Two Charts
Hi all, I have a column chart showing our actual hires and I was hoping to see if there is functionality to include a line graph on top of that to show the targets we had per month (see example below). If not, I'd be open to suggestions on the best way to display this. Thanks!
-
Forms - can you make formulas on dates?
can the sheet have a formula when the form selecting a date - gives a response? =IFS([@Response]="", " ", OR(WEEKDAY([@Response])={1,7}), "That is a weekend date. Please select a different date.", OR(WEEKDAY([@Response])={2,3,4,5,6}), TEXT([@Response], "dddd")) where the form entry will prompt a new suggestion?
-
Project Settings from Report Glitch
Curious if anyone has issues using the "Project Settings" button (small gear icon in the top right under the share button). We thought we can adjust the project settings for the Gantt view on a report (or does it adjust the project settings for the whole sheet)? Either way, when we click the icon nothing happens. After the…
-
Hyperlinked Text on Automated Notification / Workflow
One of my cell {{Video Link}} has the text of the title and the url of the video. When I send the notification and select the third option on Message to include (Message Only), it only sends the text and not hyperlinked. I dont want to select the second option as it does not look professional and clean. Is there a way to…
-
Create portfolio rollup across multiple workspaces?
I'm using separate workspaces for each project because I need to restrict access and you can only restrict access at the workspace level, as I understand it. But I also need to create a portfolio rollup like you can using the Project Management Office template set. Is there a way to create portfolio rollup across multiple…
-
Auto numbering based on values from an adjacent cell
Hi Community, I have the below sheet: The value in the "State Code" column should take the State Abbreviation and add the next number in the sequence of that particular State. Anyone know what the formula would be to enable this? Many thanks, Ahmet
-
How do i force all devices logged into an account to require logging back after password change?
It the 'keep me logged in' option is checked on the login screen, that device stays logged in, even after the account password has been changed. This is a massive security risk if an account is hacked and the hacker selects the 'keep me logged in' option on the login screen. It allows the hacker continued access even after…
-
scheduling a start/end date calendar for a list of tools
Hello I'm looking for a way to track and schedule a list of tools. So right now, we have a list of specialty tools used for certain projects on Smartsheet. Whenever a tool is needed, it is shipped to the location where it's needed, and then it's location is updated in Smartsheet. What I'd like is a way expand on this. And…
-
How to set the reply-to on notification emails?
Hi, When the automation send notification emails, most of the time the reply-to is the sheet owner but sometimes it is the person who modified the sheet. Looking at the documentation, I found this article: Overview of Automated Notifications Sent via Smartsheet | Smartsheet Learning Center The article says this: "In most…
-
Turn off the "Get Started" message after a Report is built
Hello. Is there a way to turn off the "Build Your Report - Get Started" message after the report is built? This popup message continues to show up, even after I have built and saved a Report. Thank you!
