-
Return to Work Templates
Has Smartsheet created or does anyone have any locally successful templates for helping to plan out Return to Work from a manning perspective? Specifically, our government office is working to have a max capacity (20-30%) of total workforce in the office at any one time, and trying to create a published schedule that…
-
Dashboard widgets
Hello - I have three Workspaces for different firms, and in each workspace I have a folder setup for each project. I want to setup a Dashboard to report on the various different projects the executives. I'd also like new folders (new projects) to automatically be added into the Dashbaord reporting. I found that at the…
-
Sheet Linking
Is there a way to link one sheet to another sheet creating a drop down menu? Example: I am creating a form, but I want to the staff to be able to select the residents from a drop down menu. I have the sheet created with the residents information but I cant figure out how to link it to my "forms sheet' so that they are a…
-
Automation - Alert based on Date change in a column
I have a sheet with 2 dates, original ship date and current ship date. I want to send an alert when the ship date changes, but not when the info is entered for the first time. Or, to not send an alert if the ship date is the same as the original ship date. In the conditions, I can't seem to find a way to do this
-
Sync Google Sheets & Smartsheets
Hello, I have a task board in smartsheet that my team uses to track work. We have a third part application we use to track metrics and it only integrates with google sheets. Not smartsheet. Is there a way to have smartsheet data sync to a google sheet?
-
Web Content Widget not embedding Soundcloud
I just want to clarify the following. Are the Embed Enabled Web Content approved domains the only URLs that currently work within the widget? OR Do I need to have the Enterprise Admin allow the domain? Trying to embed Soundcloud channel: https://soundcloud.com/intelcitc OR <iframe width="100%" height="450" scrolling="no"…
-
Calendar view question
Hi all, I believe since I had added a new comment in the attached calendar view post, it had dissapeared from the unanswered questions section of Smartsheet community. Can anyone please help? Thanks!
-
Text Wrap for Report
How can I expand the row for the full text to be displayed in a report? There is no text wrap like in smartsheets. I've attached a photo to help explain what I'm talking about. The sentence gets cut off prematurely. Thank you for your time!
-
If formila based on OR condition
Help with formula? trying to make a symbol (the star highlighted) if the due date is in the last 7 days, today or next 7 days =IF(OR([Planned End Date]@row, <=TODAY(7), [Planned End Date]@row, >TODAY(7)), 1, 0)
-
view by work week in card option
Hi, i have a sheet with my compeny task that update every day by project managers. each task get the data from the PMs ever the at 08:00 morning. i want to see all in Card view when the section is WW (work week) the problem is if i put all number between 1-52 then in Card view i saw all WW numbers even if it is passed. how…