-
Yellow rows.....
Can someone help me understand the why the yellow colored rows are showing up? And how to fix it? I think it has something to do with dates but cant seem to figure it out. See the attached screen shot. Thanks much.
-
Setting up Alerts
We are running a number of different projects on a sheet that have a: 1) - Delivery Deadline (which is specified by the client), 2) - Delivery Date (which is set by dependencies on our Production Schedule) When Production is running late, the Delivery Date can end up later than the deadline. How can we set up an alert to…
-
Bringing a Smartsheet Gantt into Adobe InDesign
Any suggestions for how to export a CRISP image of a Gantt chart from Smartsheet such that I may feature it in an InDesign-produced proposal? I get blurry pdf files and very low-res tiffs. The best I've found is a screengrab which still isn't very sharp.
-
Sumifs with Date Range
Hi there! I'm using Smartsheet to keep track of timelines and allocated ressources called FTEs across multiple projects. I'm trying to figure otut a way using the SUMIFS formula to sum up the usage of FTEs across all projects per month. Currently, I'm using =SUMIFS(FTE:FTE; Projekt:Projekt; "Project A"; Start:Start;…
-
Recurring Tasks Set Up
Is there a way to set up a task that happens every quarter or six months without having to enter the task 4 times in each year?
-
Changing the Color of a Parent Task Bart in Gantt Chart
Smartsheet, It would be nice to be able to change the color of a parent task bar in the Gantt Chart. What is the reason for not being able to do this? I did find a comment (https://community.smartsheet.com/discussion/cannot-format-milestones-summary-bars) that says if dependecies are turned on, then gray is the default…
-
using IF together with AND
Sorry in advance if this has been answered but I have searched and cannot see the answer but I am sure its simple! I have target finish and actual finish columns, in the status column, I want to report "in progress", "overdue" and "Complete" I have got "in progress", "overdue" to work by the following: =IF(TODAY() <…
-
Full Screen View iFrame
Hello... i'm wondering if there's a way to set the default view of a published SMARTSHEET to full screen so that when my team goes to my project webpage and views the embedded SMARTSHEET, it is automatically set to full screen view...? any thoughts ?
-
Date Logic - Weekends versus duration
I'm hoping someone in the community can help me understand the business logic behind the way durations are calculated over weekends in Smartsheet. For context, my sheet has out-of-box settings for working days and hours - Sat and Sun are non-working days, M-F are 8-hour durations. Looking at the attached example, I think…
-
Autofill is working on some formulae in a row and not others
We have been using SmartSheet for about 3 years and have recently developed an approach for our project managers using SmartSheet. We are about to roll it out to our staff but have found an intermittent behaviour that is most troubling. Sometimes, just sometimes, when we insert a new row or add a new row at the end of the…
