Using Smartsheet
Archives for August 2021
Discussion List
-
Forms - can you make formulas on dates?In Using Smartsheetcan 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…
-
Project Settings from Report GlitchIn Using SmartsheetCurious 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 proje…
-
Hyperlinked Text on Automated Notification / WorkflowIn Using SmartsheetOne 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 s…
-
Create portfolio rollup across multiple workspaces?In Using SmartsheetI'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 Manag…
-
Auto numbering based on values from an adjacent cellIn Using SmartsheetHi 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?…
-
How do i force all devices logged into an account to require logging back after password change?In Using SmartsheetIt 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 l…
-
scheduling a start/end date calendar for a list of toolsIn Using SmartsheetHello 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 the…
-
How to set the reply-to on notification emails?In Using SmartsheetHi, 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 Notificatio…
-
Turn off the "Get Started" message after a Report is builtIn Using SmartsheetHello. 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!
-
Trigger Approval Request with the submission of an Update RequestIn Using SmartsheetHi I have an approval process which sorta works well which allows an approver to decline a request asking for more information. The re-trigger to the original approval workflow is based on the user updating a 'different' do you want to con…
