-
Hide #INVALID DATA
Hello, I am attempting to calculate the difference between two dates. When one of the dates is missing, the cell where the difference would be shown instead contains "#INVALID DATA". Can anyone please help? I've attached a screenshot. The "Actual Duration" column is the difference between the "Start Date" and "End Date". I…
-
Setting flag when task falls within a date range
At my company we have certain dates when we do not make changes to our website (holidays usually). I'd like to be able to highlight or somehow flag a task if it falls within one of the freeze date ranges. Is there a way to do this?
-
User name display
Hi I am adding new users to smartsheet but would prefer that their first and last names show and not just their email addresses. This happens even if I add them to my contacts? Is there something that I am not doing correctly? which is not allowing the display of their names the way we want it. Any assistance is…
-
Update Request Form
Hi, I am wondering if there is a reason why my update request will not let the user update % Complete. Does anyone have any insight to why it will only allow certain things to be updated? The way the Request is set up is: "On 03/04/19 at 11am In any row where % Complete is less than 100% and Start Date is in the past Send…
-
Smartsheet Excellence - worth it?
Looking into either Smartsheet's excellence training or another bigger picture project management training. Does Smartsheet's excellence courses provide value beyond just the Smartsheet tool? Basically, I'd prefer something I can grow my project management training that doesn't tie me to a specific tool (even though we'll…
-
Copy Rows Between Sheets Based on Checkbox
I am trying to create a calendar or events based off a master list of events on another sheet. The source sheet is a master list of all possible events. That sheet contains a column of check boxes. When a checkbox is checked I would like it to automatically copy that row from the source sheet to the destination sheet. The…
-
Formula for auto flag
I am trying to create an auto flag on a project that says if % complete is <= 80% and the end date is <= 7 days from today then flag. Here is what I have so far =if([% complete]<=0.8,0.5,0)+if([end date] - today()<=7,0.5.0). It turns the flag red when it falls into the not 80% complete in the time frame but when there…
-
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;…
-
How to group sales by representatives in a report?
Hello Smartsheet community! I have a sales sheet where new sales are added each day mentioning the amount and the representative. the sheet doesn't use contact list for representatives, just a simple drop down menu. I want to add a widget to our dashboard showing total sales by representative. I made a report by selecting…
-
Resending Update Requests?
I'd like to be able to resend a pending update request as a reminder to my user. It doesn't appear that I am able to do this. I can view the request. I can delete it. But it doesn't appear that I can "resend it". That said, the "Edit" menu option is greyed out for me when I look at a pending request. Anyone have any…