-
Formula With a date
I am having an issue with creating a formula that will count a column if a row has a date in it. It can be any date just as long as it has a date. PgM Status is the column with the date right now I'm just counting the section that has the dates but would like to create a formula, so I don't have to keep adjusting in the…
-
T-shirt size icons for visual icons?
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 team
-
Data Matrix for dashboard - cross sheet formulas
I have created extensive data matrix's to calculate # of Jobs and dollar amount for individuals in our company to track capacity. However, as our sheets get larger, the formulas wont calculate. I receive an error message reading: "Some cross-sheet formulas cant be updated, because this sheet has more cells referenced from…
-
Integrate with Microsoft Planner
Is there any possibility of Smartsheet integrating with Microsoft Planner? Smartsheet is equipment to manage full portfolio where Microsoft Planner seem to only focus on individual projects. I am a seasoned Project Manager and I need to see all projects at a high level view. Several departments within my organization uses…
-
I Need a Construction Daily Report Template
I am a construction project manager and I am new to Smartsheet and I'm trying to create a Daily Report template. I can search the web for Smartsheet Daily Reports and I find several "templates", which all say "Smartsheet" on them, but they are microsoft excel files. When I try to import them into Smartsheet, they never…
-
Return the NETWORKDAYS of 1 month of a 2-month duration
The goal is to count the number of days that an Employee is not assigned work within a given month (MONTH A, MONTH B, etc). For example, a given month has 23 working days; I could use NETWORKDAYS of the duration to count the assigned days of that Task; say 19. To reach my goal, I would simply subract the NETWORKDAYS from…
-
Formula Needed for Parent to Inherit Child Value
I don't think this is possible, but I need a formula where a parent row Status value reads "No Active Projects" until it has a child row below it with an "In Progress" status at which point the cell should just be blank. See image below. I use the "No Active Projects" marker to determine whether or not that department…
-
Stacked Column Charts
Hi all - I'm in the process of creating my first dashboard and struggling a bit. I'm attempting to create a stacked column chart to show a count of items by both Region and District. For example - Regions 1 through 10 all have 5 Districts within them, and I want to report on how many sales have been closed in each District…
-
Make the rich text editor edit report cells on the dashboard
Greetings everyone, I was wondering if using the rich text widget to edit a cell in your report on the dashboard live is possible. The logic behind it is: The rich text editor is linked to the cell from a report and updates data simultaneously. Thus, I wouldn't need to go back and forth to the report and then to the…
-
How to use Trend Arrows to show change in RYG
Is there a formula that would highlight the trend of a change in RYG balls ? For example, if someone changes the status of a project from Green to Red, it would show a down arrow. If someone changes the arrow from Red to Yellow, it would show a Upward arrow. Thanks for your help!