i have a room full of storage freezers. Within each freezer there are 4 shelves of four stainless steel containers. Each container contains 32 positions and each position is a project.
is it possible to start with an interactive “map” of the room, where I can click on any freezer, select a
I need help with a formula to automate my RYGGrey. Here are the rules:
If status = complete, grey
If status is in progress or not started and finish is in the past, red
If status is in progress or not started and finish is today + 5 days (within the next 5 days), yellow
If status is in progress or
I am using the formula =COUNTIF(CHILDREN(), 1) + "" to count the total number of checked check boxes. However, The number displayed is 0 when I can clearly see the box is checked in that column.
For other columns it displays a number but not an accurate count of checked boxes within the
I have been trying to figure this out for hours with no luck. We've created a formula to automatically update our status column in our project plan sheets. We have specific parent rows that are designated as milestones. The milestone row status cells should update based on the status of the child
I am working on a customer survey (form) and would like the customer to be able select multiple items in a drop down or have multiple check boxes available in a single column? Is this possible now? Is this in development? I know there a couple of ways to work around this but nothing very elegant
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 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
Hi Everyone, I have a sheet that contains a list of projects. In the sheet I have a column that is setup as a contact column and allows multiple contacts (Project Managers) and a column for project state (State). In my statistic sheet I list all of my project managers(ITPMO ProjectManager) and I
Can someone please explain to me how APIs work ?
I am not familiar with many of the technical jargons used on the SMARTSHEET API link.
I need to update data on my Gantt charts automaticallu instead of manually inputting the numbers and dates. Can APIs be of any help to carry them out ?