I'm calculating the variance between dates using the following formula. The problem is that an error is displayed if the Actual Start Date is not populated as show in the screenshot.
Formula used in Variance Start Date:
=NETWORKDAYS([Planned Start Date]3, [Actual Start Date]3) - 1
I am setting up a staffing leave Smartsheet for my team and unfortunately I am getting the #INVALID DATA TYPE error message.
There are 2 formulae set up within the sheet:
Leave Remaining (the dark grey row) is calculated as follows: =[Leave Allowance] - Taken + [Leave Bought] + Carried +
Would love to have S/M/L T-shirt icons to visually look at sizing. This would be helpful as a project manager and on a scrum
I have several projects with many rows of information per project on one master sheet. I use conditional formatting to seperate/identify projects by colour. That colour coding applies to both grid and calendar view nicely. BUT I would like to combine a project code and task name in calendar
I'm linking to someone's Start Date on a project, using the relevant sheet. However, the End Dates I need to track are at the end of a long set of tasks on another sheet - only once all those tasks are completed will this person's time on the project be done. I'd like to link to the very last task
When using 2 predessors for one row, smartsheet calculates the later start date.
How can I manage to get the earlier start date.
For me it sounds like a common requirement. Start as early as necessary to meet 2 alternative deadlines ...
I want to use smartsheet as an international project management tool. One thing is driving me creasy.
I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario.
The task in row 27 needs row 25 & 26 to be done ( active
I was working on a way to track some task hours and minutes... came up with this:
One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore
Hello community! Anyone have a work-around for this? Here's the situation:
I’ve created a vlookup formula in my sheet to obtain an email address from another sheet, and then want to alert someone using the email address result from the formula. When I go to build the condition in the alert (for