-
Report that features tomorrow as due date
Trying to create an automated report that pulls items from multiple sheets with a due date of tomorrow only. I have one that does the same for today, but tomorrow has proven to be more challenging. I could manually update the report every day by changing tomorrow's date, but I'm trying to avoid that. And using "is in the…
-
Editing uploaded files
I am project managing construction jobs and have been given the task of auditing contractors whilst they are on site. I have uploaded the audit forms onto smartsheet as an attachment and I was hoping to edit them while I was on site without downloading them and re-uploading them. The files I am uploading are word…
-
Integrating smartsheet with slack
Hi, Does smartsheet have any plan to integrate with Slack ? We are using smartsheet as a project management tools where we have tasks and sub task with start and finish date. We want to integrate it to Slack for announcements within a team. Thanks.
-
IFERROR
HI all, I have a sheet where I am collecting data. One is our overall variance. In certain rows I do not have data and receive the #DIVIDE BY ZERO message. I have attached the screenshot to show my formula. Thank you,
-
Formula Help
Hi All, I am in need of some formula help! 1. I would like to count all of the projects in my portfolio that are in the Active state and either Yellow or Red health. I have a Dropdown List column for State and a Symbols column for Health (RYGB balls). This is the formula I've have been trying. I am getting the Unparseable…
-
Dashboard information depending on a selection
Hi, I just began using Dashboards and I have a question I´ve not able to answer. I have a project portfolio and several projects. The project portfolio is a centralized Smartsheet and its related to all the individual project smartsheets. I´m trying to build a Dashboard where you can select one of the projects of the…
-
Can I highlight non-working days and holidays in report based gantt charts?
I have a report referencing several worksheets that I use primarily in gantt chart view. When I print it's gantt chart, I would like the weekends and holidays highlighted the same way they are in a worksheet based gantt chart. Is this a check box I am missing somewhere?
-
Determining duration in Hours:Minutes
Hey guys, I have read several posts with several workarounds for calculating a value between a Start Time and an End Time where the input and result need to be in HH:MM. I have an idea and a beginning: 1. I created two System Columns. [Start Time] as 'Created (Date)' and [End Time] as 'Modified (Date).' 2. I created a…
-
Send an Update Request at a Specific Time on a Specific Day
I have read several post regarding the ability to control an update request / timing. I have tried this multiple ways. 1) Created a Form - I struggled with the team picking the correct date (this was necessary). I setup a Outlook Calendar Reminder weekly so it would remind them at a specific time. When they submitted the…
-
Feature requests: More formatting options on Gantt
Hi folks, Not sure where this belongs, but I figured I'd post it here as I haven't seen a post that captures the overall formatting power of the Gantt chart. I would love to see more robust text and other formatting on the Gantt chart. As a longtime MS Project user, i was able to create really slick milestone charts and…
